mysql用户名不存在,指定为定义者的MySQL用户不存在

I am trying to call a stored procedure with php. The previous day this was working, but today i get an error that "The user specified as a definer ('name of the user'@'my ip the previous day') does not exist"

The procedure is located in a host and i grant to my ip access through cpanel's remote MySql.

The code that i used is correct and taken from here http://www.php.net/manual/en/mysqli.quickstart.stored-procedures.php

Does the error occur because my ip is different today, even though i have access again?

How can i solve it?

解决方案

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;