mysql设置远程登录

vim /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-adress = 127.0.0.1改成0.0.0.0

否则会拒绝127.0.01以外的所有请求

 

授权root在其他ip登录mysql：

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

 

更改root权限：

grant all privileges  on *.* to root@'%' identified by "pwd";

 

最后刷新一下

flush privileges;

退出mysql 后

sudo service mysql restart

 

当无法登录mysql参照如下博客: https://www.cnblogs.com/ldy233/p/12964896.html