Jump to content
Sign in to follow this  
JeffJustCollect

Issue connecting to mysql port 3306

Recommended Posts

I've been trying to create a connection to mysql on a Linux server from Windows XP with MySQL ODBC 3.51 Driver. After setting all of my credentials to test the connection I get the following error. "[MySQL][ODBC 3.51 Driver]Host is not allowed to connect to this MySQL server". After looking up the error most references I found were to firewalls so for testing I disabled my local firewall and retried but got the same error message. I wanted to make sure that the port was open on Linux so I ran netstat -nap on the server and it showed mysql was running on the expected port and listening. I also went to this site to check my port. http://www.yougetsignal.com/tools/open-ports/ and it stated that the port was open.

 

The mysql database is working fine when you are running queries locally but trying to connect from outside of the server is when you run into issues. I don't really know what other steps to take in debugging the problem; any ideas or suggestions would be appreciated. Thanks and let me know if you need any more details about the problem.

 

-Jeff

Share this post


Link to post
Share on other sites

is the firewall on the xp box open both ways ?

Share this post


Link to post
Share on other sites

You will also need to tell mysql to allow remote connections for that account too. Many MySQL accounts are set up to allow connections from localhost, but not other IP addresses, for security reasons (check the "users" table).

 

Note that if you DO want to allow remote connections, then I recommend moving MySQL off the default port or at least securing that port down to a small whitelisted range.

Share this post


Link to post
Share on other sites
Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...