在安装mysql的机器上运行:
mysql -u root -password
mysql>usemysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
mysql>flush privileges;
本文介绍如何在MySQL中通过更新用户表来设置root用户的主机权限,并刷新权限以使更改生效。
在安装mysql的机器上运行:
mysql -u root -password
mysql>usemysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
mysql>flush privileges;
424

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