content_image/749253.jpg content_image/749254.jpg
• kill id , id ,... 

Kill server threads. If multiple thread ID values are given, there must be no spaces in the list. 

To kill threads belonging to other users, the connected user must have the CONNECTION_ADMIN privilege (or the deprecated SUPER  privilege). 

• 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. Thus, the next time you invoke mysqladmin  (or any other client program) using the same account, you must specify the new password. 

<img src='content_image/749253.jpg'>

## Warning 

Setting a password using mysqladmin  should be considered insecure . On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps . (SystemV Unix systems and perhaps others are subject to this problem.) 

If the new_password  value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotation marks. On Windows, be sure to use double quotation marks rather than single quotation marks; single quotation marks are not stripped from the password, but rather are interpreted as part of the password. For example: 

mysqladmin password "my new password" 

The new password can be omitted following the password  command. In this case, mysqladmin prompts for the password value, which enables you to avoid specifying the password on the command line. Omitting the password value should be done only if password  is the final command on the mysqladmin  command line. Otherwise, the next argument is taken as the password. 

<img src='content_image/749254.jpg'>

• ping 

## Caution 

Do not use this command used if the server was started with the --skip- grant-tables  option. No password change is applied. This is true even if you precede the password  command with flush-privileges  on the same command line to re-enable the grant tables because the flush operation occurs after you connect. However, you can use mysqladmin flush-privileges to re-enable the grant table and then use a separate mysqladmin password command to change the password. 

Check whether the server is available. The return status from mysqladmin  is 0 if the server is running, 1 if it is not. This is 0 even in case of an error such as Access denied , because this means that the server is running but refused the connection, which is different from the server not running. 

• processlist 

Show a list of active server threads. This is like the output of the SHOW PROCESSLIST  statement. If the --verbose  option is given, the output is like that of SHOW FULL PROCESSLIST . (See Section 13.7.7.29, “SHOW PROCESSLIST Statement” .) 

