How to use DCL to manage users and control permissions in MySQL

-- Create a user CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';

CREATE USER 'Summerday'@'localhost' IDENTIFIED BY '123456';

-- Change password SET PASSWORD FOR 'user name'@'host name' = PASSWORD('new password');

SET PASSWORD FOR 'Summerday'@'localhost' = PASSWORD('hyh123');

-- 1. Switch to mysql database USE mysql;
-- 2. Query the user table SELECT * FROM USER;

-- Delete user DROP USER 'username'@'hostname';

DROP USER 'Summerday'@'localhost';

-- Query permissions SHOW GRANTS FOR 'user name'@'host name';

SHOW GRANTS FOR 'Summerday'@'localhost';

-- Grant permissions GRANT permission list ON database name. table name TO 'user name'@'host name';

GRANT SELECT ON mydb2.account TO 'Summerday'@'localhost';

-- Grant all permissions GRANT ALL ON *.* TO 'Summerday'@'localhost';

-- Revoke permissions REVOKE permission list ON database name. table name FROM 'user name'@'host name';

REVOKE SELECT ON mydb2.account TO 'Summerday'@'localhost';

-- Revoke all permissions REVOKE ALL ON *.* FROM 'Summerday'@'localhost';