bionarm.blogg.se

1. #Mysql create user how to
2. #Mysql create user code

Seventh, go to the session of the user root and create a new database called bobdb: mysql> create database bobdb Įight, select the database bobdb: mysql> use bobdb

#Mysql create user code

Here is the list of databases that bob can access: +-+ġ row in set (0.01 sec) Code language: JavaScript ( javascript ) Sixth, show the databases that bob has access: mysql> show databases Input the password for bob and press Enter: Enter password: ******** The user bob has been created successfully.įifth, open a second session and log in to the MySQL as bob: mysql -u bob -p 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 MySQL CREATE USER exampleįirst, connect to the MySQL Server using the mysql client tool: mysql -u root -pĮnter the password for the root account and press Enter: Enter password: ********

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 create 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: 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: 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: language: SQL (Structured Query Language) ( sql )

Here is the basic syntax of the CREATE USER statement: CREATE USER account_nameĬode language: SQL (Structured Query Language) ( sql )įirst, specify the account name after the CREATE USER keywords. The CREATE USER statement creates a new user in the database server.

#Mysql create user how to

Summary: in this tutorial, you will learn how to use the MySQL CREATE USER statement to create a new user in the database server.