换IP后MySQL报错:not allowed to connect to this MySQL server
来源:互联网 发布:网络运维招聘 编辑:程序博客网 时间:2024/04/30 08:09
原因:更换ip后,服务器没有授权给这个ip,是不能连接的。
解决方案:运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'10.3.11.26' IDENTIFIED BY 'admin' WITH GRANT OPTION;
解释:允许用户admin从ip为10.3.11.26的主机连接到mysql服务器,并使用admin作为密码
参考:http://blog.csdn.net/llhwin2010/article/details/10035565
0 0
- 换IP后MySQL报错:not allowed to connect to this MySQL server
- IP is not allowed to connect to this MySQL server
- mysql客户端连接时,报错:is not allowed to connect to this MySQL server
- 【MySql】报错:1130-host ... is not allowed to connect to this MySql server
- 远程访问mysql server报错:is not allowed to connect to this mysql
- mysql远程连接报错: Host * is not allowed to connect to this MySQL server,解决方法
- MySQL远程连接报错:Host is not allowed to connect to this MySQL server
- 解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server,MySQL
- mysql报错:1130 -host 'localhost' is not allowed to connect to this mysql server
- 解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server,MySQL
- 报错:1130-host ... is not allowed to connect to this MySql server
- 报错:1130-host ... is not allowed to connect to this MySql server
- 解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server
- 报错:1130-host ... is not allowed to connect to this MySql server
- 报错:1130-host ... is not allowed to connect to this MySql server
- 报错:1130-host . is not allowed to connect to this MySql server
- 报错:1130-Host ... is not allowed to connect to this MySQL server
- 报错:1130-host ... is not allowed to connect to this MySql server
- Redis使用总结之与Memcached异同
- KVM的-nographic与-display选项
- EXT.NET GridPanel的清除所有选择行问题
- hadoop java.io.IOException: Xceiver count 4097 exceeds the limit of concurrent xcievers
- shell 批量获取host
- 换IP后MySQL报错:not allowed to connect to this MySQL server
- JNI: JAVA通过JNI调用另一个JAVA类的方法
- 《android 学习》三、Intent 的概念及应用
- android URL含进度条异步加载简单实例
- vs经验谈.简单描述Eval和Bind的区别
- linux下用ctrl+r快速搜索history命令
- 设计跨平台的项目
- SDL显示的使用
- Spring 的HibernateTemplate 支持配置