Create a new user with password in MySQL 8?-Mysql Tutorial-php.cn

Create a new user with password in MySQL 8?

WBOY

Release： 2023-08-30 23:09:02

forward

1395 people have browsed it

在 MySQL 8 中创建一个带有密码的新用户？

In MySQL 8, you need to use the CREATE command to create a new user with a password. Let’s check the version

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.12    |
+-----------+
1 row in set (0.14 sec)

Copy after login

The syntax to create a new user with password is as follows

CREATE USER &#39;yourUserName&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;yourPassword&#39;;

Copy after login

The following is the syntax to grant all permissions to the created user

GRANT ALL ON *.* TO &#39;yourUserName&#39;@&#39;localhost&#39;;

Copy after login

Now use flush Command refresh permissions

flush privileges;

Copy after login

Let us create a new user with the help of the above syntax. The query is as follows

mysql> use MySQL;
Database changed
mysql> CREATE USER &#39;James&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;James123456&#39;;
Query OK, 0 rows affected (0.21 sec)

Copy after login

The following is the query to grant all permissions to the newly created user

mysql> GRANT ALL ON *.* TO &#39;James&#39;@&#39;localhost&#39;;
Query OK, 0 rows affected (0.18 sec)

Copy after login

Let us check if the user has been created

mysql> select user from MySQL.user;

Copy after login

The following is the query to show the new user we created above User's output

+------------------+
| user             |
+------------------+
| Bob              |
| Manish           |
| User2            |
| mysql.infoschema |
| mysql.session    |
| mysql.sys        |
| root             |
| @UserName@       |
| Adam Smith       |
| James            |
| John             |
| John Doe         |
| User1            |
| am               |
| hbstudent        |
| mysql.infoschema |
| mysql.session    |
+------------------+
17 rows in set (0.00 sec)

Copy after login

View the sample output, user James has been successfully created. Now refresh the permissions using refresh command. The query is as follows

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

Copy after login

The above is the detailed content of Create a new user with password in MySQL 8?. For more information, please follow other related articles on the PHP Chinese website!