mysql给super权限_mysql – 此操作的SUPER权限

从

documentation(我的重点)：

The SUPER privilege enables an account to use CHANGE MASTER TO, KILL

or mysqladmin kill to kill threads belonging to other accounts (you

can always kill your own threads), PURGE BINARY LOGS, configuration

changes using SET GLOBAL to modify global system variables, the

mysqladmin debug command, enabling or disabling logging, performing

updates even if the read_only system variable is enabled, starting and

stopping replication on slave servers, specification of any account

in the DEFINER attribute of stored programs and views, and enables

you to connect (once) even if the connection limit controlled by the

max_connections system variable is reached.

由于您已经导航到数据库，因此您不需要在存储过程中设置DEFINER属性;添加此行会导致错误显示。如果您删除此语句，您的过程将被创建，您将不会获得权限错误。

如果要为其他用户设置存储过程，则只需要设置DEFINER，默认情况下，存储过程获得相同的安全上下文as the