sqlANYcreate-userauth
sql
CREATE USER 'app_user'@'%' IDENTIFIED BY 'replace-with-strong-password';Host matching matters in MySQL accounts; `%` allows connections from any host.
MySQL Users, Grants, and Privileges Cheatsheet
create users, alter passwords, grant privileges, show grants, revoke access, and manage MySQL accounts safely.
Export
Copy the compact sheet, download it, or print it.
Download
`D` dense toggle · `C` copy all
user management
Create and modify accounts for applications, admins, and services.
sqlANYalter-userpassword
sql
ALTER USER 'app_user'@'%' IDENTIFIED BY 'new-strong-password';Password rotation is a standard operational task for service accounts.
sqlANYdrop-userauth
sql
DROP USER IF EXISTS 'old_user'@'%';Use with care because dropping a user removes its login access immediately.
sqlANYusercurrent_usersession
sql
SELECT USER(), CURRENT_USER();These can differ because of authentication and account resolution behavior.
sqlANYmysql.useraccounts
sql
SELECT user, host FROM mysql.user ORDER BY user, host;Requires appropriate privileges to inspect system tables.
grants and roles
Grant and inspect privileges for application and admin workflows.
sqlANYgrantdatabaseprivileges
sql
GRANT SELECT, INSERT, UPDATE, DELETE ON app_db.* TO 'app_user'@'%';This is a common least-privilege grant for application accounts.
sqlANYgrantall-privileges
sql
GRANT ALL PRIVILEGES ON app_db.* TO 'admin_user'@'%';Convenient in development; more restrictive grants are safer in production.
sqlANYshow-grantsprivileges
sql
SHOW GRANTS FOR 'app_user'@'%';Always verify grants after provisioning service accounts.
sqlANYrevokeprivileges
sql
REVOKE DELETE ON app_db.* FROM 'app_user'@'%';Use revoke to tighten access when an account should no longer perform certain operations.
sqlANYflush-privilegesgrants
sql
FLUSH PRIVILEGES;Usually unnecessary when using `CREATE USER`, `GRANT`, or `REVOKE`, but sometimes seen in legacy workflows.
More in MySQL
MySQL Procedures, Triggers, and Events Cheatsheet
stored procedures, stored functions, delimiters, call, triggers, and scheduled events in MySQL.
MySQL Functions, JSON, and Date Cheatsheet
now, date_add, date_sub, date_format, timestampdiff, json_extract, json_set, json_object, concat, coalesce, and case in MySQL.
MySQL Backup, Restore, Import, and Export Cheatsheet
mysqldump, mysql restore, load data infile, select into outfile, mysqlimport, and MySQL Shell dump/load workflows.
MySQL Transactions and Locking Cheatsheet
start transaction, commit, rollback, savepoints, select for update, isolation levels, and InnoDB lock troubleshooting.
MySQL Indexes, EXPLAIN, and Performance Cheatsheet
index design, show index, explain, explain analyze, analyze table, and practical performance tuning workflows in MySQL.
MySQL Aggregation and Window Functions Cheatsheet
group by, having, count, sum, avg, row_number, lag, running totals, and analytical query patterns in MySQL.