1:首先登入MYSQL执行如下:
注意password要改成自己的密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2:修改MYSQL配置文件:
/etc/mysql/my.cnf
或
/etc/mysql/mysql.conf.d/mysqld.cnf
将
bind-address = 127.0.0.1
注释掉
3:重启MYSQL
sudo /etc/init.d/mysql restart