Skip to main content

Admin for MySQLs

MySQL administration covers managing accounts and privileges with CREATE USER and GRANT, taking logical backups with mysqldump, restoring them, and securing the server. This unit sits in the Operations stage and applies least privilege, so applications connect with only the access they need rather than as root.

Stage: Operations · Part of the MySQL roadmap · Last reviewed 19 November 2026

What to learn in Admin

Admin interview questions

How do you back up a MySQL database?

A common logical method is mysqldump, which writes SQL statements that recreate the schema and data, restored by feeding the file to mysql. For large databases, physical backups or snapshots are faster. Always test a restore, not just the backup.

What is the principle of least privilege in MySQL?

Each account gets only the permissions it needs, for example SELECT, INSERT and UPDATE on one schema, never ALL PRIVILEGES globally. This limits damage if credentials leak or the application has a SQL injection flaw.

Where Admin fits in the MySQL roadmap

Admin belongs to the Operations stage (intermediate level). Run MySQL.

Back to the full MySQL roadmap