1.sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
修改配文件,将bind-address = 127.0.0.1注释,开放所有连接
2.查看权限
(1)登录MySQL
(2)use mysql;
(3)select host, user from user;
如果host不是%,则进行第三步,将host设置为%
3.增加权限
UPDATE user SET Host = ‘%’ WHERe User = ‘root’ AND Host=’localhost’;



