Creating New Data source in codfusion developer

[michaelpan]

I hope someone here can help me! I just installed coldfusion 7 for OSX and got it running. But when I try to add a new datasource ( mySQL 5.0) it gives me this error. I'm very new to this, so I hope someone could fill me in as to what I am doing wrong.

Connection verification failed for data source: myTestData
java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user 'testuser'@'localhost' (using password: YES)"
The root cause was that: java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user 'testuser'@'localhost' (using password: YES)"

[craigkaminsky]

Unless I'm totally spacing on the same issue I had a year ago, you need to download a new/alternate JDBC driver for CFMX 6+ and MySQL (4.1+).

The following tech note still applies and should get you past this error:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253

[LL]

This TechNote may also help: http://www.adobe.com/go/kb400539

[michaelpan]

Thanks for the tip. I got it to work by downloading a different JDBC driver.