Can't connect to MySQL remotely

JSylvia007 · Posted: Wed Mar 17, 2004 2:37 am Post subject: Can't connect to MySQL remotely

I'm rather new to MySQL, but I believe I have the proper privilages to access it remotely using MySQLFront on my Windows machine from work... but it ALWAYS tells me that the connection failed. Could someone help me to diagnose this problem?

~Jake
_________________
"Yesterday the odds were stacked in favor of my expectations.." Garth Brooks as Chris Gaines

JacobSylvia.com

angelacb · n00b Joined: 31 Oct 2003 Posts: 50

Hi,

did you check if you've bind MySQL to only 127.0.0.1 (localhost) or did you allow any external hosts to connect to such service?

Best Regards,
_________________
Love Linux, Love Life

JSylvia007 · Posted: Wed Mar 17, 2004 3:05 am Post subject:

how would i go about checking that?

~Jake
_________________
"Yesterday the odds were stacked in favor of my expectations.." Garth Brooks as Chris Gaines

JacobSylvia.com

angelacb · n00b Joined: 31 Oct 2003 Posts: 50

Check your mysql config files.

For gentoo, i think it's in:
/etc/mysql/my.cnf

Look for lines like:

JSylvia007 · Posted: Wed Mar 17, 2004 4:39 am Post subject:

what if it's a dynamic IP?

~Jake

EDIT:

I did a quick search of the documentaiton, and found out that (it seems to me) the bind-address = isnt needed, so i commented it out. However, I still get ACCESS DENIED ERRORS...

:-/

EDIT:
I'm an idiot... lol... after i commented out that line... i forgot that I needed to give access to the user from ANY host.... My face is red.... it WAS the bind-address address...

~Jake
_________________
"Yesterday the odds were stacked in favor of my expectations.." Garth Brooks as Chris Gaines

JacobSylvia.com