LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 12-11-2009, 05:57 PM   #1
JeffJustCollect
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. 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
 
Old 12-11-2009, 06:06 PM   #2
Web31337
Member
 
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
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,245

Rep: Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327Reputation: 2327
As it shows here http://dev.mysql.com/doc/refman/5.0/en/create-user.html, 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.
 
  


Reply


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


All times are GMT -5. The time now is 08:19 PM.

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