mysqladmin - Man Page

client for administering a MariaDB server (mysqladmin is now a symlink to mariadb-admin)

Synopsis

mysqladmin [options] command [command-arg] [command [command-arg]] ​.​.​.

Description

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​.

All commands can be shortened to any unique prefix​. For example:

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 values:

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] option file groups​.

  • --local, -l

    Suppress the SQL command(s) from being written to the binary log by using FLUSH LOCAL or enabling sql_log_bin=0 for the session​.

-b

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

You can also set the following variables by using --var_name=value

See Also

For more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/

Author

MariaDB Foundation (http://www.mariadb.org/).

Info

15 May 2020 MariaDB 10.11 MariaDB Database System