weixin_39414433的博客

1.进入mysql命令行执行： mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION; mysql>FLUSH PRIVILEGES; 2.然后修改mysql配置文件：vim /etc/mysql/mysql.conf.d/mysqld.cnf，找到并将bind-address =127.0.0.1（大概在44行）注释掉： #bind-address