Cannot connect to Mysql using ODBC


I have installed Mysql ODBC Driver version

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

Does anyone have any idea what the problem could be?