is not allowed to connect to this MySQL server解决办法
来源:互联网 发布:阿里云盒子root 编辑:程序博客网 时间:2024/06/05 09:47
ERROR 1130: Host ’192.168.1.3′ is not allowed to connect to this MySQL server这是告诉你没有权限连接指定IP的主机,下面我们来看看解决办法。
处理方法有二个
1、(如何解决客户端与服务器端的连接(mysql) :xxx.xxx.xxx.xxx is not allowed to connect to this mysql serv
) 授权法。例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码
代码如下复制代码GRANT ALL PRIVILEGES ON *.* TO ‘root’@’192.168.1.3′ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO ‘root’@’10.10.40.54′ IDENTIFIED BY ’123456′ WITH GRANT OPTION;
转自:http://www.111cn.net/database/mysql/42040.htm
0 0
- is not allowed to connect to this MySQL server解决办法
- ...is not allowed to connect to this MySql server,解决办法。
- is not allowed to connect to this MySQL server解决办法
- is not allowed to connect to this MySQL server解决办法
- is not allowed to connect to this MySQL server解决办法
- is not allowed to connect to this MySQL server解决办法
- is not allowed to connect to this MySQL server解决办法
- is not allowed to connect to this MySQL server解决办法
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- 链接
- 线索二叉树
- 八皇后问题
- Gradle构建控制Log开关——BuildConfig\自定义
- Android Battery一些信息获取方法
- is not allowed to connect to this MySQL server解决办法
- verilog-for 语句实例
- git 命令(1)
- 欢迎使用CSDN-markdown编辑器
- 滑动返回上一个界面的实现
- 改善 ASP.NET MVC 代码库的 5 点建议
- 宏正ATEN发行最新款双滑轨PS/2-USB双界面LCD控制端
- 我要开始学python了
- 用SQL语句添加删除修改字段、一些表与字段的基本操作、数据库备份等