4-1 mysqladmin
mysqladmin Ver 6.6 Distrib 3.21.24-gamma, for sun-solaris2.6 on sparc
TCX Datakonsult AB, by Monty
This software comes with NO WARRANTY: see the file PUBLIC for details.
Administer program for the mysqld demon
Usage: mysqladmin [OPTIONS] command command....
-#, --debug=... Output debug log. Often this is 'd:t:o,filename'
-f, --force Don't ask for confirmation on drop table. Continue
even if we get an error
-?, --help Display this help and exit
-h, --host=# Connect to host
-p, --password[=...] Password to use when connecting to server
If password is not given it's asked from the tty.
-P --port=... Port number to use for connection
-i, --sleep=sec Execute commands again and again with a sleep between
-S --socket=... Socket file to use for connection
-u, --user=# User for login if not current user
-V, --version Output version information and exit
Where command is a one or more of: (Commands may be shortened)
create databasename Create a new database
drop databasename Delete a database and all its tables
kill id,id,... Kill mysql threads
processlist Show list of active threads in server
reload Reload grant tables
refresh Flush all tables and close and open logfiles
shutdown Take server down
status Gives a short status message from the server
variables Prints variables available
version Get version info from server