Create and delete MySQL users

The following articles mainly introduce the actual operation steps for MySQL users. We will first describe them from the creation of user havend, the following is a collective description of the specific operation steps of the article, hoping to bring a lot of help in future study or work.

Create a user, haven:

 
 

  
  
create user 'haven'@'localhost' identified by 'haven'; 
 
 

Allow local connection only

 
 

  
  
create user 'haven' identified by 'haven';  
 
 

Remote connection

Authorization:

 
 

  
  
grant all privileges on *.* to 'haven'@'localhost';  
 
 

Grant all permissions of all databases to the local haven

Delete a MySQL user:

 
 

  
  
delete from user where user='haven'; 
 
 

View user and host:

 
 

  
  
MySQL>use MySQL;  
  
  
mysq>select user,host from user;  
 
 

The above content is an introduction to the operations of MySQL users. I hope you will gain some benefits.

The above content describes the operations of MySQL users, hoping to help you in this regard.

Edit recommendations]