MySQL new user, giving permission

MySQL creates a user hail, password hail, specifies a database haildb to hailmysql-u root-ppassworduse mysql;insert into user (ho

MySQL creates a user hail, password hail, specifying a database haildb to hail

Mysql-u root-p

Password

Use MySQL;

Insert into User (Host,user,password) values (' localhost ', ' Hail ', password (' hail '));

Flush privileges;

Create Database haildb;

Grant all privileges the haildb.* to [e-mail protected] identified by ' hail ';

Flush privileges;

If you want to specify partial permissions to the user

Grant Select,update on haildb.* to [e-mail protected] identified by ' hail ';

Flush privileges;

Delete User

Delete from user where user= ' hail ' and host= ' localhost ';

Flush privileges;

Delete a user database

Drop database haildb;

Modify the specified user password

Update user set Password=password (' New_password ') where user= ' hail ' and host= ' localhost ';

Flush privileges;

MySQL new user, giving permission