Error: The user specified as a definer ('root'@'%') does not exist

$0.3
=
$0.35
+
$0
$0.3 Bitcoin bounty has been announced by author.
$0.35 has been already awarded by author.
$0 remains available.
0

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?

1 Answer - total earned - 1.4 mBTC ($0.35 USD)

1
=
1
=
$0.35
1 tip with total amount of 1.4 mBTC($0.35 USD) have been sent by lampego

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

SEND BITCOIN TIPS

Thanks, it helped me

2

Post Answer


Top 3 Tippers
Recent Tips

Will Bitcoin Tipping become a new Internet Culture?


Please share our story! THANK YOU!