MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'username' (using password: (Yes)
Posted by: Michael Black
Date: April 18, 2011 10:27PM

I am trying to set up an ODBC connection from my Windows 7 PC to a MySql database. I have downloaded and installed the MySql Connector Ver 5.0.8 (the version for the database on my host site). I have manually edited the .dns to include the server IP, Port, Database Name, user name and password for the user that I set up on the server. The user has been granted insert, update, select and execute privileges on the database.

However, when I try to connect to the database, the DNS pops up the MySql Commector/ODBC form. When I click on Test (all values are filled in as to what is in the .dns file) I get an error "Connection Failed: [HY000][MySql][ODBC 5.1 Driver]Access denied for user <username>@some.ip.address (using password: YES)"

Why is the process picking up an IP address? Should it not just pass the username as it is without any modifications? And when I do add the correct ip address to the end of the user name, it gets truncated.

Thanks in advance.

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
Re: ERROR 1045 (28000): Access denied for user 'username' (using password: (Yes)
April 18, 2011 10:27PM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
August 27, 2009 12:22AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.