MySQL user specified as definer does not exist

mysql, php, web

Solution

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;

Credit to http://www.lynnnayko.com/2010/07/mysql-user-specified-as-definer-root.html

Problem

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?

Original source