DEV Community

Yegor Shytikov
Yegor Shytikov

Posted on

Magento 2: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('user'@'localhost') does not exist, query was

grant all on *.* to 'theuser123'@'%' identified by 'Magento@1234567' with grant option;

Enter fullscreen mode Exit fullscreen mode

SQLSTATE[HY000] Fixed ...

This happens after moving the DB from one server to another server. Initially, the definer was using localhost and the theuser123. On the new server, we don't have that user(theuser123), and the host had also can be changed.

Magento 2 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('theuser123'@'localhost') does not exist, query was: SELECT

Top comments (0)