Linux : Essentials MySQL Admin CLI commands

By | March 7, 2015

Here is a quick list of useful commands for any MySQL database administrator.

Show the server full status :

You may also sort specific information with “grep” as followed :

Show the current running process and queries (remove “-i 1” to display once) :

Show version and server uptime :

Change the root password :

Show MySQL variables :

Create a new database :

Drop an existing database :

Flush priviledges :