Bug #1916 Crushes on ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL
Submitted: 22 Nov 2003 14:51 Modified: 24 Nov 2003 8:54
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.3-beta OS:Microsoft Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any

[22 Nov 2003 14:51] [ name withheld ]
Description:
*clears throat*

Bug report: MySQL Control Center

Well, after messing around with MySQL users database I have "successfully" managed to lock out localhost. Which is fine, I am reinstalling. First, though, I tried using mysql, mysqlgui, and mysqlcc to get in. The first two: mysql and mysqlgui report that I could not connect with this error:

ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server

But mysqlcc just crushes when attempting to connect to the localhost.

Some things I attemped: 
 Deleting the server registration file under .mysqlcc\connections and then trying to recreate it.

How to repeat:
I was following the instructions here: 
 http://www.mysql.com/doc/en/Windows_running.html

After I completed them, I could not longer login back into the system. And MySQLCC started crushing. 

My general feeling is that it just does not handle the ERROR 1130.
[24 Nov 2003 8:54] MySQL Verification Team
Yes this known MySQLCC bug which crash when can't connect with the
server.
[19 Dec 2004 23:59] Michael Hall
So what?  It's a permanent problem?  I Have Version 2.5.3-rc1  E-mail me at ddaydude@gmail.com
[11 Apr 2006 17:31] Shared Media
You have to add the remote User and his/her IP addy to the DB...

You must grant access to the given user from that client IP address:

#> mysql -u root mysql -p
(If you changed the MySQL Root name and password, type: mysql -h localhost -u my.new.name.I.created -p)

mysql> grant all on test.* to 'username'@'xxx.xxx.xxx.xxx';

You will then be able to access via remote.
[11 Sep 2006 13:30] Jason Schoeman
Shared Media had it 100% right :

I was asked by someone why they cant connect remotely to MySQL with the standard "root" user, do the following :

$ mysql -u root -p

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'xxxxxxx' WITH GRANT OPTION;

Remember you need to create an account with your IP (xxx.xxx.xxx.xxx) as host, this tells MySQL that this user with this IP has permission to remotely access the Database.
[7 Aug 2008 13:16] Ashish bagdiya
This solution is orking thanks.
[22 Oct 2010 12:29] nandeesha ab
Hi,
I am also invoice to mysql but i got solution to this error

In your server , login with server credentials. create new user in "user authentication" . After creation of users you can see the list of users in the left bottom panel. Right click on any user then select "add host from which user can connet" then enter the IP address of the user system from which you want to access the system.

thanks 
Nandy