关于MySQL远程连接的一些小问题

之前我提到过如果设置远程连接，传送门

今天我自己用的时候直接查博客来用了，然后发现按照这样设置，远程不能登录，一开始怀疑没刷新，于是直接敲reboot来重启了，后来发现是这样的隐蔽的问题，比如说我root密码原来是root,后来我改成其他（比如说123）了，

然后再按照设置远程登录，发现用root用户，密码123登录不了，

后来本地root账户连接数据库

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from user;
+---------------------+------+
| host                | user |
+---------------------+------+
| %                   | root |
| 127.0.0.1           | root |
| ::1                 | root |
| localhost           |      |
| localhost           | root |
| vm\_61\_130\_centos |      |
| vm\_61\_130\_centos | root |
+---------------------+------+
7 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

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

mysql> show grants for 'root'@'%';
+--------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@%                                                                                                              |
+--------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION |
+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select user,host,password from mysql.user;
+------+---------------------+-------------------------------------------+
| user | host                | password                                  |
+------+---------------------+-------------------------------------------+
| root | localhost           | *67138D0908E294A380CA501A1F1A48898426B13B |
| root | vm\_61\_130\_centos | *67138D0908E294A380CA501A1F1A48898426B13B |
| root | 127.0.0.1           | *67138D0908E294A380CA501A1F1A48898426B13B |
| root | ::1                 | *67138D0908E294A380CA501A1F1A48898426B13B |
|      | localhost           |                                           |
|      | vm\_61\_130\_centos |                                           |
| root | %                   | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+---------------------+-------------------------------------------+
7 rows in set (0.00 sec)

发现本地root的密码（123）和远程登陆的密码不同，远程登录的竟然是旧的root密码（root）

配置没错，重新再改一下root密码就好了

UPDATE user SET Password = PASSWORD('newpassword') WHERE user = 'root';