11. Create and authorize mysql users. 11. mysql
1. Create a user.
// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User, Password) values ("localhost", "abc", password ("1234 "));
// Refresh the system permission list
Mysql> flush privileges;
In this way, a user named "abc password: 1234" is created.
Then log on.
Mysql> exit;
@> Mysql-u abc-p
@> Enter the password
Mysql> logon successful
2. Authorize the user.
// Log on to MYSQL (with ROOT permission ). I log on as ROOT.
@> Mysql-u root-p
@> Password
// Create a database for the user (test2)
Mysql> create database test2;
// Authorize the abc user to have all permissions for the test2 database. (And all ip addresses can be logged on. Note: bindress = 127.0.0.1 must be noted in my. cnf)
> Grant all privileges on test2. * to 'abc' @ '% 'identified by '123 ';
// Refresh the 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 test2. * to 'abc' @ '% 'identified by '123 ';
// Refresh the system permission table.
Mysql> flush privileges;
*/
3. delete a user.
@> Mysql-u root-p
@> Password
Mysql> delete from user WHERE User = "abc" and Host = "localhost ";
Mysql> flush privileges;
// Delete the user's database
Mysql> drop database test2;
4. Modify the password of the specified user.
@> Mysql-u root-p
@> Password
Mysql> update mysql. user set password = password ('new password') where User = "abc" and Host = "localhost ";
Mysql> flush privileges;
Recommendation: Welcome to the discussion and provide some guidance and suggestions.