1修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf

vim mysqld.cnf:

2.重啟數(shù)據(jù)庫，sudo service mysql start;

3.登陸數(shù)據(jù)庫 mysql -uroot -p;

4.使用數(shù)據(jù)庫 use mysql;

5.修改數(shù)據(jù)表user : update user ser host="%" where user ='root' and host ="localhost";

6.刷新緩存 flush privileges.