User profile for user: synine
synine Author
User level: Level 1
9 points

MySQL Port 3306

I can't get any access to my remote MySQL databases via Port 3306. I'm at a lost as to what to look at. I installed the latest MySQL and have MySQL Administrator working OK. I've used Tinkertool to look at the directories and have /var/mysql/mysql.sock correct (I believe). I've looked at /tmp/mysql.sock and it aliases to /var/mysql/mysql.sock. About a week ago I was able to use Navicat to access remote MySQL databases fine. The only think I can think of is that MAMP may have corrupted something.

I have the same setup and settings on my PC with regards to Navicat and can access all my remote MySQL databases.

TIA

MacBook Pro Mac OS X (10.4)

Posted on Aug 19, 2006 12:27 AM

Reply
9 replies
User profile for user: Joaquim Lopes
Joaquim Lopes
User level: Level 4
3,755 points

Aug 19, 2006 11:24 AM in response to synine

Did you grant access to the user to connect from the host you are using? Probably your user can only access from localhost. To see if this the case connect to the server and then do this:
1- use mysql;
2- select host, user from user;

You will probably get something like this:
----------------+------
| host | user |
----------------+------
| computername.local | |
| computername.local | root |
| localhost | |
| localhost | root |
----------------+------

Hope this helps.
Reply
User profile for user: John McPhail
John McPhail
User level: Level 2
290 points

Aug 19, 2006 11:39 AM in response to synine

I recall that there was a problem with the default install of a particular version of Mysql, where the program referred to /var/tmp/mysql.sock but the config as installed referred to /tmp/mysql.sock. If you look at your my.cnf file ( I don't know where it is on your system ) it may be referring to the wrong path.

Don't know if that's the case here, but it might be worth a look.

Are you using the OS X firewall? If you are, you might need a port open on 3306.
Reply
User profile for user: synine
synine Author
User level: Level 1
9 points

Aug 19, 2006 12:18 PM in response to John McPhail

I couldn't find my.cnf. I'm not using OS X firewall.

A little more details. I just got my MBP 2 weeks ago and used Navicat to download my remote databases onto my MBP. Then used Navicat to move the data into databases on my MBP. There seem to be no problems. The problems arose several days later after I had MAMP running for a few days that I could not acces the remote databases. I have deinstalled Navicat and MAMP to see if that may have done it. Could there be a pref that needs to be deleted as well?

TIA
Reply
User profile for user: Joaquim Lopes
Joaquim Lopes
User level: Level 4
3,755 points

Aug 19, 2006 12:38 PM in response to synine

OK, another information that is vital: are you trying to acces the server running in one computer from another computer using Terminal or MySQL Administrator or are you trying to access the server from, for example, PHP? If you trying the latter then it is not a grant problem but it may be a problem with the new passwords in mySQL.

P.S.: Disregard this post. After I posted I saw that you had solved the problem.

Message was edited by: Joaquim Lopes
Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

MySQL Port 3306

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up