Access denied for user 'admin'@'localhost' (using password: YES)

[chrisbjohnson]

I keep getting this error on my site. It appears to be a problem with local.xml. It is referencing user: admin@localhost.

However my local.xml file is not telling it to use that user. It is telling it to use the user "magento_2".  

I can resolve it temporarily by adding "skip-grant-tables" to my.cnf and restarting the mysql service, but anywhere between 5 minutes and 5 hours it crashes again. 

I can not figure out where it is pulling the authentication string from. there are no other .xml files is the app/etc/ directory.

The frontend and backend are doing the same thing.

any help would be greatly appreciated.

Thank you

[chrisbjohnson · Accepted solution]

After a few days of working on this I finally resolved it. The local.xml was being loaded from cache.

Once I flushed the magento cache it started reading the correct file.

Hope this helps someone else!

Thanks,

Chris