步骤一:
- 1、进入mysql的用户表user,先要设置root可以访问
mysql> update user set host = '%' where user = 'root'; ##若报错,不予理会即可
- 2、修改/etc/mysql/my.cnf(或者/etc/mysql/mysql.conf.d/mysqld.cnf)上bind_addr改为0.0.0.0(或把该行注掉)
mysql> update user set host = '%' where user = 'root'; ##若报错,不予理会即可