MySQL 8.0. 18 Adding users and empowering questions to the database
- 2021-12-21 05:26:06
- OfStack
1. The root user login database is preferred
mysql -uroot -p
2. Using the mysql database
USE mysql;
3. Create user for mysql: dev password: dev12345
CREATE USER dev IDENTIFIED BY 'dev12345';
4. View the permissions of the user dev
SELECT * FROM user WHERE user='dev' ;
SHOW GRANTS FOR dev;
5. Assign EXECUTE (Execute Stored Procedure), INSERT, SELECT, UPDATE permissions to the user dev on the database name dev_db, @ '%' means that the database can be accessed from any ip
GRANT EXECUTE,INSERT,SELECT,UPDATE ON dev_db.* TO 'dev'@'%';
FLUSH PRIVILEGES;
6. Query the permissions again
SELECT * FROM USER WHERE USER='dev_dv' ;
SHOW GRANTS FOR dev;
Summarize