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

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

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

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

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

mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> 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';