GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
2.进入mysql的BIN目录
mysql -u root -p
mysql>use mysql;
mysql>update user set host ='%' where user ='root';
mysql>flush privileges;
本文介绍如何使用SQL命令为MySQL的root用户分配所有权限,并更新host字段以允许远程连接。此外,还包括了刷新权限缓存的方法。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
2.进入mysql的BIN目录
mysql -u root -p
mysql>use mysql;
mysql>update user set host ='%' where user ='root';
mysql>flush privileges;
645

被折叠的 条评论
为什么被折叠?