MySQL ODBC connection error

[Gresford]

Hi.
I have a Macromedia Director application talking to an Access DB via ODBC connection.
Now trying to switch from Access to MySQL as the backend. Have installed MySQL and created DSN fine (I think), and have used MySQL-Front to import data from access. But my connection string is returning the following error:
"VerifyPassword error: -1 users with the same LoginID".
The string I'm using is:
cnnStr = "DRIVER={MySQL};Server=localhost;DB=ExpressTrainDB;UID=root;PWD=admin;"

(The MySQL-Front User Manager window is showing 4 user records:
root@localhost
root@%
@localhost
@%)

I have set root@localhost password to 'admin'.

Any ideas? Sorry if it's something stupid. Haven't used MySQL before.

 

[Gresford]

Sorry. Ignore the above. The error is internal to the application - nothing to do with the connection per se. That is working fine.