Menu

MySQL Administration

Administer MySQL with practical guides for users and privileges, password changes, database backups, and server maintenance.

This chapter introduces the knowledge related to managing databases in MySQL, including user permissions, changing passwords, data backup, starting, stopping, and restarting databases.

  1. MySQL Start/Stop

    This tutorial walks you through how to start/stop/restart a MySQL server on Linux and Windows.

  2. MySQL Create User

    Create a MySQL account with an explicit host, secure credentials, and only the database privileges it needs.

  3. MySQL Drop User

    This article describes how to drop one or more user accounts from a MySQL server using the DROP USER statement.

  4. MySQL Rename User

    Rename MySQL accounts with RENAME USER, preserve their privileges, and update client configurations safely.

  5. MySQL Change Password

    Change your own or another MySQL account password with ALTER USER, and rotate application credentials safely.

  6. MySQL Show Users

    List MySQL accounts by user and host, distinguish login and privilege identities with USER() and CURRENT_USER(), and inspect active sessions.

  7. MySQL Lock Users

    Lock MySQL accounts with ALTER USER or CREATE USER, verify explicit lock status, and distinguish it from temporary failed-login blocks.

  8. MySQL Unlock Users

    Unlock MySQL accounts with ALTER USER ... ACCOUNT UNLOCK, verify their explicit lock state, and clear temporary failed-login blocks.

  9. MySQL GRANT

    Learn MySQL GRANT syntax and how to assign global, database, and table privileges; grant only what each account needs.

  10. MySQL Revoke Privileges

    This article will take you to learn how to use the REVOKE statement to revoke user permissions.

  11. MySQL Show Grants

    This article describes how to use the SHOW GRANTS statement to list the privileges granted to a user or role.

  12. MySQL Role

    Use MySQL roles to assign database privileges consistently, with explicit role hosts and separate application accounts.

  13. MySQL Show Databases

    List MySQL databases with SHOW DATABASES or from the command line. Learn why results vary by account privileges, filter names, and query schema metadata.

  14. MySQL Show Tables

    List MySQL tables and views with SHOW TABLES, run it from the command line, choose a database with FROM, filter names with LIKE, and troubleshoot Error 1046.

  15. MySQL Show Columns

    Use MySQL SHOW COLUMNS or DESCRIBE to inspect column names, types, nullability, keys, defaults, and FULL output, with database and pattern examples.

  16. MySQL DESC

    Use MySQL DESC or DESCRIBE to inspect a table’s columns, types, nullability, indexes, defaults, and extra attributes.

  17. MySQL Maintain Tables

    MySQL provides several statements for maintaining tables, ANALYZE TABLE, OPTIMIZE TABLE, CHECK TABLE and REPAIR TABLE.

  18. MySQL Backup

    The mysqldump is a tool for making backup of MySQL databases, it can export MySQL database as a sql file.

  19. MySQL Restore

    MySQL provides the SOURCE command to help you restore a database from a dump file.

  20. MySQL Show Processlist

    Use MySQL SHOW PROCESSLIST to inspect active sessions, understand PROCESS visibility and FULL output, and query process data with Performance Schema.