MySQL - definer in stored procedure

Question

Hello.

I've written all of MySQL procedures as root@localhost. Code looks like :

CREATE DEFINER=`root`@`localhost` PROCEDURE `p_add_user`(...)

Trouble is, when deploying on online server. When I replace root with current user and replace localhost with current IP, it works just fine. But that is quite annoyance ....

Is there any way, how to write procedures in more abstract way? So someone who will use my database and procedures would not have to edit "root" and "localhost" words?

Thanx

Answer 1

As stated in MySQL documentation here

CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] routine_body

So, the DEFINER part is not mandatory, just CREATE PROCEDURE should work.