Can't connect to MySQL server error 111
来源:互联网 发布:网络科学导论 pdf 编辑:程序博客网 时间:2024/06/11 00:58
20down votefavorite
http://stackoverflow.com/questions/1420839/cant-connect-to-mysql-server-error-111
I installed mysql server on linux box IP = 192.168.1.100 but when i try to connect to this IP it alway error(111). but use localhost and 127.0.0.1 is OK.
beer@beer-laptop# ifconfig | grep "inet addr" inet addr:127.0.0.1 Mask:255.0.0.0 inet addr:192.168.1.100 Bcast:192.168.1.255 Mask:255.255.255.0beer@beer-laptop# mysql -ubeer -pbeer -h192.168.1.100ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)beer@beer-laptop# mysql -ubeer -pbeer -hlocalhostWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 160Server version: 5.1.31-1ubuntu2 (Ubuntu)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> beer@beer-laptop# mysql -ubeer -pbeer -h127.0.0.1Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 161Server version: 5.1.31-1ubuntu2 (Ubuntu)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
Connect from another machine it also error 111.
another@another-laptop# mysql -ubeer -pbeer -h192.168.1.100ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
How difference between use localhost/127.0.0.1 and 192.168.1.100 in this case. I don't know how to connect to this database from another machine.
Help please. Thank.
4 Answers
It probably means that your MySQL server is only listening the localhost interface.
If you have lines like this :
skip-networkingbind-address = 127.0.0.1
In your my.cnf configuration file, you should comment them (add a # at the beginning of the lines), and restart MySQL.
Of course, to do this, you must be the administrator of the server.
111 means connection refused, which in turn means that your mysqld only listens to the localhost
interface.
To alter it you may want to look at the bind-address
value in the mysqld
section of your my.cnf
file.
If all the previous answers didn't give any solution, you should check your user privileges.
If you could login as root
to mysql then you should add this:
CREATE USER 'root'@'192.168.1.100' IDENTIFIED BY '***';GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.100' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Then try to connect again using mysql -ubeer -pbeer -h192.168.1.100
. It should work.
If you're running cPanel/WHM, make sure that IP is whitelisted in the firewall. You will als need to add that IP to the remote SQL IP list in the cPanel account you're trying to connect to.
- Can't connect to MySQL server error 111
- ERROR 2002 (HY000): Can't connect to local MySQL server
- ERROR 2002 (HY000):Can't connect to local MySQL server
- Error: Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server
- ERROR 2003 (HY000): Can't connect to MySQL server
- Error: Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 Can’t connect to MySQL server on ‘localhost’
- ERROR 2003 (HY000): Can't connect to MySQL server
- ERROR 2003 (HY000): Can't connect to MySQL server
- ERROR 2003 (HY000): Can't connect to MySQL server
- ERROR 2003 (HY000): Can't connect to MySQL server on
- Can't connect to remote MySQL server with error 61
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
- mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.114' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- CvArr、Mat、CvMat、IplImage、转换
- nodejs event模块
- C语言之strncat函数
- horizon连接数据库
- 用Jdk自带工具keytool生成受信任的证书
- Can't connect to MySQL server error 111
- Oracle学习笔记2
- 修改Calendar日历控件 兼容IE9,谷歌,火狐
- Lucene入门
- LWIP 分析二之udp
- 搭建基于Jenkins+SVN+Maven持续集成环境(CI)
- char转int
- hibernate的优化-抓取(fetch)---张国亮总结心得第三季
- jenkins doesn't exist in the repository svn
skip-networking
line ;-) – Michael Krelin - hacker Sep 14 '09 at 10:54