Add a user to MySql, create a database, authorize the user, delete the user, and change the password _ MySQL

Add a user to MySql, create a database, authorize the user, delete the user, and change the password bitsCN.com

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;

Author gzh0222

BitsCN.com