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

本文介绍了指定为定义者的MySQL用户不存在的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试使用php调用存储过程.前一天工作正常，但是今天我收到一条错误消息:指定为定义者的用户(前一天的用户名'@'我的ip')不存在"

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"

该过程位于主机中，我通过cpanel的远程MySql授予了我的ip访问权限. 我使用的代码是正确的，并从此处获取: www.php/manual/en/mysqli.quickstart.stored-procedures.php

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 www.php/manual/en/mysqli.quickstart.stored-procedures.php

即使我再次具有访问权限，今天是否也会因为我的IP地址不同而发生错误? 我该怎么解决?

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

推荐答案

如果在使用mysql数据库时发现以下错误: 指定为定义者的用户('root'@'％')不存在 然后，您可以使用以下方法解决此问题:

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;

贷方到 www. lynnnayko/2010/07/mysql-user-specified-as-definer-root.html