Trouble connecting to MySQL on Mac mini server

Question

Level 1

9 points

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

Answer 1

Feb 17, 2011 5:37 AM in response to timcrawf

Did you check the "Allow network connections" box in Server Admin > MySQL > Settings? If not, you will only be able to connect from localhost.

Reply

Answer 2

timcrawf Author

Level 1

9 points

Feb 17, 2011 9:44 AM in response to Strontium90

Yes, I have that box checked. Sorry, I should have mentioned that.

Reply

Answer 3

Feb 17, 2011 1:51 PM in response to timcrawf

When you say remote host, do you mean a machine that is not the server but is on the same physical network? or do you mean a machine that is not the server and is outside the LAN?

Reply

Answer 4

MrHoffman

Level 10

147,635 points

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

Reply

Answer 5

timcrawf Author

Level 1

9 points

Feb 17, 2011 4:16 PM in response to Strontium90

A second computer that is on the same network.

Reply

Answer 6

timcrawf Author

Level 1

9 points

Feb 17, 2011 4:18 PM in response to MrHoffman

MrHoffman wrote:
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.

The firewall is not running on the server. I have tried with a password set for root, and while leaving it blank.

Reply

Answer 7

MrHoffman

Level 10

147,635 points

Feb 17, 2011 4:56 PM in response to timcrawf

Look in the MySQL log, for any clues that might be there. And recognize that usernames are distinct from and disjoint from the Mac usernames, and you will (also) want to set access privileges within the MySQL database, per that link I included.

Reply

Answer 8

timcrawf Author

Level 1

9 points

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.

Reply