When I tried to execute procedure in MySQL database I got this error:
The user specified as a definer ('root'@'%') does not exist
Maybe someone has seen this error too?
Hi. You should run the following commands:
-- Remove current user DROP USER 'root'@'%'; -- Add ROOT user again CREATE USER 'root'@'%' IDENTIFIED BY 'ROOT_PASSWORD'; -- Add permissions GRANT ALL PRIVILEGES ON * . * TO 'root'@'%'; FLUSH PRIVILEGES;
*That error may happen when you try to run some SQL commands as a ROOT user which was imported from another MySQL database
Thanks, it helped me