Connect MySQL db to CF on Mac

[jaym66383316]

I am coming back to CF to build an application.  I have not used CF since the Allaire days so there is some learning curve here.

I have started a db in MySql (Workbench) and would like to access via Coldfusion Builder.  I get the error below in the CF Administrator Data Sources tab when I try to add the new db.  I don't actually know how to point CF to the db and there is no browse tool.

Thx

Connection verification failed for data source: M1Connect

java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user ''@'localhost' (using password: NO)

The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user ''@'localhost' (using password: NO)

[jaym66383316]

per another post, i changed the user to "root" and got the following error:

Connection verification failed for data source: M1Connect

java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown database 'myfirstconnection'

The root cause was that: java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown database 'myfirstconnection'