Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Having troubles with this and I'm not sure why.. I'm trying to access a mysql database from another server.

I changed the my.cnf file (uncommented the bind-address to access from all):

# Disabling symbolic-links is recommended to prevent assorted security risks
# skip-networking

I set up the user, and the user works: (I know "ALL" is bad, but I'm just trying to get this to work...)


I restarted mysql: /etc/init.d/mysqld restart

I opened up the port from within plesk, and then restarted the whole server. (It's a VPS)

now, when I try and telnet from my desktop, it connects, shows a bunch of garbage text then closes the connection 5 seconds later.

I'm trying to connect with php:


mysql_connect("DOMAIN.COM:3306", "MY_USERNAME", "MY_PASSWORD") or die(mysql_error());
echo "Connected to MySQL<br />";


and I get a "Can't connect to MySQL server" error after a 10 second timeout.

The log files are empty, only showing when I restarted mysqld.

Any ideas or tips on how to troubleshoot this?

share|improve this question

migrated from Feb 14 '13 at 10:51

This question came from our site for professional and enthusiast programmers.

Can you connect by means other than PHP using the same user/pass? – Explosion Pills Feb 14 '13 at 4:46
I tried putty using the telnet feature and it just opens and closes – David Feb 14 '13 at 4:47
Then it sounds like the problem is your mysql server is misconfigured – Explosion Pills Feb 14 '13 at 4:52
I think this link… can help you – Rohit Kumar Choudhary Feb 14 '13 at 5:04
Thanks. I followed everything on that page to a T, but still times out, and telnet shows that garbage text then closes the connection – David Feb 14 '13 at 5:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.