mysqladmin

MySQL
MySQL Privileges
mysqldump
mysqlimport

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