1MYSQLADMIN(1) MariaDB Database System MYSQLADMIN(1)
2
6 mysqladmin - client for administering a MariaB server
7
9 mysqladmin [options] command [command-arg] [command [command-arg]] ...
10
12 mysqladmin is a client for performing administrative operations. You
13 can use it to check the server´s configuration and current status, to
14 create and drop databases, and more.
15 Invoke mysqladmin like this:
17 shell> mysqladmin [options] command [command-arg] [command [command-arg]] ...
19 mysqladmin supports the following commands. Some of the commands take
21 an argument following the command name.
22 · create db_name
24 Create a new database named db_name.
26 · debug
28 Tell the server to write debug information to the error log.
30 This also includes information about the Event Scheduler.
32 · drop db_name
34 Delete the database named db_name and all its tables.
36 · extended-status
38 Display the server status variables and their values.
40 · flush-all-statistics
42 Flush all statistics tables.
44 · flush-all-status
46 Flush all status and statistics.
48 · flush-binary-log
50 Flush the binary log.
52 · flush-client-statistics
54 Flush client statistics.
56 · flush-engine-log
58 Flush engine log.
60 · flush-error-log
62 Flush error log.
64 · flush-general-log
66 Flush general query log.
68 · flush-hosts
70 Flush all information in the host cache.
72 · flush-index-statistics
74 Flush index statistics.
76 · flush-logs
78 Flush all logs.
80 · flush-privileges
82 Reload the grant tables (same as reload).
84 · flush-relay-log
86 Flush relay log.
88 · flush-slow-log
90 Flush slow query log.
92 · flush-status
94 Clear status variables.
96 · flush-table-statistics
98 Flush table statistics.
100 · flush-tables
102 Flush all tables.
104 · flush-threads
106 Flush the thread cache.
108 · flush-user-resources
110 Flush user resources.
112 · kill id,id,...
114 Kill server threads. If multiple thread ID values are given, there
116 must be no spaces in the list.
117 · old-password new-password
119 This is like the password command but stores the password using the
121 old (pre MySQL 4.1) password-hashing format.
122 · password new-password
124 Set a new password. This changes the password to new-password for
126 the account that you use with mysqladmin for connecting to the
127 server. Thus, the next time you invoke mysqladmin (or any other
128 client program) using the same account, you will need to specify
129 the new password.
130 If the new-password value contains spaces or other characters that
132 are special to your command interpreter, you need to enclose it
133 within quotes. On Windows, be sure to use double quotes rather than
134 single quotes; single quotes are not stripped from the password,
135 but rather are interpreted as part of the password. For example:
136 shell> mysqladmin password "my new password"
138 Caution
140 Do not use this command used if the server was started with the
141 --skip-grant-tables option. No password change will be applied.
142 This is true even if you precede the password command with
143 flush-privileges on the same command line to re-enable the
144 grant tables because the flush operation occurs after you
145 connect. However, you can use mysqladmin flush-privileges to
146 re-enable the grant table and then use a separate mysqladmin
147 password command to change the password.
148 · ping
150 Check whether the server is alive. The return status from
152 mysqladmin is 0 if the server is running, 1 if it is not. This is 0
153 even in case of an error such as Access denied, because this means
154 that the server is running but refused the connection, which is
155 different from the server not running.
156 · processlist
158 Show a list of active server threads. This is like the output of
160 the SHOW PROCESSLIST statement. If the --verbose option is given,
161 the output is like that of SHOW FULL PROCESSLIST.
162 · reload
164 Reload the grant tables.
166 · refresh
168 Flush all tables and close and open log files.
170 · shutdown
172 Stop the server.
174 · start-all-slaves
176 Start all slaves.
178 · start-slave
180 Start replication on a slave server.
182 · status
184 Display a short server status message.
186 · stop-all-slaves
188 Stop all slaves.
190 · stop-slave
192 Stop replication on a slave server.
194 · variables
196 Display the server system variables and their values.
198 · version
200 Display version information from the server.
202 All commands can be shortened to any unique prefix. For example:
204 shell> mysqladmin proc stat
206 +----+-------+-----------+----+---------+------+-------+------------------+
207 | Id | User | Host | db | Command | Time | State | Info |
208 +----+-------+-----------+----+---------+------+-------+------------------+
209 | 51 | monty | localhost | | Query | 0 | | show processlist |
210 +----+-------+-----------+----+---------+------+-------+------------------+
211 Uptime: 1473624 Threads: 1 Questions: 39487
212 Slow queries: 0 Opens: 541 Flush tables: 1
213 Open tables: 19 Queries per second avg: 0.0268
214 The mysqladmin status command result displays the following values:
217 · Uptime
219 The number of seconds the MariaDB server has been running.
221 · Threads
223 The number of active threads (clients).
225 · Questions
227 The number of questions (queries) from clients since the server was
229 started.
230 · Slow queries
232 The number of queries that have taken more than long_query_time
234 seconds.
235 · Opens
237 The number of tables the server has opened.
239 · Flush tables
241 The number of flush-*, refresh, and reload commands the server has
243 executed.
244 · Open tables
246 The number of tables that currently are open.
248 · Memory in use
250 The amount of memory allocated directly by mysqld. This value is
252 displayed only when MariaDB has been compiled with
253 --with-debug=full.
254 · Maximum memory used
256 The maximum amount of memory allocated directly by mysqld. This
258 value is displayed only when MariaDB has been compiled with
259 --with-debug=full.
260 If you execute mysqladmin shutdown when connecting to a local server
262 using a Unix socket file, mysqladmin waits until the server´s process
263 ID file has been removed, to ensure that the server has stopped
264 properly.
265 mysqladmin supports the following options, which can be specified on
267 the command line or in the [mysqladmin] and [client] option file
268 groups.
269 · --help, -?
271 Display help and exit.
273 · --character-sets-dir=path
275 The directory where character sets are installed.
277 · --compress, -C
279 Compress all information sent between the client and the server if
281 both support compression.
282 · --connect-timeout=timeout
284 Equivalent to --connect_timeout, see the end of this section.
286 · --count=N, -c N
288 The number of iterations to make for repeated command execution if
290 the --sleep option is given.
291 · --debug[=debug_options], -# [debug_options]
293 Write a debugging log. A typical debug_options string is
295 ´d:t:o,file_name´. The default is ´d:t:o,/tmp/mysqladmin.trace´.
296 · --debug-check
298 Check memory and open file usage at exit..
300 · --debug-info
302 Print debugging information and memory and CPU usage statistics
304 when the program exits.
305 · --default-auth
307 Default authentication client-side plugin to use.
309 · --default-character-set=charset_name
311 Use charset_name as the default character set.
313 · --defaults-extra-file=filename
315 Set filename as the file to read default options from after the
317 global defaults files has been read. Must be given as first
318 option.
319 · --defaults-file=filename
321 Set filename as the file to read default options from, override
323 global defaults files. Must be given as first option.
324 · --force, -f
326 Do not ask for confirmation for the drop db_name command. With
328 multiple commands, continue even if an error occurs.
329 · --host=host_name, -h host_name
331 Connect to the MariaDB server on the given host.
333 · --local, -l
335 Suppress the SQL command(s) from being written to the binary log by
337 using FLUSH LOCAL or enabling sql_log_bin=0 for the session.
338 · --no-beep, -b
340 Suppress the warning beep that is emitted by default for errors
342 such as a failure to connect to the server.
343 · --no-defaults
345 Do not read default options from any option file. This must be
347 given as the first argument.
348 · --password[=password], -p[password]
350 The password to use when connecting to the server. If you use the
352 short option form (-p), you cannot have a space between the option
353 and the password. If you omit the password value following the
354 --password or -p option on the command line, mysqladmin prompts for
355 one.
356 Specifying a password on the command line should be considered
358 insecure.
359 · --pipe, -W
361 On Windows, connect to the server via a named pipe. This option
363 applies only if the server supports named-pipe connections.
364 · --port=port_num, -P port_num
366 The TCP/IP port number to use for the connection or 0 for default
368 to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services,
369 built-in default (3306).
370 · --print-defaults
372 Print the program argument list and exit. This must be given as the
374 first argument.
375 · --protocol={TCP|SOCKET|PIPE|MEMORY}
377 The connection protocol to use for connecting to the server. It is
379 useful when the other connection parameters normally would cause a
380 protocol to be used other than the one you want.
381 · --relative, -r
383 Show the difference between the current and previous values when
385 used with the --sleep option. Currently, this option works only
386 with the extended-status command.
387 · --shutdown-timeouttimeout
389 Equivalent of --shutdown_timeout, see the end of this section.
391 · --silent, -s
393 Exit silently if a connection to the server cannot be established.
395 · --sleep=delay, -i delay
397 Execute commands repeatedly, sleeping for delay seconds in between.
399 The --count option determines the number of iterations. If --count
400 is not given, mysqladmin executes commands indefinitely until
401 interrupted.
402 · --socket=path, -S path
404 For connections to localhost, the Unix socket file to use, or, on
406 Windows, the name of the named pipe to use.
407 · --ssl
409 Enable SSL for connection (automatically enabled with other flags).
411 Disable with --skip-ssl.
412 · --ssl-ca=name
414 CA file in PEM format (check OpenSSL docs, implies --ssl).
416 · --ssl-capath=name
418 CA directory (check OpenSSL docs, implies --ssl).
420 · --ssl-cert=name
422 X509 cert in PEM format (check OpenSSL docs, implies --ssl).
424 · --ssl-cipher=name
426 SSL cipher to use (check OpenSSL docs, implies --ssl).
428 · --ssl-key=name
430 X509 key in PEM format (check OpenSSL docs, implies --ssl).
432 · --ssl-crl=name
434 Certificate revocation list (check OpenSSL docs, implies --ssl).
436 · --ssl-crlpath=name
438 Certificate revocation list path (check OpenSSL docs, implies
440 --ssl).
441 · --ssl-verify-server-cert
443 Verify server's "Common Name" in its cert against hostname used
445 when connecting. This option is disabled by default.
446 · --tls-version=name,
448 Accepts a comma-separated list of TLS protocol versions. A TLS
450 protocol version will only be enabled if it is present in this
451 list. All other TLS protocol versions will not be permitted.
452 · --user=user_name, -u user_name
454 The MariaDB user name to use when connecting to the server.
456 · --verbose, -v
458 Verbose mode. Print more information about what the program does.
460 · --version, -V
462 Display version information and exit.
464 · --vertical, -E
466 Print output vertically. This is similar to --relative, but prints
468 output vertically.
469 · --wait[=count], -w[count]
471 If the connection cannot be established, wait and retry instead of
473 aborting. If a count value is given, it indicates the number of
474 times to retry. The default is one time.
475 · --wait-for-all-slaves
477 Wait for the last binlog event to be sent to all connected slaves
479 before shutting down. This option is off by default.
480 You can also set the following variables by using --var_name=value
482 · connect_timeout
484 The maximum number of seconds before connection timeout. The
486 default value is 43200 (12 hours).
487 · shutdown_timeout
489 The maximum number of seconds to wait for server shutdown. The
491 default value is 3600 (1 hour).
492
494 Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.,
495 2010-2019 MariaDB Foundation
496 This documentation is free software; you can redistribute it and/or
498 modify it only under the terms of the GNU General Public License as
499 published by the Free Software Foundation; version 2 of the License.
500 This documentation is distributed in the hope that it will be useful,
502 but WITHOUT ANY WARRANTY; without even the implied warranty of
503 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
504 General Public License for more details.
505 You should have received a copy of the GNU General Public License along
507 with the program; if not, write to the Free Software Foundation, Inc.,
508 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see
509 http://www.gnu.org/licenses/.
510
513 For more information, please refer to the MariaDB Knowledge Base,
514 available online at https://mariadb.com/kb/
515
517 MariaDB Foundation (http://www.mariadb.org/).
518MariaDB 10.4 27 June 2019 MYSQLADMIN(1)