Datasource is not connecting to MySQL

hi all,

My CF server was working fine, but yesterday suddenly stopped working... while verifying connections i found the following error.

========================================
Connection verification failed for data source: kbaseplus
[]java.sql.SQLException: Invalid authorization specification: Access denied for user: 'mehra'@'localhost.localdomain' (Using password: YES)
The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'mehra'@'localhost.localdomain' (Using password: YES)
=============================================

I tried the following in MySQL.

SET PASSWORD FOR 'mehra'@'%' = OLD_PASSWORD('mypassword')

Now all the PHPs are working fine but CFMs are not working and i cannot connect to the databases through CF Admin.

Will be a great help if anyone can help.

regards,

Mehra

Try deleting the data source and recreating it. Confirm that the user and password are correct for the MySQL database.

One other thing that you could try is to stop and then start mySQL which has helped me in the past.

Apart from that has your config file been changed or moved?

Thanks....

Nothing works...

decided to reinstall it...