MySQL CREATE USER Statement.

Preamble

The CREATE USER statement creates a database account that allows you to log into a MySQL database.

Syntax for CREATE USER statement in MySQL

CREATE USER
user_name IDENTIFIED BY [ PASSWORD ] 'password_value';

Parameters and arguments of the statement

• user_name – the name of the database account you want to create.
• PASSWORD is optional. Whether you specify this parameter or not, the CREATE USER operator will behave identically.
• password_value – The password to assign a user name.

Let’s see how to create a user in MySQL using the CREATE USER operator.

For example:

CREATE USER
'samvel'@'localhost' IDENTIFIED BY 'klondik';

In this example, the CREATE USER operator will create a new user with the name samvel in the MySQL database, whose password is ‘klondik’.

Multiple user creation

You can create more than one user at a time in MySQL. You can use the CREATE USER operator to create multiple users separated by a comma with each user/password.
For example:

CREATE USER
'samvel'@'localhost' IDENTIFIED BY 'klondik',
'serg'@'localhost' IDENTIFIED BY 'titdog';

This example CREATE USER will create two users in MySQL. The first user will be called samvel with password ‘klondike’ and the second user will be called serg with password ‘titdog’.

Using Hash value for password

In the above examples, the open text password is displayed. You also have the option to set a password hash value (see PASSWORD function).
For example:

CREATE USER
'samvel'@'localhost' IDENTIFIED BY '*39C549BDECFBA8AFC3CE6B948C9359A0ECE08DE2';

This example CREATE USER will create a new samvel user in a MySQL database with the password hash value.

MySQL Tutorial; How to Create a MySQL Database, User and Grant Permissions

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.