Trouble connecting to MySQL on Mac mini server

Trying to connect to the MySQL server from a remote client. I have "allow network connections" checked, and a password set. When I try to connect from an admin computer, I am told
"Host 'macbookpro.domain.tld' is not allowed to connect to this MySQL server"
The Server setup guide doesn't give much information for MySQL, besides how to turn it on.

What am I missing?

Mac mini server, Mac OS X (10.6)

Posted on Feb 17, 2011 4:23 AM

Reply
8 replies

Feb 17, 2011 2:47 PM in response to timcrawf

Ensure port 3306 is open through the server firewall, and ensure that the user and credentials for the database (which differ from the Mac OS X credentials) have been granted access within the database.

There's a ton of stuff over at the MySQL web site, and there's a posting on getting Sequel Pro to work with MySQL [here|http://labs.hoffmanlabs.com/node/376].

Feb 18, 2011 7:32 AM in response to MrHoffman

I finally found out how to do this using the application Sequel Pro recommended by MrHoffman.
The steps are basically.
1. Start MySQL
2. Install Sequal Pro on the server
3. Launch Sequel Pro and connect
4. From the Choose Database… pop-up, choose mysql
5. Select user in the left sidebar and Content from the Toolbar
6. Select the root user in this table and click the duplicate button below the table (looks like 2 plus signs)
7. Change the "host" field to be something like 192.168.1.%, where the first three octets are the same as your local network. The % is a wild card that allows a connection from any client on the mentioned network.
8. Stop the MySQL service.
9. Start the MySQL service.
10. Install Sequel Pro on your client system and connect.

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.

Trouble connecting to MySQL on Mac mini server

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