At the WIN command prompt mysql user creates authorizes deletes and password changes

First of all, we need to declare 1:1. Generally, the modification of MySQL password and authorization requires the permission of root in mysql.
Note: this operation is at the WIN command prompt, and phpMyAdmin also applies.
User: phplamp user database: phplampDB

1. Create new users

/ / login MYSQL
@ > mysql -u root -p
@ > password
// create users
mysql > insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));
// refresh the system permissions table
mysql > flush privileges;
This creates a user named: phplamp with password: 1234.
Then log in 1.
mysql > exit;
@ > mysql -u phplamp -p
@ > Enter the password
mysql > Login successful

2. User authorization

If you want to allow user myuser to connect to mysql server from ip's 192.168.1.6 host and use mypassword as password

GRANTALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITHGRANT OPTION;

FLUSH PRIVILEGES;

3. Delete users

@ > 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 specified user password

@ > mysql -u root -p
@ > password
mysql > update mysql.user set password=password(' new password ') where User="phplamp" and Host="localhost";
mysql > flush privileges;