After importing SQL, the normal user cannot call the stored procedure, root can.
Solve:
mysql> Update Mysql.proc set definer= ' [email protected]% ';
Then modify the Security_type field:
MariaDB [(None)]> update mysql.proc set security_type= ' INVOKER ';
Query OK, 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 | [Email protected]% | 2017-05-20 11:24:57 | 2017-05-20 13:26:45 | INVOKER | | UTF8 | Utf8_general_ci | Gbk_chinese_ci |
CentOS7 Femdom MySQL Two