Skip to main content
November 21, 2008
Question

Error message when setting up MySql

  • November 21, 2008
  • 1 reply
  • 295 views
I have created a database using MySQL 4/5 as the driver. I am getting an error saying this:
Connection verification failed for data source pankledb.
java.sql.SQLException: Access denied for user"@'localhost' (using password: NO)
The root cause was that: java.sql.SQLException: Access denied for user "@'localhost' (using password: NO)
What does this mean?
(I am sure the error is coming from the fields that need to be filled in when i create a database in the coldfusion administrator. All that i have filled in at the moment is the CF Data Source name. What else needs to be completed?)
I filled in the CF data source name (pankledb), and I filled in the database as C:\ColdFusion8\db\pankledb

This topic has been closed for replies.

1 reply

BKBK
Community Expert
Community Expert
November 21, 2008
Coldfusion needs a username and password to log to the MySQL database. You may use the root account. However, for security reasons, it is usually recommended to create a non-root account for Coldfusion. Check out the MySQL documentation on how to create an account.