Mysql database Add users and assign permissions to implement _mysql

Create users and assign permissions;

Copy Code code as follows:

Insert into Mysql.user (Host,user,password) VALUES ("localhost", "Phplamp", Password ("1234"))//create User
Grant all privileges in dbname.* to ' username ' @ '% ' identified by ' password ';//create user and assign all permissions
Grant Select,update on phplampdb.* to phplamp@localhost identified by ' 1234 ';///create user and assign permissions
Update Mysql.user set Password=password (' New password ') where user= "Phplamp" and host= "localhost";//Modify User Password
--delete user specified permissions
Revoke insert,update,delete,select on *.* from ' xbb ' @ ' localhost ' identified by ' 123 ';