后台不能用的 用这个方法改数据库,在虚拟机里运行后输入mysql -uroot -p123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
grant all privileges on *.* to 'root'@'%' identified by '123456';
FLUSH PRIVILEGES;
在虚拟机上
mysql -uroot -p123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
grant all privileges on *.* to 'root'@'%' identified by '123456';
FLUSH PRIVILEGES;