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.
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Linode Fedora 11 Nginx
no comment
page 72
Linode Fedora 11 Nginx
no comment
page 72
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Auto Sales Slide Effects
no comment
page 7
Mysql Error Nr 1130
no comment
page 76
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mercedes Vins
no comment
page 10
Mysql Error Nr 1130
no comment
page 76
Mercedes Vins
no comment
page 10
1 query every 21976 seconds, updated 1 seconds ago.