mysqladmin

Purpose :

mysqladmin is a client for performing administrative operations. You can use it to check the server's configuration and current status, to create and drop databases, and more..

shell> mysqladmin [options] command [command-arg] 
       [command [command-arg]]

mysqladmin supports the following commands. Some of the commands take an argument following the command name.

`Command`	Meaning
`create db_name`	Create a new database named `db_name`.
`debug`	Tell the server to write debug information to the error log.
`drop db_name`	Delete the database named `db_name` and all its tables.
`extended-status`	Display the server status variables and their values.
`flush-hosts`	Flush all information in the host cache.
`flush-logs`	Flush all logs.
`flush-privileges`	Reload the grant tables
`flush-status`	Clear status variables.
`flush-tables`	Flush all tables.
`flush-threads`	Flush the thread cache.
`kill id,id,...`	Kill server threads. If multiple thread ID values are given, there must be no spaces in the list.
`old-password new-password`	This is like the `password` command but stores the password using the old password-hashing format.
`password new-password`	Set a new password. This changes the password to `new-password` for the account that you use with mysqladmin for connecting to the server.
`Ping`	Check whether the server is available.
`Processlist`	Show a list of active server threads.
`Reload`	Reload the grant tables.
`Refresh`	Flush all tables and close and open log files.
`Shutdown`	Stop the server.
`start-slave`	Start replication on a slave server.
`Status`	Display a short server status message.
`stop-slave`	Stop replication on a slave server.
`Variables`	Display the server system variables and their values.
`Version`	Display version information from the server.