SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server

原创 2012年03月30日 18:05:37

例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器,并使用mypassword作为密码

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库,并使用mypassword作为密码

GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server

通过HeidiSQL连接MYSQL数据库报错:  SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this M...

ERROR 1130 (HY000): Host '172.16.0.123' is not allowed to connect to this MySQL server

今天在虚拟机操作数据库发现程序抛出了异常,一开始以为是防火墙阻挡。 因此我本人关掉了所有的防火墙,之后再进行测试发现还是不行。 于是我自己查找问题,借助百度找到了mysql数据库连接不上的错误原因。 ...

报错:1130-host ... is not allowed to connect to this MySql server

今天自己第一次把数据库弄到服务器上去。也很简单,就是直接在服务器上安装mysql,然后导入再本地备份好的数据。好了,设置成功之后,把project里面数据库链接地址中的localhost改为服务器公网...

报错:1130-host ... is not allowed to connect to this MySql server

报错:1130-host ... is not allowed to connect to this MySql server 解决方法: 1。 改表法。 可能是你的帐号不允许从远程登陆,...

mysql报错:1130 -host 'localhost' is not allowed to connect to this mysql server

错误提示:1130 -host ‘localhost’ is not allowed to connect to this mysql server原因:手贱把mysql数据库系统中mysql数据库给...
  • T_P_F
  • T_P_F
  • 2017-08-02 20:57
  • 175

OperationalError: (1130, "Host ... not allowed to connect this MySQL server")

起项目的时候出现以下报错OperationalError: (1130, "Host '172.12.12.12' is not allowed to connect to this MySQL se...

服务器连接错误Host 'XXX' is not allowed to connect to this MySQL server如何解决

Host 'Local' is not allowed to connect to this MySQL server 典型的远程权限问题。问题症结是MySQL 没有开放远程登录的权限。      开...

Host is not allowed to connect to this MySQL server 和 access denied for user 'root'@'localhost' 解决办法

昨天,我让同事连我的数据库,连不上,报错:Host is not allowed to connect to this MySQL server 这个错误之前也见过,意思是说我的 MySQL 服务器不...

Host '***' is not allowed to connect to this MySQL server"

默认情况下,root仅仅允许从localhost和127.0.0.1登录到MySQL

mysql Host 'microsof-80f25e' is not allowed to connect to this MySQL server

重新安装了机器后,运行项目报错:Host '主机名' is not allowed to connect to this MySQL server 控制台信息如下: [2013-08-20 16:1...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)