A
A
Aleksey Ratnikov2016-01-19 18:21:33
MySQL
Aleksey Ratnikov, 2016-01-19 18:21:33

The user specified as a definer does not exist, what should I do?

There is the following situation:
I create a procedure, explicitly specifying DEFINER=`username`@`ip_address` and SQL SECURITY INVOKER, but when it is called, it swears that

The user specified as a definer `username`@`%` does not exist
(I emphasize, here he swears at another user, and not the one that was specified in DEFINER). That is, it seems to ignore the DEFINER and SQL SECURITY parameters.
ALTER PROCEDURE... SQL SECURITY INVOKER and procedure re-creation do not help.
It appears in information_schema with the correct DEFINER and SQL SECURITY options.
Who faced such trouble?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Aleksey Ratnikov, 2016-01-20
@mahoho

I contacted the admin, these were the nuances of hosting.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question