MYSQL : “THE USER SPECIFIED AS A DEFINER (‘ROOT’@’%’) DOES NOT EXIST”

MYSQL : “THE USER SPECIFIED AS A DEFINER (‘ROOT’@’%’) DOES NOT EXIST”

If you’ve found following error while using mysql database:

The user specified as a definer (‘root’@’%’) does not exist

Then you can solve it by using following :

grant all on *.* to ‘root’@’%’ identified by ‘password’ with grant option;