The user specified as a definer ('root'@'%') does not exist in mysql?


If you found below error while working  with mysql database:

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

Then you can resolve it by executing the  following command in Mysql :

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

Search This Blog

All the rights are reserved to this blog is belongs to me only.. Powered by Blogger.