导入SQL后,普通用户不能调用存储过程,root可以。
解决:
mysql> update mysql.proc set Definer='username@%';
然后修改Security_type字段:
MariaDB [(none)]> update mysql.proc set Security_type='INVOKER';
Query OK, 19 rows affected (0.00 sec)
Rows matched: 19 Changed: 19 Warnings: 0
MariaDB [(none)]> show function status;
+---------+-------------+----------+----------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+---------+-------------+----------+----------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| redfish | GetDanHao | FUNCTION | bashen@% | 2017-05-20 11:24:57 | 2017-05-20 13:26:45 | INVOKER | | utf8 | utf8_general_ci | gbk_chinese_ci |