Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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'm having trouble connecting to a MySQL database on the other machine on the same network.

Could not connect to the specified instance. 
MySQL error number 1130 
Host 'abc' is not allowed to connect to this MySQL server        
(Pinging ok time 1-3 ms ttl =128)

I've checked out the following:

  • TCP/IP enabled
  • RegEdit under hlocal machine .... parameters .. maxUserpORT And timedelay..
  • Grant all . to 'root'@'Myipaddress'
share|improve this question

Isn't grant all to 'root'@'abc' needed in addition to 'root'@'ipaddress of abc'?

share|improve this answer

Have you attempted to use the command "flush Privileges;" for the mySQL database?

share|improve this answer

You need to place a firewall exception to port 3306 or which ever port MySQL is using, otherwise you firewall will block remote access to port 3306.

You may do this from the MySQL Configuration wizard. Also on the connection wizard, it will ask if the "root" would have remote access. Check the box. That's all.

share|improve this answer
If it were a firewall problem, he wouldn't be getting an error message from the server. – T.J. Crowder Jun 1 '10 at 22:43

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.