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?
User rating:
User rating:
Hi. You should run the following commands:
QRID Login
-- 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
SEND BITCOIN TIPS
User rating:
User rating:
FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.
Boost your productivity with FavScripts.com!
