mysqladmin
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
