mysqladmin

mysqladmin is an administration program for the mysqld daemon. It can be used to:

• Monitor what the MariaDB clients are doing (processlist)
• Get usage statistics and variables from the MariaDB server
• Create/drop databases
• Flush (reset) logs, statistics and tables
• Kill running queries.
• Stop the server (shutdown)
• Start/stop slaves
• Check if the server is alive (ping)

Usage

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

mysqladmin options

mysqladmin variables

Variables can be set with --variable-name=value.

mysqladmin default options

Default options are read from the following files in the given order:

1. /etc/my.cnf
2. /etc/mysql/my.cnf
3. /usr/etc/my.cnf
4. /.my.cnf

The following groups are read:

1. mysqladmin
2. client
3. client-server
4. client-mariadb

The following options may be given as the first argument:

mysqladmin commands

Command is one or more of the following. Commands may be shortened to a unique prefix.

Examples

Quick check of what the server is doing:

shell> mysqladmin status
Uptime: 8023 Threads: 1 Questions: 14 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.1
shell> mysqladmin processlist
+----+-------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+----+---------+------+-------+------------------+
....
+----+-------+-----------+----+---------+------+-------+------------------+

More extensive information of what is happening 'just now' changing (great for troubleshooting a slow server):

shell> mysqladmin --relative --sleep=1 extended-status | grep -v " 0 "

Check the variables for a running server:

shell> mysqladmin variables | grep datadir
| datadir | /my/data/ |

Using a shortened prefix for the version command:

shell> mysqladmin ver
mysqladmin Ver 9.1 Distrib 10.1.6-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Server version		10.1.6-MariaDB-1~trusty-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			1 hour 33 min 33 sec

Threads: 1 Questions: 281 Slow queries: 0 Opens: 64 Flush tables: 1 Open tables: 76 Queries per second avg: 0.050

Other ways to stop mysqld (unix)

If you get the error:

mysqladmin: shutdown failed; error: 'Access denied; you need (at least one of) the SHUTDOWN privilege(s) for this operation'

It means that you didn't use mysqladmin with a user that has the SUPER or SHUTDOWN privilege.

If you don't know the user password, you can still take the mysqld process down with a system kill command:

kill -SIGTERM pid-of-mysqld-process

The above is identical to mysqladmin shutdown.

On windows you should use:

NET STOP MySQL

With MariaDB 10.0 and newer you can use the SHUTDOWN command from any client.

See also

• SHUTDOWN command
• mytop, a 'top' like program for MariaDB/MySQL that allows you to see what the server is doing. A mytop optimized for MariaDB is included in MariaDB 5.3