MySQL 8.4 · Databases and users

Grant privileges on a database

Let a user read and write the tables in one database.

GRANT SELECT, INSERT, UPDATE, DELETE ON mydb.* TO 'app'@'localhost';

Official MySQL 8.4 documentation

More databases and users commands

All databases and users commands · MySQL 8.4 cheatsheet

Was this page helpful?