mysql远程无法登陆出现ERROR 2003 (HY000)...解决方法_MySQL
Q: 当在另一台机器上登录MySQL时出现如下错误:
ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (111)
A: 原因是MySQL考虑到安全因素,默认配置只让从本地登录
打开 /etc/mysql/my.cnf 文件,找到 bind-address = 127.0.0.1 修改为 bind-address = 0.0.0.0
重启mysql : sudo /etc/init.d/mysql restart
可参考:
> I've already check my /etc/my.cnf file for a "binding"
> line. Its not
> there. I also found an item online that indicated
> adding:
>
Look for the option "skip-networking". This disables TCP/IP so the
server only accepts local connections via the Unix socket. This sounds
like your situation.
Note that a "could not connect" error means just that. If the problem
was related to user privileges you would get an "access denied" error.
Q: 还一种情况出现类似下面的错误:
ERROR 1045 (28000): Access denied for user 'test'@'x.x.x.x' (using password: NO)
A: 原因是没有给登录用户名设置远程主机登录的权限。
在本地用 root 登录: mysql -u root -p
修改 MySQL 数据库中 user 表中 对应用户名的 Host 字段,将 localhost 改为 %
use mysql;
update user set Host = '%' where User = 'username';
上一篇: php计算2个日期的差值函数分享
下一篇: php模板引擎技术简单实现_PHP
推荐阅读
-
MySQL服务器登陆故障ERROR 1820 (HY000)的解决方法
-
MYSQL ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.210' (111) 解决方法
-
远程连接centos7 上的mysql报(ERROR 2003 (HY000): Can't connect to MySQL server on '168.x.x.x' (10060) )
-
mysql远程无法登陆出现ERROR 2003 (HY000)...解决方法_MySQL
-
mysql远程无法登陆出现ERROR 2003 (HY000)...解决方法_MySQL
-
MySQL数据库远程登录报错:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘192.168.50.134‘ (113)
-
MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL serv_MySQL
-
远程无法连接mysql出现错误的解决方法_MySQL
-
MySQL服务器登陆故障ERROR 1820 (HY000)的解决方法
-
解决mysql登陆时出现“ERROR 2002 (HY000): Can't conne_MySQL