设置mysql远程连接

需要登录服务端增加远程登录的权限。

 

5.X版本 

 

    1、cd到mysql安装的bin目录下面， 用命令mysql -u root -p 登录到mysql上面。

 

    2、然后用use mysql； 用select user, host from user; 查看当前mysql有哪些用户登录的权限。

 

    3、将root的localhost修改为%

     update user set host = ’%’ where user = ’root’;

 

     4、修改权限

 

     Grant all on *.* to 'root'@'%' identified by 'root用户的密码' with grant option;

     flush privileges;

 

 

PS: mysql8.0执行命令不相同

 

8.0版本

 

1. CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
2.  
   GRANT ALL ON *.* TO 'root'@'%';
3.  
   ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

 

FLUSH PRIVILEGES;

 

参考：

1、

https://blog.youkuaiyun.com/qq_42072311/article/details/86620683?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param

2、

https://blog.youkuaiyun.com/itas109/article/details/84986147?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-1.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-1.channel_param