man pages section 1: User Commands

Exit Print View

Updated: July 2014

mysqladmin (1)


mysqladmin - client for administering a MySQL server


mysqladmin [options] command [command-options] [command


MySQL Database System                               MYSQLADMIN(1)

     mysqladmin - client for administering a MySQL server

     mysqladmin [options] command [command-options] [command

     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.

     Invoke mysqladmin like this:

         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.

     o   create db_name

         Create a new database named db_name.

     o   debug

         Tell the server to write debug information to the error

         This includes information about the Event Scheduler. See
         Section 19.4.5, "Event Scheduler Status".

     o   drop db_name

         Delete the database named db_name and all its tables.

     o   extended-status

         Display the server status variables and their values.

     o   flush-hosts

         Flush all information in the host cache.

     o   flush-logs

         Flush all logs.

     o   flush-privileges

         Reload the grant tables (same as reload).

MySQL 5.5            Last change: 03/22/2013                    1

MySQL Database System                               MYSQLADMIN(1)

     o   flush-status

         Clear status variables.

     o   flush-tables

         Flush all tables.

     o   flush-threads

         Flush the thread cache.

     o   kill id,id,...

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

     o   old-password new-password

         This is like the password command but stores the
         password using the old (pre-4.1) password-hashing
         format. (See Section, "Password Hashing in

     o   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 will need to specify the new

         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:

             shell> mysqladmin password "my new password"

         As of MySQL 5.5.3, 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

MySQL 5.5            Last change: 03/22/2013                    2

MySQL Database System                               MYSQLADMIN(1)

             Do not use this command used if the server was
             started with the --skip-grant-tables option. No
             password change will be 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.

     o   ping

         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.

     o   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, "SHOW
         PROCESSLIST Syntax".)

     o   reload

         Reload the grant tables.

     o   refresh

         Flush all tables and close and open log files.

     o   shutdown

         Stop the server.

     o   start-slave

         Start replication on a slave server.

     o   status

         Display a short server status message.

     o   stop-slave

         Stop replication on a slave server.

MySQL 5.5            Last change: 03/22/2013                    3

MySQL Database System                               MYSQLADMIN(1)

     o   variables

         Display the server system variables and their values.

     o   version

         Display version information from the server.

     All commands can be shortened to any unique prefix. For

         shell> mysqladmin proc stat
         | Id | User  | Host      | db | Command | Time | State | Info             |
         | 51 | monty | localhost |    | Query   | 0    |       | show processlist |
         Uptime: 1473624  Threads: 1  Questions: 39487
         Slow queries: 0  Opens: 541  Flush tables: 1
         Open tables: 19  Queries per second avg: 0.0268

     The mysqladmin status command result displays the following

     o   Uptime

         The number of seconds the MySQL server has been running.

     o   Threads

         The number of active threads (clients).

     o   Questions

         The number of questions (queries) from clients since the
         server was started.

     o   Slow queries

         The number of queries that have taken more than
         long_query_time seconds. See Section 5.2.5, "The Slow
         Query Log".

     o   Opens

         The number of tables the server has opened.

     o   Flush tables

         The number of flush-*, refresh, and reload commands the
         server has executed.

MySQL 5.5            Last change: 03/22/2013                    4

MySQL Database System                               MYSQLADMIN(1)

     o   Open tables

         The number of tables that currently are open.

     o   Memory in use

         The amount of memory allocated directly by mysqld. This
         value is displayed only when MySQL has been compiled
         with safemalloc, which is available only before MySQL

     o   Maximum memory used

         The maximum amount of memory allocated directly by
         mysqld. This value is displayed only when MySQL has been
         compiled with safemalloc, which is available only before
         MySQL 5.5.6.

     If you execute mysqladmin shutdown when connecting to a
     local server using a Unix socket file, mysqladmin waits
     until the server's process ID file has been removed, to
     ensure that the server has stopped properly.

     mysqladmin supports the following options, which can be
     specified on the command line or in the [mysqladmin] and
     [client] groups of an option file.  mysqladmin also supports
     the options for processing option files described at
     Section, "Command-Line Options that Affect Option-
     File Handling".

     o   --help, -?

         Display a help message and exit.

     o   --bind-address=ip_address

         On a computer having multiple network interfaces, this
         option can be used to select which interface is employed
         when connecting to the MySQL server.

         This option is supported only in the version of
         mysqladmin that is supplied with MySQL Cluster. It is
         not available in standard MySQL Server 5.5 releases.

     o   --character-sets-dir=path

         The directory where character sets are installed. See
         Section 10.5, "Character Set Configuration".

     o   --compress, -C

         Compress all information sent between the client and the

MySQL 5.5            Last change: 03/22/2013                    5

MySQL Database System                               MYSQLADMIN(1)

         server if both support compression.

     o   --count=N, -c N

         The number of iterations to make for repeated command
         execution if the --sleep option is given.

     o   --debug[=debug_options], -# [debug_options]

         Write a debugging log. A typical debug_options string is
         'd:t:o,file_name'. The default is

     o   --debug-check

         Print some debugging information when the program exits.

     o   --debug-info

         Print debugging information and memory and CPU usage
         statistics when the program exits.

     o   --default-auth=plugin

         The client-side authentication plugin to use. See
         Section 6.3.6, "Pluggable Authentication".

         This option was added in MySQL 5.5.9.

     o   --default-character-set=charset_name

         Use charset_name as the default character set. See
         Section 10.5, "Character Set Configuration".

     o   --enable-cleartext-plugin

         Enable the mysql_clear_password cleartext authentication
         plugin. (See Section, "The Cleartext Client-Side
         Authentication Plugin".) This option was added in MySQL

     o   --force, -f

         Do not ask for confirmation for the drop db_name
         command. With multiple commands, continue even if an
         error occurs.

     o   --host=host_name, -h host_name

         Connect to the MySQL server on the given host.

     o   --no-beep, -b

MySQL 5.5            Last change: 03/22/2013                    6

MySQL Database System                               MYSQLADMIN(1)

         Suppress the warning beep that is emitted by default for
         errors such as a failure to connect to the server.

     o   --password[=password], -p[password]

         The password to use when connecting to the server. If
         you use the short option form (-p), you cannot have a
         space between the option and the password. If you omit
         the password value following the --password or -p option
         on the command line, mysqladmin prompts for one.

         Specifying a password on the command line should be
         considered insecure. See Section, "End-User
         Guidelines for Password Security". You can use an option
         file to avoid giving the password on the command line.

     o   --pipe, -W

         On Windows, connect to the server using a named pipe.
         This option applies only if the server supports
         named-pipe connections.

     o   --plugin-dir=path

         The directory in which to look for plugins. It may be
         necessary to specify this option if the --default-auth
         option is used to specify an authentication plugin but
         mysqladmin does not find it. See Section 6.3.6,
         "Pluggable Authentication".

         This option was added in MySQL 5.5.9.

     o   --port=port_num, -P port_num

         The TCP/IP port number to use for the connection.

     o   --protocol={TCP|SOCKET|PIPE|MEMORY}

         The connection protocol to use for connecting to the
         server. It is useful when the other connection
         parameters normally would cause a protocol to be used
         other than the one you want. For details on the
         permissible values, see Section 4.2.2, "Connecting to
         the MySQL Server".

     o   --relative, -r

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

     o   --silent, -s

MySQL 5.5            Last change: 03/22/2013                    7

MySQL Database System                               MYSQLADMIN(1)

         Exit silently if a connection to the server cannot be

     o   --sleep=delay, -i delay

         Execute commands repeatedly, sleeping for delay seconds
         in between. The --count option determines the number of
         iterations. If --count is not given, mysqladmin executes
         commands indefinitely until interrupted.

     o   --socket=path, -S path

         For connections to localhost, the Unix socket file to
         use, or, on Windows, the name of the named pipe to use.

     o   --ssl*

         Options that begin with --ssl specify whether to connect
         to the server using SSL and indicate where to find SSL
         keys and certificates. See Section, "SSL Command

     o   --user=user_name, -u user_name

         The MySQL user name to use when connecting to the

     o   --verbose, -v

         Verbose mode. Print more information about what the
         program does.

     o   --version, -V

         Display version information and exit.

     o   --vertical, -E

         Print output vertically. This is similar to --relative,
         but prints output vertically.

     o   --wait[=count], -w[count]

         If the connection cannot be established, wait and retry
         instead of aborting. If a count value is given, it
         indicates the number of times to retry. The default is
         one time.

     You can also set the following variables by using
     --var_name=value The --set-variable format is deprecated and
     was removed in MySQL 5.5.3. syntax:

MySQL 5.5            Last change: 03/22/2013                    8

MySQL Database System                               MYSQLADMIN(1)

     o   connect_timeout

         The maximum number of seconds before connection timeout.
         The default value is 43200 (12 hours).

     o   shutdown_timeout

         The maximum number of seconds to wait for server
         shutdown. The default value is 3600 (1 hour).

     Copyright (C) 1997, 2013, Oracle and/or its affiliates. All
     rights reserved.

     This software and related documentation are provided under a
     license agreement containing restrictions on use and
     disclosure and are protected by intellectual property laws.
     Except as expressly permitted in your license agreement or
     allowed by law, you may not use, copy, reproduce, translate,
     broadcast, modify, license, transmit, distribute, exhibit,
     perform, publish, or display any part, in any form, or by
     any means. Reverse engineering, disassembly, or
     decompilation of this software, unless required by law for
     interoperability, is prohibited.

     The information contained herein is subject to change
     without notice and is not warranted to be error-free. If you
     find any errors, please report them to us in writing.

     If this software or related documentation is delivered to
     the U.S. Government or anyone licensing it on behalf of the
     U.S. Government, the following notice is applicable:

     U.S. GOVERNMENT RIGHTS Programs, software, databases, and
     related documentation and technical data delivered to U.S.
     Government customers are "commercial computer software" or
     "commercial technical data" pursuant to the applicable
     Federal Acquisition Regulation and agency-specific
     supplemental regulations. As such, the use, duplication,
     disclosure, modification, and adaptation shall be subject to
     the restrictions and license terms set forth in the
     applicable Government contract, and, to the extent
     applicable by the terms of the Government contract, the
     additional rights set forth in FAR 52.227-19, Commercial
     Computer Software License (December 2007). Oracle USA, Inc.,
     500 Oracle Parkway, Redwood City, CA 94065.

     This software is developed for general use in a variety of
     information management applications. It is not developed or
     intended for use in any inherently dangerous applications,
     including applications which may create a risk of personal
     injury. If you use this software in dangerous applications,

MySQL 5.5            Last change: 03/22/2013                    9

MySQL Database System                               MYSQLADMIN(1)

     then you shall be responsible to take all appropriate fail-
     safe, backup, redundancy, and other measures to ensure the
     safe use of this software. Oracle Corporation and its
     affiliates disclaim any liability for any damages caused by
     use of this software in dangerous applications.

     Oracle is a registered trademark of Oracle Corporation
     and/or its affiliates. MySQL is a trademark of Oracle
     Corporation and/or its affiliates, and shall not be used
     without Oracle's express written authorization. Other names
     may be trademarks of their respective owners.

     This software and documentation may provide access to or
     information on content, products, and services from third
     parties. Oracle Corporation and its affiliates are not
     responsible for and expressly disclaim all warranties of any
     kind with respect to third-party content, products, and
     services. Oracle Corporation and its affiliates will not be
     responsible for any loss, costs, or damages incurred due to
     your access to or use of third-party content, products, or

     This document in any form, software or printed matter,
     contains proprietary information that is the exclusive
     property of Oracle. Your access to and use of this material
     is subject to the terms and conditions of your Oracle
     Software License and Service Agreement, which has been
     executed and with which you agree to comply. This document
     and information contained herein may not be disclosed,
     copied, reproduced, or distributed to anyone outside Oracle
     without prior written consent of Oracle or as specifically
     provided below. This document is not part of your license
     agreement nor can it be incorporated into any contractual
     agreement with Oracle or its subsidiaries or affiliates.

     This documentation is NOT distributed under a GPL license.
     Use of this documentation is subject to the following terms:

     You may create a printed copy of this documentation solely
     for your own personal use. Conversion to other formats is
     allowed as long as the actual content is not altered or
     edited in any way. You shall not publish or distribute this
     documentation in any form or on any media, except if you
     distribute the documentation in a manner similar to how
     Oracle disseminates it (that is, electronically for download
     on a Web site with the software) or on a CD-ROM or similar
     medium, provided however that the documentation is
     disseminated together with the software on the same medium.
     Any other use, such as any dissemination of printed copies
     or use of this documentation, in whole or in part, in
     another publication, requires the prior written consent from
     an authorized representative of Oracle. Oracle and/or its

MySQL 5.5            Last change: 03/22/2013                   10

MySQL Database System                               MYSQLADMIN(1)

     affiliates reserve any and all rights to this documentation
     not expressly granted above.

     For more information on the terms of this license, or for
     details on how the MySQL documentation is built and
     produced, please visit blue]MySQL Contact & Questions].

     For additional licensing information, including licenses for
     third-party libraries used by MySQL products, see Preface
     and Legal Notices.

     For help with using MySQL, please visit either the
     blue]MySQL Forums] or blue]MySQL Mailing Lists] where you
     can discuss your issues with other MySQL users.

     For additional documentation on MySQL products, including
     translations of the documentation into other languages, and
     downloadable versions in variety of formats, including HTML
     and PDF formats, see the blue]MySQL Documentation Library].

     See attributes(5) for descriptions of the following

     |Availability   | database/mysql-55/client |
     |Stability      | Uncommitted              |
     For more information, please refer to the MySQL Reference
     Manual, which may already be installed locally and which is
     also available online at

     Oracle Corporation (

     This software was built from source available at  The original
     community source was downloaded from

     Further information about this software can be found on the
     open source community website at

MySQL 5.5            Last change: 03/22/2013                   11