gravatar

Edmonds Commerce are a UK based E-Commerce web development agency. We are based in Shipley which is in Yorkshire near Leeds and Bradford.

Our primary specialism is Magento and Magento2 and other PHP based E-Commerce platforms such as OpenCart.

In terms of technology we are very strong in PHP, MySQL, Linux, HTML, CSS and Javascript.

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

Oct 11, 2011 · 1 minute read
Category: mysql

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