MySQL new user, authorize, delete user, modify password

1. Create a new user.

Login to MySQL

@>mysql-u root-p

@> Password

Create a user

mysql> INSERT INTO Mysql.user (Host,user,password) VALUES ("localhost", "Phplamp", Password ("1234"));

Refresh System Permission Table

Mysql>flush privileges;

This creates a user named: phplamp Password: 1234.

Then log in.

mysql>exit;

@>mysql-u phplamp-p

@> Enter password

Mysql> Login Successful

2. Authorize the user.

Login to MySQL (with root privileges). I'm logged in as root.

@>mysql-u root-p

@> Password

First create a database for the user (phplampdb)

Mysql>create database phplampdb;

Authorize Phplamp users to have all the permissions of the Phplamp database.

>grant all privileges in phplampdb.* to phplamp@localhost identified by ' 1234 ';

Refresh System Permission Table

Mysql>flush privileges;

mysql> Other actions

/*

If you want to specify partial permissions to a user, you can write this:

Mysql>grant select,update on phplampdb.* to phplamp@localhost identified by ' 1234 ';

Refreshes the System permission table.

Mysql>flush privileges;

*/

3. Delete the 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 specified user password.

@>mysql-u root-p

@> Password

Mysql>update Mysql.user Set Password=password (' New password ') where user= "Phplamp" and host= "localhost";

Mysql>flush privileges;