The user bob has been created successfully.įifth, open a second session and log in to the MySQL as bob: mysql -u bob -p Code language: SQL (Structured Query Language) ( sql ) Third, create a new user called bob: mysql> create user identified by 'Secure1pass!' įourth, show all users again: mysql> select user from er ĥ rows in set (0.00 sec) Code language: JavaScript ( javascript ) Second, show users from the current MySQL Server: mysql> select user from er Code language: SQL (Structured Query Language) ( sql ) MySQL CREATE USER exampleįirst, connect to the MySQL Server using the mysql client tool: mysql -u root -pĬode language: SQL (Structured Query Language) ( sql )Įnter the password for the root account and press Enter: Enter password: ******** Code language: SQL (Structured Query Language) ( sql ) To grant privileges to the user, you use the GRANT statement. Note that the CREATE USER statement creates a new user without any privileges.

The IF NOT EXISTS option conditionally creates a new user only if it does not exist. Second, specify the password for the user after the IDENTIFIED BY keywords. If the username and hostname contains special characters such as space or -, you need to quote the username and hostname separately as follows: Code language: SQL (Structured Query Language) ( sql )īesides the single quote ( '), you can use backticks ( `) or double quotation mark ( '). If you omit it, the user can connect from any host.Īn account name without a hostname is equivalent to: Code language: SQL (Structured Query Language) ( sql ) The hostname part of the account name is optional. And hostname is the name of the host from which the user connects to the MySQL Server. The account name has two parts: username and hostname, separated by the sign: Code language: SQL (Structured Query Language) ( sql ) IDENTIFIED BY 'password' Code language: SQL (Structured Query Language) ( sql )įirst, specify the account name after the CREATE USER keywords. Here is the basic syntax of the CREATE USER statement: CREATE USER account_name The CREATE USER statement creates a new user in the database server. Summary: in this tutorial, you will learn how to use the MySQL CREATE USER statement to create a new user in the database server.

Mysql restart server