How to create a user and a database in MySql

The following articles mainly describe how to create a user in MySql, how to create a database, how to authorize and delete a user, and how to change the password, the following describes how to create the main content of the body.

1. Create a user in MySql.

Log on to MYSQL

@> Mysql-u root-p

@> Password

Create user

 
 

  
  
mysql> 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.

You have the ROOT permission to log on to MYSQL ). I log on as ROOT.

@> Mysql-u root-p

@> Password

Create a database (phplampDB) for a new MySql user)

 
 

  
  
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 '1234'; 
 
 

Refresh 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 '1234'; 
 
 

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 a 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 passwordpassword = 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;

The above content introduces how to create a user, create a database, authorize a user, delete a user, and change a password in MySql. I hope you will get some benefits.