The user specified as a definer (root@’%’) does not exist [How to Solve]

This error message means that the account root @ ‘%’ does not exist. The view creation account corresponding to root user does not exist or has been deleted. It needs to be re created and given permission to use the view normally

grant all privileges on *.* to root@”%” identified by “.”;

flush privileges;

Similar Posts: