MYSQL入门学习之十八：MYSQLADMIN命令参数详解(四)
abasename Create a new database
debug Instruct server to write debug information to log
drop databasename Delete a database and all its tables
extended-status Gives an extended status message from the server
flush-hosts Flush all cached hosts
flush-logs Flush all logs
flush-status Clear status variables
flush-tables Flush all tables
flush-threads Flush the thread cache
flush-privileges Reload grant tables (same as reload)
kill id,id,... Kill mysql threads
password new-password Change old password to new-password, MySQL 4.1 hashing.
old-password new-password Change old password to new-password in old format.
ping Check if mysqld is alive
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
start-slave Start slave
stop-slave Stop slave
variables Prints variables available
version Get version info from server
帮助信息主要包括三部分：
第一部分为mysqladmin命令的相关选项，详细说明如下：
-c, --count=#
Number of iterations to make. This works with -i (--sleep) only.
自动运行次数，必须和 -i 一起使用
--debug-check
Check memory and open file usage at exit .
--debug-info
Print some debug info at exit.
-f, --force
Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs.
禁用错误，drop 数据库时不提示，执行多条命令时出错继续执行
-C, --compress
Use compression in server/client protocol.
在服务器和客户端之间使用压缩
--character-sets-dir=name
Directory where character sets are.
设置字符集目录
--default-character-set=name
Set the default character set.
设置字符集默认目录
- , --help
Display this help and exit.
显示帮助信息
-h, --host=name
Connect to host.
主机名
-b, --no-beep
Turn off beep on error.
报错时，不响铃（嘟的一声）
-p, --password[=name]
Password to use when connecting to server. If password is not given it's asked from the tty.
服务器连接密码
-W, --pipe
Use named pipes to connect to server.
使用命名管道连接服务器
-P, --port=#
Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306).
端口号
--protocol=name
The protocol of connection (tcp,socket,pipe,memory).
设置连接使用的协议
-r, --relative
Show difference between current and previous values when used with -i. Currently works only with extended-status.
显示前后变化的值，必须结合- i
-O, --set-variable=name
Change the value of a variable. Please note that this option is deprecated; you can set variables directly with --variable-name=value.
修改变量的值，使用--variable-name=value 的方式修改变量值
--shared-memory-base-name=name
Base name of shared memory.
-s, --silent
Silently exit if one can't connect to server.
如果连接服务器失败则退出
-S, --socket=name
Socket file to use for connection.
指定socket file
-i, --sleep=#
Execute commands again and again with a sleep between.
间隔一段时间执行一次
--ssl
Enable SSL for connection (automatically enabled with other flags). Disable with --skip-ssl.
--ssl-ca=name
CA file in PEM format (check OpenSSL docs, implies --ssl).
--ssl-capath=name
CA directory (check OpenSSL docs, implies --ssl).
--ssl-cert=name
X509