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


Related articles: