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: | |
Category: | MySQLCC | Severity: | S2 (Serious) |
Version: | 0.9.3-beta | OS: | Windows (Windows Server 2003) |
Assigned to: | CPU Architecture: | Any |
[22 Nov 2003 14:51]
[ name withheld ]
[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