Error 2003 Hy000 111
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 error 2003 hy000 can't connect to mysql server on 111 more about Stack Overflow the company Business Learn more about hiring developers or error 2003 hy000 can't connect to mysql server on 110 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow error 2003 hy000 can't connect to mysql server on localhost 10061 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 (111) error 2003 hy000 can't connect to mysql server on 113 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: Comment bind-address in my.cnf: # bind-address = 192.168.1.3 Grant privileges: GRANT
Error 2003 Hy000 Mysql Windows
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 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
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 2005 Hy000
this site About Us Learn more about Stack Overflow the company Business Learn error 2002 hy000 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question error 2006 hy000 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 http://stackoverflow.com/questions/11758339/error-2003-hy000-cant-connect-to-mysql-server-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 to http://stackoverflow.com/questions/5713808/trying-to-connect-to-remote-mysql-host-error-2003 MySQL server on '
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other https://ubuntuforums.org/showthread.php?t=2242435 Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [SOLVED] Can't connect to MySQL server on error 2003 'DOMAIN' (111) Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 18 Thread: Can't connect to MySQL server on 'DOMAIN' (111) Thread Tools Show Printable Version Subscribe to this Thread… Display error 2003 hy000 Linear Mode Switch to Hybrid Mode Switch to Threaded Mode September 1st, 2014 #1 Maheriano View Profile View Forum Posts Private Message Iced Almond Soy Ubuntu, No Foam Join Date Jul 2006 Location Calgary, Alberta Beans 1,113 DistroUbuntu 13.04 Raring Ringtail Can't connect to MySQL server on 'DOMAIN' (111) I have a default installation of MySQL on my default Ubuntu server, I haven't really changed any settings after install. The default configuration is to disallow external connections to MySQL and I'm trying to allow external connections so I can connect to it from anywhere, mainly so I can use MySQL Workbench instead of PHPMyAdmin. I've made the necessary changes but it still doesn't seem to work. Here is part of my my.cnf file: Code: [mysqld] # # * Basic Settings # 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 # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. # bind-address = 127.0.0