1.

执行update mysql.proc set DEFINER='root@%' WHERE NAME='p_update_rim_batch_log' AND db='otherdataonline';

NAME：函数名字、不填所有的

DB：所属的数据库

DEFINER：那个用户

2.

mysql> CREATE USER 'dxroot'@'%' IDENTIFIED BY 'root

'; 

Query OK, 0 rows affected

mysql> GRANT all privileges ON dxjr.* TO 'dxroot'@'%' ;

Query OK, 0 rows affected

mysql> flush privileges;

Query OK, 0 rows affected

mysql> show grants for dxroot;

+-------------------------------------------------------------------------------------------------------+

| Grants for dxroot@%                                                                                   |

+-------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'dxroot'@'%' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' |

| GRANT ALL PRIVILEGES ON `dxjr`.* TO 'dxroot'@'%'                                                      |

+-------------------------------------------------------------------------------------------------------+

2 rows in set

mysql>