/t5/coldfusion-discussions/error-message-when-setting-up-mysql/td-p/90758Nov 21, 2008
Nov 21, 2008
Copy link to clipboard
Copied
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
/t5/coldfusion-discussions/error-message-when-setting-up-mysql/m-p/90759#M9007Nov 21, 2008
Nov 21, 2008
Copy link to clipboard
Copied
LATEST
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.