mysql> select user,host from user;
mysql> flush privileges;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
mysql> flush privileges;
mysql> exit;
完成后退出mysql命令行,返回shell命令行,编辑mysql配置文件
root@root:~# vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释bind-address 127.0.0.1,加一行 bind-address 0.0.0.0
重启mysql服务:
root@root:~# service mysql restart