Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.