MySQL 8.0.18 adds users to the database and grants permissions

1. It is preferred to use the root user to log in to the database

mysql -uroot -p

2. Using MySQL database

USE mysql;

3. Create a user for mysql: dev Password: dev12345

CREATE USER dev IDENTIFIED BY 'dev12345';

4. Check the permissions of user dev

SELECT * FROM user WHERE user='dev';
SHOW GRANTS FOR dev;

5. Assign EXECUTE (execute stored procedure), INSERT, SELECT, and UPDATE permissions to user dev on the database named dev_db. @'%' means that this database can be accessed from any IP address.

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

The above is what I introduced to you about adding users and granting permissions to the database in MySQL 8.0.18. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!