Cannot connect to Mysql using ODBC


#1

Hello,

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 ‘xxxxx@xxxx.com’ to database ‘xxxxx’. The same happens if I try to connect from MS Access.

Does anyone have any idea what the problem could be?

Thanks

David.