summaryrefslogtreecommitdiffstats
path: root/man/mysqladmin.1
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
commita2a2e32c02643a0cec111511220227703fda1cd5 (patch)
tree69cc2b631234c2a8e026b9cd4d72676c61c594df /man/mysqladmin.1
parentReleasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff)
downloadmariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz
mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'man/mysqladmin.1')
-rw-r--r--man/mysqladmin.11536
1 files changed, 0 insertions, 1536 deletions
diff --git a/man/mysqladmin.1 b/man/mysqladmin.1
deleted file mode 100644
index 82c5dfc0..00000000
--- a/man/mysqladmin.1
+++ /dev/null
@@ -1,1536 +0,0 @@
-'\" t
-.\"
-.TH "\fBMARIADB-ADMIN\fR" "1" "15 May 2020" "MariaDB 10.11" "MariaDB Database System"
-.\" -----------------------------------------------------------------
-.\" * set default formatting
-.\" -----------------------------------------------------------------
-.\" disable hyphenation
-.nh
-.\" disable justification (adjust text to left margin only)
-.ad l
-.\" -----------------------------------------------------------------
-.\" * MAIN CONTENT STARTS HERE *
-.\" -----------------------------------------------------------------
-.\" mysqladmin
-.\" administration: server
-.\" server administration
-.SH "NAME"
-mariadb-admin \- client for administering a MariaDB server (mysqladmin is now a symlink to mariadb-admin)
-.SH "SYNOPSIS"
-.HP \w'\fBmysqladmin\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIcommand\fR\fR\fB\ [\fR\fB\fIcommand\-arg\fR\fR\fB]\ [\fR\fB\fIcommand\fR\fR\fB\ [\fR\fB\fIcommand\-arg\fR\fR\fB]]\ \&.\&.\&.\fR\ 'u
-\fBmysqladmin [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-arg\fR\fR\fB] [\fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-arg\fR\fR\fB]] \&.\&.\&.\fR
-.SH "DESCRIPTION"
-.PP
-\fBmysqladmin\fR
-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\&.
-.PP
-Invoke
-\fBmysqladmin\fR
-like this:
-.sp
-.if n \{\
-.RS 4
-.\}
-.nf
-shell> \fBmysqladmin [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-arg\fR\fR\fB] [\fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-arg\fR\fR\fB]] \&.\&.\&.\fR
-.fi
-.if n \{\
-.RE
-.\}
-.PP
-\fBmysqladmin\fR
-supports the following commands\&. Some of the commands take an argument following the command name\&.
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-create \fIdb_name\fR
-.sp
-Create a new database named
-\fIdb_name\fR\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-debug
-.sp
-Tell the server to write debug information to the error log\&.
-.sp
-This also includes information about the Event Scheduler\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-drop \fIdb_name\fR
-.sp
-Delete the database named
-\fIdb_name\fR
-and all its tables\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-extended\-status
-.sp
-Display the server status variables and their values\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-all\-statistics
-.sp
-Flush all statistics tables\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-all\-status
-.sp
-Flush all status and statistics\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-binary\-log
-.sp
-Flush the binary log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-client\-statistics
-.sp
-Flush client statistics\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-engine\-log
-.sp
-Flush engine log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-error\-log
-.sp
-Flush error log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-general\-log
-.sp
-Flush general query log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-hosts
-.sp
-Flush all information in the host cache\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-index\-statistics
-.sp
-Flush index statistics\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-logs
-.sp
-Flush all logs\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-privileges
-.sp
-Reload the grant tables (same as
-reload)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-relay\-log
-.sp
-Flush relay log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-slow\-log
-.sp
-Flush slow query log\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-ssl
-.sp
-Flush SSL certificates\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-status
-.sp
-Clear status variables\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-table\-statistics
-.sp
-Flush table statistics\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-tables
-.sp
-Flush all tables\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-threads
-.sp
-Flush the thread cache\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-flush\-user\-resources
-.sp
-Flush user resources\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-kill \fIid\fR,\fIid\fR,\&.\&.\&.
-.sp
-Kill server threads\&. If multiple thread ID values are given, there must be no spaces in the list\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-old\-password \fInew\-password\fR
-.sp
-This is like the
-password
-command but stores the password using the old (pre MySQL 4\&.1) password\-hashing format\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-password \fInew\-password\fR
-.sp
-Set a new password\&. This changes the password to
-\fInew\-password\fR
-for the account that you use with
-\fBmysqladmin\fR
-for connecting to the server\&. Thus, the next time you invoke
-\fBmysqladmin\fR
-(or any other client program) using the same account, you will need to specify the new password\&.
-.sp
-If the
-\fInew\-password\fR
-value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotes\&. On Windows, be sure to use double quotes rather than single quotes; single quotes are not stripped from the password, but rather are interpreted as part of the password\&. For example:
-.sp
-.if n \{\
-.RS 4
-.\}
-.nf
-shell> \fBmysqladmin password "my new password"\fR
-.fi
-.if n \{\
-.RE
-.\}
-.if n \{\
-.sp
-.\}
-.RS 4
-.it 1 an-trap
-.nr an-no-space-flag 1
-.nr an-break-flag 1
-.br
-.ps +1
-\fBCaution\fR
-.ps -1
-.br
-Do not use this command used if the server was started with the
-\fB\-\-skip\-grant\-tables\fR
-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
-\fBmysqladmin flush\-privileges\fR
-to re\-enable the grant table and then use a separate
-\fBmysqladmin password\fR
-command to change the password\&.
-.sp .5v
-.RE
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-ping
-.sp
-Check whether the server is alive\&. The return status from
-\fBmysqladmin\fR
-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\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-processlist
-.sp
-Show a list of active server threads\&. This is like the output of the
-SHOW PROCESSLIST
-statement\&. If the
-\fB\-\-verbose\fR
-option is given, the output is like that of
-SHOW FULL PROCESSLIST\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-reload
-.sp
-Reload the grant tables\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-refresh
-.sp
-Flush all tables and close and open log files\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-shutdown
-.sp
-Stop the server\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-start\-all\-slaves
-.sp
-Start all slaves\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-start\-slave
-.sp
-Start replication on a slave server\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-status
-.sp
-Display a short server status message\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-stop\-all\-slaves
-.sp
-Stop all slaves\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-stop\-slave
-.sp
-Stop replication on a slave server\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-variables
-.sp
-Display the server system variables and their values\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-version
-.sp
-Display version information from the server\&.
-.RE
-.PP
-All commands can be shortened to any unique prefix\&. For example:
-.sp
-.if n \{\
-.RS 4
-.\}
-.nf
-shell> \fBmysqladmin proc stat\fR
-+\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
-| 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
-.fi
-.if n \{\
-.RE
-.\}
-.sp
-.\" status command: results
-.PP
-The
-\fBmysqladmin status\fR
-command result displays the following values:
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" uptime
-Uptime
-.sp
-The number of seconds the MariaDB server has been running\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" threads
-Threads
-.sp
-The number of active threads (clients)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" questions
-Questions
-.sp
-The number of questions (queries) from clients since the server was started\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" slow queries
-Slow queries
-.sp
-The number of queries that have taken more than
-log_slow_query_time
-seconds\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" opens
-Opens
-.sp
-The number of tables the server has opened\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" flush tables
-.\" tables: flush
-Flush tables
-.sp
-The number of
-flush\-*,
-refresh, and
-reload
-commands the server has executed\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" open tables
-Open tables
-.sp
-The number of tables that currently are open\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" memory use
-Memory in use
-.sp
-The amount of memory allocated directly by
-\fBmysqld\fR\&. This value is displayed only when MariaDB has been compiled with
-\fB\-\-with\-debug=full\fR\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" maximum memory used
-Maximum memory used
-.sp
-The maximum amount of memory allocated directly by
-\fBmysqld\fR\&. This value is displayed only when MariaDB has been compiled with
-\fB\-\-with\-debug=full\fR\&.
-.RE
-.PP
-If you execute
-\fBmysqladmin shutdown\fR
-when connecting to a local server using a Unix socket file,
-\fBmysqladmin\fR
-waits until the server's process ID file has been removed, to ensure that the server has stopped properly\&.
-.\" mysqladmin command options
-.\" command options: mysqladmin
-.\" options: command-line: mysqladmin
-.\" startup parameters: mysqladmin
-.PP
-\fBmysqladmin\fR
-supports the following options, which can be specified on the command line or in the
-[mysqladmin]
-and
-[client]
-option file groups\&.
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: help option
-.\" help option: mysqladmin
-\fB\-\-help\fR,
-\fB\-?\fR
-.sp
-Display help and exit\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: character-sets-dir option
-.\" character-sets-dir option: mysqladmin
-\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
-.sp
-The directory where character sets are installed\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: compress option
-.\" compress option: mysqladmin
-\fB\-\-compress\fR,
-\fB\-C\fR
-.sp
-Compress all information sent between the client and the server if both support compression\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: connect-timeout option
-.\" connect-timeout option: mysqladmin
-\fB\-\-connect-timeout=\fR\fB\fItimeout\fR\fR
-.sp
-Equivalent to \fB\-\-connect_timeout\fR, see the end of this section\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: count option
-.\" count option: mysqladmin
-\fB\-\-count=\fR\fB\fIN\fR\fR,
-\fB\-c \fR\fB\fIN\fR\fR
-.sp
-The number of iterations to make for repeated command execution if the
-\fB\-\-sleep\fR
-option is given\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: debug option
-.\" debug option: mysqladmin
-\fB\-\-debug[=\fR\fB\fIdebug_options\fR\fR\fB]\fR,
-\fB\-# [\fR\fB\fIdebug_options\fR\fR\fB]\fR
-.sp
-Write a debugging log\&. A typical
-\fIdebug_options\fR
-string is 'd:t:o,\fIfile_name\fR'. The default is 'd:t:o,/tmp/mysqladmin.trace'.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: debug-check option
-.\" debug-check option: mysqladmin
-\fB\-\-debug\-check\fR
-.sp
-Check memory and open file usage at exit.\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: debug-info option
-.\" debug-info option: mysqladmin
-\fB\-\-debug\-info\fR
-.sp
-Print debugging information and memory and CPU usage statistics when the program exits\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: default-auth option
-.\" default-auth option: mysqladmin
-\fB\-\-default\-auth\fR
-.sp
-Default authentication client-side plugin to use\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: default-character-set option
-.\" default-character-set option: mysqladmin
-\fB\-\-default\-character\-set=\fR\fB\fIcharset_name\fR\fR
-.sp
-Use
-\fIcharset_name\fR
-as the default character set\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: defaults-extra-file option
-.\" defaults-extra-file option: mysqladmin
-\fB\-\-defaults\-extra\-file=\fR\fB\fIfilename\fR\fR
-.sp
-Set \fB\fIfilename\fR\fR as the file to read default options from after the global defaults files has been read\&.
-Must be given as first option\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: defaults-file option
-.\" defaults-file option: mysqladmin
-\fB\-\-defaults\-file=\fR\fB\fIfilename\fR\fR
-.sp
-Set \fB\fIfilename\fR\fR as the file to read default options from, override global defaults files\&. Must be given as first option\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: force option
-.\" force option: mysqladmin
-\fB\-\-force\fR,
-\fB\-f\fR
-.sp
-Do not ask for confirmation for the
-drop \fIdb_name\fR
-command\&. With multiple commands, continue even if an error occurs\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: host option
-.\" host option: mysqladmin
-\fB\-\-host=\fR\fB\fIhost_name\fR\fR,
-\fB\-h \fR\fB\fIhost_name\fR\fR
-.sp
-Connect to the MariaDB server on the given host\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: local option
-.\" local option: mysqladmin
-\fB\-\-local\fR,
-\fB\-l\fR
-.sp
-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\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.\" mysqladmin: no-beep option
-.\" no-beep option: mysqladmin
-\fB\-\-no\-beep\fR,
-\fB\-b\fR
-.sp
-Suppress the warning beep that is emitted by default for errors such as a failure to connect to the server\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: no-defaults option
-.\" no-defaults option: mysqladmin
-\fB\-\-no\-defaults\fR
-.sp
-Do not read default options from any option file\&. This must be given as the first argument\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: password option
-.\" password option: mysqladmin
-\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
-\fB\-p[\fR\fB\fIpassword\fR\fR\fB]\fR
-.sp
-The password to use when connecting to the server\&. If you use the short option form (\fB\-p\fR), you
-\fIcannot\fR
-have a space between the option and the password\&. If you omit the
-\fIpassword\fR
-value following the
-\fB\-\-password\fR
-or
-\fB\-p\fR
-option on the command line,
-\fBmysqladmin\fR
-prompts for one\&.
-.sp
-Specifying a password on the command line should be considered insecure\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: pipe option
-.\" pipe option: mysqladmin
-\fB\-\-pipe\fR,
-\fB\-W\fR
-.sp
-On Windows, connect to the server via a named pipe\&. This option applies only if the server supports named\-pipe connections\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: port option
-.\" port option: mysqladmin
-\fB\-\-port=\fR\fB\fIport_num\fR\fR,
-\fB\-P \fR\fB\fIport_num\fR\fR
-.sp
-The TCP/IP port number to use for the connection or 0 for default to,
-in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306)\&.
-Forces --protocol=tcp when specified on the command line without other connection properties\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: print-defaults option
-.\" print-defaults option: mysqladmin
-\fB\-\-print\-defaults\fR
-.sp
-Print the program argument list and exit\&. This must be given as the first argument\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: protocol option
-.\" protocol option: mysqladmin
-\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
-.sp
-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\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: relative option
-.\" relative option: mysqladmin
-\fB\-\-relative\fR,
-\fB\-r\fR
-.sp
-Show the difference between the current and previous values when used with the
-\fB\-\-sleep\fR
-option\&. Currently, this option works only with the
-extended\-status
-command\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: shutdown-timeout option
-.\" shutdown-timeout option: mysqladmin
-\fB\-\-shutdown\-timeout\fR\fB\fItimeout\fR\fR
-.sp
-Equivalent of \fB\-\-shutdown_timeout\fR, see the end of this section\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: silent option
-.\" silent option: mysqladmin
-\fB\-\-silent\fR,
-\fB\-s\fR
-.sp
-Exit silently if a connection to the server cannot be established\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: sleep option
-.\" sleep option: mysqladmin
-\fB\-\-sleep=\fR\fB\fIdelay\fR\fR,
-\fB\-i \fR\fB\fIdelay\fR\fR
-.sp
-Execute commands repeatedly, sleeping for
-\fIdelay\fR
-seconds in between\&. The
-\fB\-\-count\fR
-option determines the number of iterations\&. If
-\fB\-\-count\fR
-is not given,
-\fBmysqladmin\fR
-executes commands indefinitely until interrupted\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: socket option
-.\" socket option: mysqladmin
-\fB\-\-socket=\fR\fB\fIpath\fR\fR,
-\fB\-S \fR\fB\fIpath\fR\fR
-.sp
-For connections to
-localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use\&.
-Forces --protocol=socket when specified on the command line without other connection properties; on Windows, forces --protocol=pipe\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL options
-.\" SSL options: mysqladmin
-\fB\-\-ssl\fR
-.sp
-Enable SSL for connection (automatically enabled with other flags). Disable with
-\fB\-\-skip-ssl\fR\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL CA option
-.\" SSL CA option: mysqladmin
-\fB\-\-ssl\-ca=\fIname\fR
-.sp
-CA file in PEM format (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL CA Path option
-.\" SSL CA Path option: mysqladmin
-\fB\-\-ssl\-capath=\fIname\fR
-.sp
-CA directory (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Cert option
-.\" SSL Cert option: mysqladmin
-\fB\-\-ssl\-cert=\fIname\fR
-.sp
-X509 cert in PEM format (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Cipher option
-.\" SSL Cipher option: mysqladmin
-\fB\-\-ssl\-cipher=\fIname\fR
-.sp
-SSL cipher to use (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Key option
-.\" SSL Key option: mysqladmin
-\fB\-\-ssl\-key=\fIname\fR
-.sp
-X509 key in PEM format (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Crl option
-.\" SSL CRL option: mysqladmin
-\fB\-\-ssl\-crl=\fIname\fR
-.sp
-Certificate revocation list (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Crlpath option
-.\" SSL Crlpath option: mysqladmin
-\fB\-\-ssl\-crlpath=\fIname\fR
-.sp
-Certificate revocation list path (check OpenSSL docs, implies
-\fB\-\-ssl\fR)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: SSL Verify Server Cert option
-.\" SSL Verify Server Cert option: mysqladmin
-\fB\-\-ssl\-verify\-server\-cert\fR
-.sp
-Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: TLS Version option
-.\" TLS Version option: mysqladmin
-\fB\-\-tls\-version=\fR\fB\fIname\fR\fR,
-.sp
-Accepts a comma-separated list of TLS protocol versions\&. A TLS protocol version will only be enabled if it
-is present in this list\&. All other TLS protocol versions will not be permitted\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: user option
-.\" user option: mysqladmin
-\fB\-\-user=\fR\fB\fIuser_name\fR\fR,
-\fB\-u \fR\fB\fIuser_name\fR\fR
-.sp
-The MariaDB user name to use when connecting to the server\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: verbose option
-.\" verbose option: mysqladmin
-\fB\-\-verbose\fR,
-\fB\-v\fR
-.sp
-Verbose mode\&. Print more information about what the program does\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: version option
-.\" version option: mysqladmin
-\fB\-\-version\fR,
-\fB\-V\fR
-.sp
-Display version information and exit\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: vertical option
-.\" vertical option: mysqladmin
-\fB\-\-vertical\fR,
-\fB\-E\fR
-.sp
-Print output vertically\&. This is similar to
-\fB\-\-relative\fR, but prints output vertically\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: wait option
-.\" wait option: mysqladmin
-\fB\-\-wait[=\fR\fB\fIcount\fR\fR\fB]\fR,
-\fB\-w[\fR\fB\fIcount\fR\fR\fB]\fR
-.sp
-If the connection cannot be established, wait and retry instead of aborting\&. If a
-\fIcount\fR
-value is given, it indicates the number of times to retry\&. The default is one time\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" mysqladmin: --wait-for-all-slaves option
-.\" --wait-for-all-slaves option: mysqladmin
-\fB\-\-wait\-for\-all\-slaves\fR
-.sp
-Wait for the last binlog event to be sent to all connected slaves before shutting down\&.
-This option is off by default\&.
-.RE
-.PP
-You can also set the following variables by using
-\fB\-\-\fR\fB\fIvar_name\fR\fR\fB=\fR\fB\fIvalue\fR\fR
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" connect_timeout variable
-.\" timeout: connect_timeout variable
-connect_timeout
-.sp
-The maximum number of seconds before connection timeout\&. The default value is 43200 (12 hours)\&.
-.RE
-.sp
-.RS 4
-.ie n \{\
-\h'-04'\(bu\h'+03'\c
-.\}
-.el \{\
-.sp -1
-.IP \(bu 2.3
-.\}
-.\" shutdown_timeout variable
-.\" timeout: shutdown_timeout variable
-shutdown_timeout
-.sp
-The maximum number of seconds to wait for server shutdown\&. The default value is 3600 (1 hour)\&.
-.RE
-.SH "COPYRIGHT"
-.br
-.PP
-Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2020 MariaDB Foundation
-.PP
-This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
-.PP
-This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
-.PP
-You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/.
-.sp
-.SH "SEE ALSO"
-For more information, please refer to the MariaDB Knowledge Base, available online at https://mariadb.com/kb/
-.SH AUTHOR
-MariaDB Foundation (http://www.mariadb.org/).