Create, authorize, delete, and change the password of a MySQL user

First, declare that, in general, you need to have the root permission in MySQL to modify the MySQL password and grant permissions.

Note:This operation is performed at the win command prompt, and phpMyAdmin is also applicable.
User: phplamp user database: phplampdb

1. Create a user.

// Log on to MySQL
@> Mysql-u root-P
@> Password
// Create a user
Mysql> insert into mysql. User (host, user, password) values ("localhost", "phplamp", password ("1234 "));
// Refresh the system permission list
Mysql> flush privileges;
In this way, a user named: phplamp password: 1234 is created.

Then log on.

Mysql> exit;
@> Mysql-u phplamp-P
@> Enter the password
Mysql> logon successful

2. Authorize the user.

// Log on to MySQL (with root permission ). I log on as root.
@> Mysql-u root-P
@> Password
// Create a database for the user (phplampdb)
Mysql> Create Database phplampdb;
// Authorize the phplamp user to have all the permissions of the phplamp database.
> Grant all privileges on phplampdb. * To phplamp @ localhost identified by '123 ';
// Refresh the system permission list
Mysql> flush privileges;
Mysql> other operations

/*
If you want to assign some permissions to a user, you can write as follows:
Mysql> grant select, update on phplampdb. * To phplamp @ localhost identified by '123 ';
// Refresh the system permission table.
Mysql> flush privileges;
*/

3. delete a user.
@> Mysql-u root-P
@> Password
Mysql> Delete from user where user = "phplamp" and host = "localhost ";
Mysql> flush privileges;
// Delete the user's database
Mysql> drop database phplampdb;

4. Modify the password of the specified user.
@> Mysql-u root-P
@> Password
Mysql> Update mysql. User SET Password = PASSWORD ('new password') where user = "phplamp" and host = "localhost ";

Mysql> flush privileges;