1、mysql -u root -pvmware
mysql>usemysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
2、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql:flush privileges;
1、mysql -u root -pvmware
mysql>usemysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
2、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql:flush privileges;