MySQL uses stored procedures to create users

Friday received a small help to develop a friend, need in The MySQL test environment creates a stored procedure that automatically creates a user and asks for help writing.
MySQL version 5.5.17
OS version CentOS 6.4
The contents of the stored procedure are as follows:

DELIMITER//create PROCEDURE cr_user (in P_uname varchar (a), in p_passwd Varachar (+)) begindecalre p_sqlt varchar (1000) ; SET p_sqlt = concat (' Create user ', P_uname, ' identified by \ ', p_passwd, ' \ '); SET @cr_sentence = p_sqlt; PREPARE EC1 from @cr_sentence; EXECUTE EC1; End//delimiter;

A user who has execute and has the Create user right calls this function to create the appropriate user.

This article is from the "DBA Sky" blog, so be sure to keep this source http://kevinora.blog.51cto.com/9406404/1897025

MySQL uses stored procedures to create users