The following error message is displayed after a system migration/update:
"The user specified as a definer ('admin'@'%') does not exist"
This error can occur after a MySQL Database migration and indicates the user referenced does not exist in the new database. There is a stored procedure located in the DWSystem database, which can be updated to add this user.
- Find the procedure located in your DWSystem database.
- Right-click the Stored procedure, then select "Edit Procedure"
- Update the old definer with the new user of your database, then re-execute the stored procedure.
- Alternatively, you can download MySQL workbench and create the user specified in the error.
Two accounts with the same name should be created. One where the from host value is '%' to match the stored procedure and the other for 'localhost'.
KBA applicable for On-premise Organizations ONLY.