The user specified as a definer ('something'@'somewhere') does not exist +SOLVED

This is post is now quite old and the the information it contains may be out of date or innacurate.

If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub

Today I was working on an oscommerce site and took a backup of their database, created the usual details from their config file on my local mysql and the above error came up (with admin@localhost for what it’s worth).

Upon investigation, a trigger had been created on the database whilst logged in via a different user than the user specified in the config file.

There’s actually a few solutions depending on your needs :- Ensure the user (something@somewhere) is created on your new database installation Delete the trigger (for instance if testing locally and you know it’s not needed) Edit the DB dump file, find the definition of the trigger and change it to the configured user.


Tags: mysqllinuxerrorsolutionuser specified