MySQL Bugs: #1916: Crushes on ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL

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:	Windows (Windows Server 2003)
Assigned to:		CPU Architecture:	Any

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.

Yes this known MySQLCC bug which crash when can't connect with the
server.

So what?  It's a permanent problem?  I Have Version 2.5.3-rc1  E-mail me at ddaydude@gmail.com

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.

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.

This solution is orking thanks.

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