mysqladmin

The mysqladmin client communicates with the MySQL server to perform a variety of administrative operations. You can use mysqladmin to obtain information from or control the operation of the server, set passwords, and create or drop databases.

Usage

mysqladmin [options] command ...

Standard Options Supported by mysqladmin

--character-sets-dir      --password                --silent
--compress                --pipe                    --socket
--debug                   --port                    --user
--default-character-set   --protocol                --verbose
--help                    --set-variable            --version
--host                    --shared-memory-base-name

--silent causes mysqladmin to exit silently if it cannot connect to the server. The --verbose option causes mysqladmin to print more information for a few commands. mysqladmin also supports the standard SSL options.

--default-character-set is supported as of MySQL 4.1.9.

Options Specific to mysqladmin

• --count=n, -c n

  The number of iterations to make when --sleep is given.

• --force, -f (boolean)

  This option has two effects. First, it causes mysqladmin not to ask for confirmation of the drop db_name command. Second, when multiple commands are specified on the command line, mysqladmin attempts to execute each command even if errors occur. Normally, mysqladmin exits after the first error.

• --relative, -r (boolean)

  Show the difference between the current and previous values when used with --sleep. Currently, this option works only with the extended-status command.

• --sleep=n, -i n

  Execute the commands named on the command line repeatedly with a delay of n seconds between each repetition.

• --vertical, -E (boolean)

  This option is like --relative, but displays output vertically.

• --wait[=n], -w[n]

  The number of times to wait and retry if a connection to the server cannot be established. The default value of n is 1 if no value is given. If n is specified after -w, there must be no intervening space or the value will not be interpreted correctly.

Variables for mysqladmin

The following mysqladmin variables can be set using the instructions given in "Setting Program Variables" earlier in this appendix.

• connect_timeout

  The number of seconds to wait before timing out when attempting to connect to the server. The default value is 43,200.

• shutdown_timeout

  For shutdown commands, the number of seconds to wait for a successful shutdown. The default value is 3,600.

mysqladmin Commands

Following any options on the command line, you can specify one or more of the following commands. Each command name can be shortened to a prefix, as long as the prefix is unambiguous. For example, processlist can be shortened to process or proc, but not to p.

Several of these commands have an equivalent SQL statement, as noted in the descriptions. For more information about the meaning of the SQL statements, see Appendix E, "SQL Syntax Reference."

• create db_name

  Create a new database with the given name. This command is like the CREATE DATABASE db_name statement.

• debug

  Instruct the server to dump debugging information.

• drop db_name

  Delete the database with the given name, and any tables that may be in the database. Be careful with this command; you can't get the database back. mysqladmin asks for confirmation of this command unless the --force option was given. This command is like the DROP DATABASE db_name statement.

• extended-status

  Display the names and values of the server's status variables. This command is like the SHOW STATUS statement.

• flush-hosts

  Flush the host cache. This command is like the FLUSH HOSTS statement.

• flush-logs

  Flush (close and reopen) the log files. This command is like the FLUSH LOGS statement.

• flush-privileges

  Reload the grant tables. This command is like the FLUSH PRIVILEGES statement.

• flush-status

  Clear the status variables. (This resets several counters to zero.) This command is like the FLUSH STATUS statement.

• flush-tables

  Flush the table cache. This command is like the FLUSH TABLES statement.

• flush-threads

  Flush the thread cache.

• kill id,id,...

  Kill the server threads specified by the given identifier numbers. If you specify multiple numbers, the ID list should contain no spaces so that it will not be confused with another command following the kill command. To find out what threads are currently running, use mysqladmin processlist. This command is like issuing a KILL statement for each thread ID.

• old-password new_password

  This command is like the password command except that it causes the password to be stored in the older (pre-MySQL 4.1) password-hashing format.

• password new_password

  Change the password for the account that you use when invoking mysqladmin. (Being able to connect to the server using this account serves as verification that you know the current password.) The password will be set to new_password. This command is like the SET PASSWORD statement.

• ping

  Check whether the MySQL server is running.

• processlist

  Display a list of the currently executing server threads. This command is like the SHOW PROCESSLIST statement. With the --verbose option, this command is like SHOW FULL PROCESSLIST.

• refresh

  This command flushes the table cache and the grant tables, and closes and reopens the log files. If the server is a replication master server, the command tells it to delete the binary logs listed in the binary log index file and to truncate the index. If the server is a slave server, the command tells it to forget its position in the master logs.

• reload

  Reload the grant tables. This command is like the FLUSH PRIVILEGES statement.

• shutdown

  Shut down the server.

• start-slave

  Start a replication slave server. This command is like the START SLAVE statement.

• status

  Display a short status message from the server.

• stop-slave

  Stop a replication slave server. This command is like the STOP SLAVE statement.

• variables

  Display the names and values of the server's variables. This command is like the SHOW GLOBAL VARIABLES. (There is no support for SHOW SESSION VARIABLES because that wouldn't make any sense.)

• version

  Retrieve and display the server version information string. This is the same information that is returned by the VERSION() SQL function. (See Appendix C, "Operator and Function Reference.")