MySql adds user authorization password change and so on

1. New user.
/ / login MYSQL
@ > mysql -u root -p
@ > password
// create users
mysql > mysql > insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_sub
ject) values("localhost","pppadmin",password("passwd"),'','','');
This creates a user named: phplamp with password: 1234.
And then log in 1.
mysql > exit;
@ > mysql -u phplamp -p
@ > Enter the password
mysql > Login successful
2. Authorizing users.
// login to MYSQL (with ROOT permissions). I'm logged in as ROOT.
@ > mysql -u root -p
@ > password
// first create a database for the user (phplampDB)
mysql > create database phplampDB;
// authorized phplamp users have all permissions for the phplamp database.
> grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
// refresh the system permission table
mysql > flush privileges;
mysql > Other operating
/*
If you want to specify partial permission to 1 user, you can write:
mysql > grant select,update on phplampDB.* to phplamp@localhost identified by '1234';
// refresh the system permission table.
mysql > 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. Change the specified user's password.
@ > mysql -u root -p
@ > password
mysql > update mysql.user set password=password(' new password ') where User="phplamp" and Host="localhost";
mysql > flush privileges;
5. Lists all databases
mysql > show database;
6. Switch database
mysql > use 'database name ';
7. List all tables
mysql > show tables;
8. Display the data table structure
mysql > describe table name;
9. Delete databases and data tables
mysql > drop database database name;
mysql > drop table data table name;