Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-11-2009, 05:57 PM   #1
LQ Newbie
Registered: Dec 2009
Posts: 1

Rep: Reputation: 0
Issue connecting to mySQL port 3306.

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. 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.

Old 12-11-2009, 06:06 PM   #2
Registered: Sep 2009
Location: Russia
Distribution: Gentoo, LFS
Posts: 399
Blog Entries: 71

Rep: Reputation: 65
first things first: you don't really want to open 3306 to entire world, do you?
you need to add your IP to mysql's users database as "hostname". otherwise, yes, you won't be able to contact mysql. i suppose it is meant by that error.
Old 12-13-2009, 07:24 PM   #3
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,329

Rep: Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745
As it shows here, user's are associated with the system(s) they can connect from. You'll need to ensure you have a user entry that matches your client box, or define them using a wildcard.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysqld running and reading for connections on port 3306, no port 3306 found from scan darkenigmaa Linux - Networking 10 07-13-2016 12:53 PM
MySQL not listening on port 3306 mr_sarge Linux - Newbie 14 12-03-2013 05:17 AM
Opening port 3306 archey Linux - Newbie 11 08-24-2009 01:43 AM
Mysql - port 3306 - turn it off rjcrews Linux - Security 5 01-11-2007 01:18 PM
mysql port 3306 bulliver Linux - Security 4 04-17-2003 09:00 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:25 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration