MySQL用户授权从服务器用户登录主服务器(实例)

select user,host,password from mysql.user;

update mysql.user set password=PASSWORD('root') where user='root';
flush privileges;
 

[root@jbxue ~]# mysql -uroot -proot

[root@jbxue ~]# mysql -uroot -proot -h192.168.0.129
ERROR 1045 (28000): Access denied for user 'root'@'jbxue' (using password: YES)

mysql> grant all on *.* to root@192.168.0.130 identified by "root";

mysql> select user,host,password from mysql.user;
+--------+---------------+-------------------------------------------+
| user   | host          | password                                  |
+--------+---------------+-------------------------------------------+
| root   | localhost     | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root   | h1            |                                           |
| root   | 127.0.0.1     |                                           |
|        | localhost     |                                           |
|        | h1            |                                           |
| hive   | %             | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| hive   | localhost     | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| myhive | localhost     | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root   | 192.168.0.130 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+--------+---------------+-------------------------------------------+
9 rows in set (0.00 sec)
 

[root@jbxue ~]# mysql -uroot -proot -h192.168.0.129