Connect MySQL db to CF on Mac

Question

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 · Answer

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'

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded