March 9, 2010

MySQl Error Nr. 1130

I had this same problem:

Mark Brown’s Blog

I tried to log in using the sql admin tool after the install. Typed in the ip address of the MySql Server, username and password, but it threw this error:

Could not connect to host
MySQl Error Nr. 1130
Host ‘192.168.1.103′ is not allowed to connect to this MySQL server

But I think my solution is more simple.

I have Fedora 11 here at home and Fedora 11 on my Linode VPS in Dallas. Probably like you, I was thinking: OK my VPS needs to know the IP of my machine here at home. The answer is: no, not really.

From /usr/bin on your VPS: mysql -u root -p

Enter your password. Then try this…

mysql> CREATE USER ’somebody’@'%’ IDENTIFIED by ‘yourpass’;

Then it says “0 rows affected’ which isn’t very helpful IMO (sounds like an error to me!) but apparently that means it worked. That’s it. Type ‘quit’ and now you can log in remotely with MySQL Administrator and edit your users with the GUI.