Error 2003 Hy000 Can Connect
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 error 2003 hy000 can't connect to mysql server on 110 this site About Us Learn more about Stack Overflow the company Business Learn
Error 2003 Hy000 Can't Connect To Mysql Server On Localhost 10061
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question error 2003 hy000 can't connect to mysql server on 113 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 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 111 Trying to connect to remote MySQL host (error 2003) up vote 22 down vote favorite 4 I have a MySQL instance running on a Debian server and I can connect to it locally with no problems. However, I am unable to connect to it remotely. When I try this from my command line I get the following error: ERROR 2003 (HY000): Can't connect
Error 2003 Hy000 Mysql Windows
to MySQL server on '
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 error 2005 hy000 site About Us Learn more about Stack Overflow the company Business Learn more error 2002 hy000 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Error 2006 Hy000
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 2003 http://stackoverflow.com/questions/5713808/trying-to-connect-to-remote-mysql-host-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 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: http://stackoverflow.com/questions/11758339/error-2003-hy000-cant-connect-to-mysql-server-111 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 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 ho
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 http://superuser.com/questions/606267/error-2003-hy000-cant-connect-to-mysql-server-on-127-0-0-1-111-despite Learn more about hiring developers or posting 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 ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' error 2003 (111) [despite commenting out bind-address & skip-networking] up vote 0 down vote favorite Okay, so disclaimer: I'm an absolute mysql noob. Gimme any other development type area and I'm fine. So, I just started using Ubuntu 12.04 an setup mysql. Never really used localhost since we have a staging environment at work that I usually access. However, a client had a really large DB dump that I needed to access and I didn't want to put error 2003 hy000 in on the server for everyone to deal with so I tried to use localhost Whenever I try to access it through MySQL Workbench I get an error so I had a look at a couple of articles online and tried a couple of different things but if I run the following command in the terminal, I get an error: mysql -u root -p -h 127.0.0.1 Produces the following ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) However, if I access mysql like so: mysql -u root -p and then enter my password, I can access mysql fine. Here's what /etc/mysql/my.cnf contains at the moment (I've tried looking for other versions of this file). I've left out all the commented out bits for brevity's sake. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/ linux ubuntu mysql mysql-workbench share|improve this question asked Jun 11 '13 at 10:55 Kyle O'Brien 11011