I have installed Mysql ODBC Driver version 3.51.11.00
I have created a System DSN, and entered the Hostname, User, Password & Database.
I have edited my dreamhost mysql user to allow access from my pc ip address.
If I click Test on the Mysql ODBC client, it says “Success; connection was made!”.
When I try to connect using an ODBC Test program, I get the following error "Access denied for user ‘firstname.lastname@example.org’ to database ‘xxxxx’. The same happens if I try to connect from MS Access.
Does anyone have any idea what the problem could be?