Give broad schema-level rights.
Section: grants and roles
Grant all privileges on a database
sql
sql
GRANT ALL PRIVILEGES ON app_db.* TO 'admin_user'@'%';Explanation
Convenient in development; more restrictive grants are safer in production.
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.