Re: ERROR 1045 (28000): Access denied for user 'username' (using password: (Yes)

[Michael Black]

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.