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.
Go to 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!