MySQL : The user specified as a definer (‘root’@’%’) does not exist
This error occurs when exporting views/triggers/procedures from one database or server to another as the user that created that object no longer exists.
So here are the solutions:
- Change DEFINERCreate the missing user
- Create the missing user
or simply run following query
grant all on *.* to ‘root’@’%’ identified by ‘password’ with grant option;
Hope it helps.
Categories: ASP.NET
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Comments