I've created a development copy of one of my Magento sites so I can do a test upgrade on it.
When you try to add something to the cart I get this error message
SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user oldusername@localhost'
It gives the old username in the error message but I have changed all these details within app/etc/local.xml
I've cleaned all the cache and turned it off and wiped all session data too but I still get the same error.
Ive done a grep -ir oldusername on the entire Magento file system but cant find any reference to the old details and also searched the database but cant find anything.
Ive also cleared all cookies and cache from my browser and tried on a fresh browser too but get the same error.
Is there anywhere else that the database connection details are stored other than local.xml?