[文章作者:狂奔的鹿 本文版本:v1.0 转载请注明原文链接:http://dynamiclu.iteye.com/]
近期, 用mysqld_multi开了几个mysql实例,mysql版本5.5.8;
然后授权:
GRANT ALL PRIVILEGES ON *.* TO 'lsl'@192.168.0.1 IDENTIFIED BY 'lusonglin' WITH GRANT OPTION;
客户端连接报错
could not be resolved: getnameinfo() returned error (code: -3).
如下图:
google里baidu了很久,没找到相关的中文解释原因。
在老外的坛子里发现如下方式:
Try the followng in that order to resolve:
1> At the console of the box on which mysql server is running type mysql -uroot -p
2> It will prompt you for root pasword is it was set. Once insidew mysql command shell type
user mysql;
3> now type the following command:
grant all privileges on *.* to '<username>'@'<IP>' identified by '<password>';
In above command replace <username> with the username you want for connection.<IP> with the IP of the host from where you want the permission to connect to this mysql server(in you case this shall be 192.168.1.2) You can also use 192.168.% to allow connection from all IP that begin eith 192.168. Similarly replacing <IP> with just % will allow connection from all hosts for this username. Replace <password> with the password you want.
4> type this command:
flush privileges;
大概意思是也要授权192.168.% 操作:
GRANT ALL PRIVILEGES ON *.* TO 'lsl'@'192.168.%' IDENTIFIED BY 'lusonglin' WITH GRANT OPTION;
客户端再连一下,果真OK了。
注:配置文件上需加skip-name-resolve参数,不然也会出现同样错误
[文章作者:狂奔的鹿 本文版本:v1.0 转载请注明原文链接:http://dynamiclu.iteye.com/]
- 大小: 35.7 KB
分享到:
相关推荐
1.120119 16:26:04 [Warning] IP address ‘192.168.1.10’ could not be resolved: Name or service not known 2.120119 16:26:04 [Warning] IP address ‘192.168.1.14’ could not be resolved: Name or service ...
Android NDK *** could not be resolved
赠送jar包:error_prone_annotations-2.0.18.jar; 赠送原API文档:error_prone_annotations-2.0.18-javadoc.jar; 赠送源代码:error_prone_annotations-2.0.18-sources.jar; 赠送Maven依赖信息文件:error_prone_...
Could not resolve dependencies for project ****:jar:0.0.1-SNAPSHOT: The following artifacts could not be resolved: com.sun.jdmk:jmxtools:jar:1.2.1, com.sun.jmx:jmxri:jar:1.2.1: Could not transfer ...
Eclipse中出现Type 'xxxx' could not be resolved简单粗暴的处理方法
- 0000712: raise error if Form owner is not either TUniGUIApplication or TApplication - 0000609: TUniTimer: Attach to TUniScreenMask - 0000703: TUniDBLookUpxxx bug when datasource and datafield are ...
ORA-27303: additional information: MTU could not be verified. Did not receive valid message. These errors are caused by more aggressive checking introduced in 10.2.0.4. Likelihood of Occurrence ...
官方离线安装包,亲测可用。使用rpm -ivh [rpm完整包名] 进行安装
ansible systemd-resolved 角色 systemd-resolved角色旨在与Debian发行版一起使用。 Ansible Galaxy用户可以使用以下命令添加 systemd-resolved 角色: ansible-galaxy install damex.systemd_resolved 您可以在...
NULL 博文链接:https://lyh7609.iteye.com/blog/516672
激光雷达经典著作,所有章节。
1.120119 16:26:04 [Warning] IP address ‘192.168.1.10’ could not be resolved: Name or service not known 2.120119 16:26:04 [Warning] IP address ‘192.168.1.14’ could not be resolved: Name or service ...
官方离线安装包,亲测可用。使用rpm -ivh [rpm完整包名] 进行安装
主要介绍了详解 问题:HttpServlet cannot be resolved to a type的相关资料,需要的朋友可以参考下
Could not resolve dependencies for project ****:jar:0.0.1-SNAPSHOT: The following artifacts could not be resolved: com.sun.jdmk:jmxtools:jar:1.2.1, com.sun.jmx:jmxri:jar:1.2.1: Could not transfer ...
测试类报错Test cannot be resolved to a type-附件资源
cocos The import com.loopj cannot be resolved 是缺失了jar包。导入lib文件夹,或者刷新eclipse就好了。
jce.jar/jsse.jar解决The import javax.crypto cannot be resolved的问题
NULL 博文链接:https://sxse.iteye.com/blog/962843