Views:

Behavior:
The following error message is displayed after a system migration/update:

"The user specified as a definer ('admin'@'%') does not exist" 

Solution:
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. 

  1. Find the procedure located in your DWSystem database. 

    sp_DWLogging


     
  2. Right-click the Stored procedure, then select "Edit Procedure"


     
  3.  Update the old definer with the new user of your database, then re-execute the stored procedure.



     
  4. 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 is applicable for On-premise Organizations ONLY.

This article is valid for DocuWare versions: 7.5, 7.6, 7.7, 7.8, 7.9, 7.10, 7.11, The user specified as a definer ('admin'@'%') does not exist, MySQL