The Ultimate Guide to High Availability with MariaDB

Comments - CREATE USER

7 years, 2 months ago curtis
Re: CREATE USER

You cannot use variables for the user_specification. If you need to use CREATE USER in a stored procedure, you will need to a set of SET, PREPARE, EXECUTE, DEALLOCATE statements to accomplish this.

See https://stackoverflow.com/questions/11951570/mysql-create-user-with-a-variable for an example.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.