指定为定义者的MySQL用户不存在 [英] MySQL user specified as definer does not exist

问题描述

我正在尝试使用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访问权限. 我使用的代码是正确的，并从此处获取: http://www.php.net/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 http://www.php.net/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; 

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

这篇关于指定为定义者的MySQL用户不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！