mysql远程访问权限开启

1、登陆mysql数据库

mysql -u root -p
Enter password: ****

查看user表

mysql> use mysql
Database changed
mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+

实现远程连接(授权)

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

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

mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| %         | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+

host字段的值改为%就表示在任何客户端机器上能以root用户登录到mysql服务器

测试连接

本机ip地址和Linux上的需要访问mysql的服务器的ip要在 192.168.200同一网段下