mysqladmin

Syntax

mysqladmin [options] <command> <command args>
Create Database
mysqladmin create <database>
Drop Database
mysqladmin drop <database>
Flush logs

Gotcha: mysqladmin flush will not display any errors to stdout. Instead, any problems are logged to mysqld error log. This means that if it keeps running, it could be stuck on a problem, and not tell you.

mysqladmin flush
Privileges

Reload the grant tables.

mysqladmin flush-privileges

Or:

mysqladmin reload
Change Password

Mine:

mysqladmin password <password>

Another user's:

mysqladmin -u <username> -p password <password>
Show Processes
mysqladmin proc
Kill Process
mysqladmin kill <id>
mysqladmin kill <id>,<id>
Server status
mysqladmin status
Uptime: 59507  Threads: 1  Questions: 1423  Slow queries: 1  Opens: 2784  Flush tables: 1  Open tables: 64  Queries per second avg: 0.23
Show system variables
mysqladmin variables