Linux下mysql增加远程连接用户

//查看运行情况

# ps -ef |grep mysql

//连接mysql 

mysql -u root -p

//输入密码

//显示数据库，赋权限。刷新配置

mysql> show databases

    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |   |
| mysql              |
| performance_schema |
+--------------------+
7 rows in set (0.00 sec)




mysql> use mysql
Database changed
mysql> select user,password,host from user;




mysql> grant all privileges on *.* to root@"172.20.184.218" identified by "密码";
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)


mysql> select user,password,host from user;
+------------------+-------------------------------------------+-----------------+
| user             | password                                  | host            |
+------------------+-------------------------------------------+-----------------+
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | localhost       |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 127.0.0.1       |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | ::1             |           |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 172.20.184.218  |
+------------------+-------------------------------------------+-----------------+
12 rows in set (0.00 sec)


mysql> grant all privileges on *.* to root@"GeneralMou" identified by "密码";
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


mysql> select user,password,host from user;
+------------------+-------------------------------------------+-----------------+
| user             | password                                  | host            |
+------------------+-------------------------------------------+-----------------+
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | localhost       ||
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 127.0.0.1       |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | ::1             |             |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 172.20.184.218  |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | generalmou      |
+------------------+-------------------------------------------+-----------------+
13 rows in set (0.00 sec)


mysql> grant all privileges on *.* to root@"218.56.42.148" identified by "密码";
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


mysql> select user,password,host from user;
+------------------+-------------------------------------------+-----------------+
| user             | password                                  | host            |
+------------------+-------------------------------------------+-----------------+
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | localhost       | |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 127.0.0.1       |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | ::1             |            |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 172.20.184.218  |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | generalmou      |
| root             | *5010744E69D9E83A099DC2A309F119257CCE7EA5 | 218.56.42.148   |
+------------------+-------------------------------------------+-----------------+
14 rows in set (0.00 sec)



mysql>  show variables like '%max_connection_errors%';
Empty set (0.00 sec)


mysql> flush hosts;
Query OK, 0 rows affected (0.00 sec)


mysql>