先cd进入mysql 的bin目录下
1、mysql -u root -p
2、use mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '*******' WITH GRANT OPTION;
flush privileges;
select host,user from user;
先cd进入mysql 的bin目录下
1、mysql -u root -p
2、use mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '*******' WITH GRANT OPTION;
flush privileges;
select host,user from user;