Submitted by brucelet on Wed, 07/28/2010 - 09:00
I am unable to connect remotely to MySQL with an ODBC connection. It keeps giving me a Host xxx.xxx.xxx.xxx is not authorized to connect message. I have added the IP address to both the User Permissions and Host Permissions for the database and database user. Any ideas?
Status:
Active
Comments
Submitted by andreychek on Wed, 07/28/2010 - 09:49 Comment #1
Yeah, that's the error I'd expect to see if that particular user weren't setup to allow your IP address, but it sounds like you added that.
Just to make sure there's not something strange going on, can you take a look and make sure it's still listing your IP address as allowed?
If you select your domain from the drop down on the top-left, then go into Edit Databases -> Remote hosts, do you see your IP address still listed in there?