Mysql Error 2003 Ubuntu Server
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about error 2003 (hy000): can't connect to mysql server on (113) Stack Overflow the company Business Learn more about hiring developers or posting ads
Error 2003 Hy000 Can T Connect To Mysql Server On 110
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow error 2003 hy000 can t connect to mysql server on 111 is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) up vote
Error 2003 (hy000): Can't Connect To Mysql Server On (60)
69 down vote favorite 18 I use the following command: mysql -u root -h 127.0.0.1 -p and the error message is : ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) Who can help me to fix it? mysql mysql-error-2003 share|improve this question edited May 21 '15 at 3:21 hello_there_andy 1,169837 asked Nov 4 '09 at 12:37 Charlie Epps 1,07152333 2 Is mysql daemon running? Have yot error 2003 (hy000): can't connect to mysql server on remote got a firewall? Can you telnet to mysql the default port is 306 so - telnet localhost 3306 –Mark Nov 4 '09 at 12:42 the mysql daemon is running. I'm sure. –Charlie Epps Nov 4 '09 at 12:43 Is it just me or if you're connecting to the local mysql server you don't need to specify the host e.g. mysql -u root -p should work? –RMcLeod Nov 4 '09 at 14:18 just to make sure, you are trying to connect to the db server locally? –John Kane Jun 10 '11 at 18:30 Error 2003 is detailed here: webyog.com/faq/content/23/15/en/… –Ashwin A Aug 6 '12 at 12:12 | show 1 more comment 13 Answers 13 active oldest votes up vote 127 down vote If you are using ubuntu, you have to use the following steps to avoid this error: run the command vim /etc/mysql/my.cnf comment bind-address = 127.0.0.1 using the # symbol restart your mysql server once. Update In Step 1, if you cannot find bind-address in the my.cnf file, look for it in /etc/mysql/mysql.conf.d/mysqld.cnf file. share|improve this answer edited Feb 9 at 0:51 Umar Farooq Khawaja 3,0352041 answered Apr 23 '13 at 8:21 Justin Vincent 1,396265 7 Thank you!
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more
Mysql Error 2003 Can't Connect To Mysql Server
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Error 2003 (hy000): Can't Connect To Mysql Server On (61)
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each error 1130 (hy000): host is not allowed to connect to this mysql server other. Join them; it only takes a minute: Sign up ERROR 2003 (HY000): Can't connect to MySQL server (111) up vote 19 down vote favorite 3 This question is related to the following questions: Can't connect to MySQL http://stackoverflow.com/questions/1673530/error-2003-hy000-cant-connect-to-mysql-server-on-127-0-0-1-111 server error 111 Trying to connect to remote MySQL host (error 2003) I am configuring a new MySQL (5.1) server on my local machine. I need to provide remote access to the database. I did the following steps: Comment bind-address in my.cnf: # bind-address = 192.168.1.3 Grant privileges: GRANT ALL PRIVILEGES ON *.* TO 'nickruiz'@'%' IDENTIFIED BY PASSWORD 'xxxx'; Set port forwarding on router (TCP and UDP, port 3306, 192.168.1.3) Configure iptables for firewall sudo iptables -I http://stackoverflow.com/questions/11758339/error-2003-hy000-cant-connect-to-mysql-server-111 INPUT -p udp --dport 3306 -j ACCEPT sudo iptables -I INPUT -p tcp --dport 3306 --syn -j ACCEPT sudo iptables-save Restart mysql server sudo /etc/init.d/mysql restart When testing, I get the following: LAN: mysql -h 192.168.1.3 -u nickruiz -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 95 Server version: 5.1.63-0ubuntu0.11.04.1 (Ubuntu) Remote: mysql -h 1xx.xx.4.136 -u nickruiz -p ERROR 2003 (HY000): Can't connect to MySQL server on '1xx.xx.4.136' (111) Clearly there's something wrong that's preventing me from being able to use my global IP address. Notes: I've tried testing the remote connection on the same machine and also via SSH from a remote machine. I'm not sure if my ISP has given me a static IP. Any ideas? Update: telnet doesn't seem to be working. telnet 192.168.1.3 3306 Trying 192.168.1.3... Connected to 192.168.1.3. Escape character is '^]'. E 5.1.63-0ubuntu0.11.04.1,0g8!:@pX;]DyY0#\)SIConnection closed by foreign host. mysql linux remote-access mysql-error-2003 share|improve this question edited Apr 11 '14 at 12:35 Ward Muylaert 449319 asked Aug 1 '12 at 11:33 Nick Ruiz 65731125 1 You don't have skip-networking in your my.cnf, do you? –Michael Berkowski Aug 1 '12 at 12:18 And telnet 192.168.1.3 3306. If it opens any sort of prompt, the the port is listening and accepting connections. –Michael Berkowski Aug 1 '12 at 12:19 No skip-networking in my.cnf.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting http://superuser.com/questions/205135/sql-error-2003-cant-connect-to-mysql-server-on-x-x-x-x-10051-what-doe ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) - What does this error mean? up vote 0 down vote favorite I error 2003 get following error when i try to connect via "HeidiSQL" to my database server (local network) SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) SSH Connection via Putty works fine. I checked the my.cnf file on the server (Ubuntu), but settings like bind_address are correct. Is it possible that my wireless modem (SpeedTouch) makes this trouble? (Because my provider changed the download speed) ! ubuntu mysql database share|improve this question edited Aug 29 '13 at 21:07 Hennes 51.1k776121 asked Oct 30 connect to mysql '10 at 11:14 BeeS 111 you check heidi forums? heidisql.com/forum.php?t=5428 –Tommy Sep 14 '11 at 22:57 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote If you can't connect to your server directly, but can connect through a SSH tunnel then usually the server is just only listening on localhost. As far as I know, that is the default on Ubuntu system. When you say the bind-address is "correct", then I assume you changed it to your public IP address. In that case, make sure you restarted mysqld after you made that change. Additionally, the listening port (3306 by default) could be blocked in ufw or some other firewall in place. share|improve this answer answered Nov 5 '10 at 14:15 Oliver Salzburg♦ 56.3k36185245 +1 for firewall. Also quite likely that skip-networking is enabled in the config. –Garrett Nov 15 '11 at 17:34 Ubuntu's default is to just listen on localhost, not to have skip-networking –cpast Jan 2 '13 at 5:38 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged ubuntu mysql database or ask your own question. asked 5 years