将bind-address注释
vim /etc/my.cnf
mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql>FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)
说明:【想要root用户使用密码123456从任何主机连接到mysql服务器】
原文：https://www.cnblogs.com/wanghaokun/p/9154739.html