临沂网站制作平台,12389举报网站建设项目,至尊传奇手游官方正版下载,wordpress 文章目录解决方法#xff1a;1。改表法。可能是你的帐号不允许从远程登陆#xff0c;只能在localhost。这个时候只要在localhost的那台电脑#xff0c;登入mysql后#xff0c;更改mysql 数据库里的 user 表里的 host项#xff0c;从loc…解决方法1。改表法。可能是你的帐号不允许从远程登陆只能在localhost。这个时候只要在localhost的那台电脑登入mysql后更改mysql 数据库里的 user 表里的 host项从localhost改称%(需要重启server)mysql -u root -pvmwaremysqlusemysql;mysqlupdate user set host % where user root;mysqlselect host, user from user;2.授权法。例如你想myuser使用mypassword从任何主机连接到mysql服务器的话。GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY mypassword WITHGRANT OPTION;如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器并使用mypassword作为密码GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BYmypassword WITH GRANT OPTION;方法二错误代码是1130ERROR 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server 是无法给远程连接的用户权限问题给用户授权我用的用户是root 密码123456首选语法为:Sql代码GRANT ALL PRIVILEGES ON *.* TO myuser% IDENTIFIED BY mypassword WITH GRANT OPTION;示例:Sql代码GRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY 123456 WITH GRANT OPTION;执行完后,再mysql:flush privileges;刷新一下权限就可以了,不用重启完整操作:开始-运行-cmdcd\cd mysql安装目录\binmysql -u root -p123456;mysql GRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY 123456 WITH GRANT OPTION;mysql flush privileges;
