TABLE OF CONTENTS (HIDE)

MySQL Utilities

MySQL-Bundled Command-line Utilities

mysqladmin

"mysqladmin" is a command-line utility bundled with MySQL package (under the "bin" sub-directory) for the database administrators to perform some basic administrative tasks such as shutting-down the server, setting root password, changing root password, monitoring mysql processes, reloading privileges, checking server status etc.

Shutting-down Server Safely
$ mysqladmin -u root -p shutdown
Setting root's Password
$ mysqladmin -u root password YOUR_PASSWORD
Changing root's Password
$ mysqladmin -u root -pOLDPASSWORD password NEWPASSWORD

[TODO] more

mysqldump

See section "Backup and Restore Databases" in "How to Install MySQL".

[TODO] more.

PhpMyAdmin

PhpMyAdmin is a PHP webapp for administrating and manipulating MySQL/MariaDB. PhpMyAdmin is usually bundled with an AMP (Apache-MySQL-PHP) distribution, such as XAMPP.

See "PhpMyAdmin" section under "Setting Up Apache-MySQL/MariaDB-PHP (AMP)".

[TODO]