Allow an app account to use one schema.
Section: grants and roles
Grant privileges on one database
sql
sql
GRANT SELECT, INSERT, UPDATE, DELETE ON app_db.* TO 'app_user'@'%';Explanation
This is a common least-privilege grant for application accounts.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing grants and roles
Show grants for a user
Inspect the effective privileges granted to an account.
Reload grant tables
Refresh privilege data after direct system-table changes.