1. Create a user.
// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User, Password, ssl_cipher, x509_issuer, x509_sub
Ject) values ("localhost", "pppadmin", password ("passwd "),'','','');
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;
5. list all databases
Mysql> show database;
6. Switch the 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 name;
Mysql> drop table data table name;