create user with procedure in mysql

Question

I try to create a user account mysql with a procedure but is not working the problem is the procedure is not call the variable username you have an idea please

CREATE PROCEDURE databaseA.Test(username varchar(255))
CREATE USER username@'localhost' IDENTIFIED BY 'test';

CALL TEST("Admin2")

MySQL a répondu: Documentation

1396 - Operation CREATE USER failed for 'username'@'localhost'

@KrzysztofTrzos Trzos in phpmyAdmin the error is CALL TEST("Admin2") MySQL a répondu: Documentation #1396 - Operation CREATE USER failed for 'username'@'localhost' — Rami
– Rami, Commented Nov 13, 2014 at 19:57
I don't know if You can create users in that way. It's returning error, because You have created "username" user earlier with that procedure. It's getting user name from name of the variable. If You will change username on xxx (for example), it would create user xxx@localhost. — Jazi
– Jazi, Commented Nov 13, 2014 at 20:45

Rami · Accepted Answer · 2014-11-14 20:12:11Z

1

my solution to this problem, I hope that will help you :

CREATE PROCEDURE DatabaseA.Test(IN username varchar(100), IN pwd varchar(255))
  BEGIN
    SET @createUserCMD = concat('CREATE USER ''', username, '''@''', 'localhost', '''IDENTIFIED BY ''', pwd, ''';');
    PREPARE createUserStatement FROM @createUserCMD;
    EXECUTE createUserStatement;
    DEALLOCATE PREPARE createUserStatement;   
  END//

answered Nov 14, 2014 at 20:12

Rami

731 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create user with procedure in mysql

1396 - Operation CREATE USER failed for 'username'@'localhost'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1396 - Operation CREATE USER failed for 'username'@'localhost'

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related