Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can't seem to connect to my remote MySQL server on my home network.

I have started the MySQL process on my Mac mini Server running 10.6.2 Snow Leopard Server.

I have downloaded Navicat lite to manage my database.

This works fine when I run Navicat on the actual server, it says connection successful.

When I run it from another machine though, giving it the server IP address, it says "Host '' is not allowed to connect to this MySQL server".

I have already commented out the "skip-networking" line of the my.cnf file.

I have also added the line "bind-address =" which is the address of my server (as advised by my googling for help).

Anything else I need to be doing? Basically I want to manage the server remotely.

Thanks in advance.

share|improve this question
up vote 1 down vote accepted

you need to give mysql permissions for a user from that machine something like grant SELECT, UPDATE, on database.* to user@ identified by password;

share|improve this answer
thanks Catherine. And I so this from the mysql> prompt yes? – Thomas Browne Dec 28 '09 at 16:29
Yes, from the mysql> prompt. Also, please note that there are a lot of place holders in that command. You can get the full syntax of the command at – Catherine MacInnes Dec 28 '09 at 16:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.