CentOS7 下调教mysql记实 之二

导入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 |