报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
来源:互联网 发布:7.0wow mac 插件 编辑:程序博客网 时间:2024/06/06 00:25
MySQL服务器的远程链接设置有两种方法:
一、改表法。
可能是你的帐号不允许从远程登陆,只能在localhost登录。这个时候只要在localhost的那台电脑,登入mysql后,更改
a. bin/mysql -uroot-p密码
b.
c.
(ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 不予理会)
d.
二、授权法。
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALLPRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITHGRANT OPTION;
如果你想允许用户qikai从ip为172.22.254.1的主机连接到mysql服务器,并使用123456作为密码
GRANT ALLPRIVILEGES ON *.* TO 'qikai'@'172.22.254.1' IDENTIFIED BY'123456' WITH GRANT OPTION;
阅读全文
0 0
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- phpmyadmin 1146
- web测试的思考
- JavaScript原生事件委托以及JQuery事件委托on()的代码片段
- 匿名内部类精讲
- 设备树
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- maven编译spark源码
- 数字字符转换成数字
- VMware模拟搭建路由环境
- 解决分频模块modelsim下仿真输出为stx的错误
- 192. Word Frequency。
- freemarker中include与import的区别
- Jquery之选项卡效果
- Spring IOC原理