1MYSQLADMIN(1) MySQL Database System MYSQLADMIN(1)
2
6 mysqladmin - client for administering a MySQL server
7
9 mysqladmin [options] command [command-options] [command
10 [command-options]]
11 ...
12
14 mysqladmin is a client for performing administrative operations. You
15 can use it to check the server's configuration and current status, to
16 create and drop databases, and more.
17 Invoke mysqladmin like this:
19 shell> mysqladmin [options] command [command-arg] [command [command-arg]] ...
21 mysqladmin supports the following commands. Some of the commands take
23 an argument following the command name.
24 · create db_name
26 Create a new database named db_name.
28 · debug
30 Tell the server to write debug information to the error log. Format
32 and content of this information is subject to change.
33 Beginning with MySQL 5.1.12, this includes information about the
35 Event Scheduler. See Section 19.4.5, “Event Scheduler Status”.
36 · drop db_name
38 Delete the database named db_name and all its tables.
40 · extended-status
42 Display the server status variables and their values.
44 · flush-hosts
46 Flush all information in the host cache.
48 · flush-logs
50 Flush all logs.
52 · flush-privileges
54 Reload the grant tables (same as reload).
56 · flush-status
58 Clear status variables.
60 · flush-tables
62 Flush all tables.
64 · flush-threads
66 Flush the thread cache.
68 · kill id,id,...
70 Kill server threads. If multiple thread ID values are given, there
72 must be no spaces in the list.
73 · old-password new-password
75 This is like the password command but stores the password using the
77 old (pre-4.1) password-hashing format. (See Section 6.1.2.4,
78 “Password Hashing in MySQL”.)
79 · password new-password
81 Set a new password. This changes the password to new-password for
83 the account that you use with mysqladmin for connecting to the
84 server. Thus, the next time you invoke mysqladmin (or any other
85 client program) using the same account, you will need to specify
86 the new password.
87 If the new-password value contains spaces or other characters that
89 are special to your command interpreter, you need to enclose it
90 within quotation marks. On Windows, be sure to use double quotation
91 marks rather than single quotation marks; single quotation marks
92 are not stripped from the password, but rather are interpreted as
93 part of the password. For example:
94 shell> mysqladmin password "my new password"
96 Caution
98 Do not use this command used if the server was started with the
99 --skip-grant-tables option. No password change will be applied.
100 This is true even if you precede the password command with
101 flush-privileges on the same command line to re-enable the
102 grant tables because the flush operation occurs after you
103 connect. However, you can use mysqladmin flush-privileges to
104 re-enable the grant table and then use a separate mysqladmin
105 password command to change the password.
106 · ping
108 Check whether the server is available. The return status from
110 mysqladmin is 0 if the server is running, 1 if it is not. This is 0
111 even in case of an error such as Access denied, because this means
112 that the server is running but refused the connection, which is
113 different from the server not running.
114 · processlist
116 Show a list of active server threads. This is like the output of
118 the SHOW PROCESSLIST statement. If the --verbose option is given,
119 the output is like that of SHOW FULL PROCESSLIST. (See
120 Section 13.7.5.31, “SHOW PROCESSLIST Syntax”.)
121 · reload
123 Reload the grant tables.
125 · refresh
127 Flush all tables and close and open log files.
129 · shutdown
131 Stop the server.
133 · start-slave
135 Start replication on a slave server.
137 · status
139 Display a short server status message.
141 · stop-slave
143 Stop replication on a slave server.
145 · variables
147 Display the server system variables and their values.
149 · version
151 Display version information from the server.
153 All commands can be shortened to any unique prefix. For example:
155 shell> mysqladmin proc stat
157 +----+-------+-----------+----+---------+------+-------+------------------+
158 | Id | User | Host | db | Command | Time | State | Info |
159 +----+-------+-----------+----+---------+------+-------+------------------+
160 | 51 | monty | localhost | | Query | 0 | | show processlist |
161 +----+-------+-----------+----+---------+------+-------+------------------+
162 Uptime: 1473624 Threads: 1 Questions: 39487
163 Slow queries: 0 Opens: 541 Flush tables: 1
164 Open tables: 19 Queries per second avg: 0.0268
165 The mysqladmin status command result displays the following values:
168 · Uptime
170 The number of seconds the MySQL server has been running.
172 · Threads
174 The number of active threads (clients).
176 · Questions
178 The number of questions (queries) from clients since the server was
180 started.
181 · Slow queries
183 The number of queries that have taken more than long_query_time
185 seconds. See Section 5.2.5, “The Slow Query Log”.
186 · Opens
188 The number of tables the server has opened.
190 · Flush tables
192 The number of flush-*, refresh, and reload commands the server has
194 executed.
195 · Open tables
197 The number of tables that currently are open.
199 · Memory in use
201 The amount of memory allocated directly by mysqld. This value is
203 displayed only when MySQL has been compiled with --with-debug=full.
204 · Maximum memory used
206 The maximum amount of memory allocated directly by mysqld. This
208 value is displayed only when MySQL has been compiled with
209 --with-debug=full.
210 If you execute mysqladmin shutdown when connecting to a local server
212 using a Unix socket file, mysqladmin waits until the server's process
213 ID file has been removed, to ensure that the server has stopped
214 properly.
215 mysqladmin supports the following options, which can be specified on
217 the command line or in the [mysqladmin] and [client] groups of an
218 option file. mysqladmin also supports the options for processing
219 option files described at Section 4.2.3.4, “Command-Line Options that
220 Affect Option-File Handling”.
221 · --help, -?
223 Display a help message and exit.
225 · --bind-address=ip_address
227 On a computer having multiple network interfaces, this option can
229 be used to select which interface is employed when connecting to
230 the MySQL server.
231 This option is supported only in the version of mysqladmin that is
233 supplied with MySQL Cluster, beginning with MySQL Cluster NDB
234 6.3.4. It is not available in standard MySQL 5.1 releases.
235 · --character-sets-dir=path
237 The directory where character sets are installed. See Section 10.5,
239 “Character Set Configuration”.
240 · --compress, -C
242 Compress all information sent between the client and the server if
244 both support compression.
245 · --count=N, -c N
247 The number of iterations to make for repeated command execution if
249 the --sleep option is given.
250 · --debug[=debug_options], -# [debug_options]
252 Write a debugging log. A typical debug_options string is
254 'd:t:o,file_name'. The default is 'd:t:o,/tmp/mysqladmin.trace'.
255 · --debug-check
257 Print some debugging information when the program exits. This
259 option was added in MySQL 5.1.21.
260 · --debug-info
262 Print debugging information and memory and CPU usage statistics
264 when the program exits. This option was added in MySQL 5.1.14.
265 · --default-character-set=charset_name
267 Use charset_name as the default character set. See Section 10.5,
269 “Character Set Configuration”.
270 · --force, -f
272 Do not ask for confirmation for the drop db_name command. With
274 multiple commands, continue even if an error occurs.
275 · --host=host_name, -h host_name
277 Connect to the MySQL server on the given host.
279 · --no-beep, -b
281 Suppress the warning beep that is emitted by default for errors
283 such as a failure to connect to the server. This option was added
284 in MySQL 5.1.17.
285 · --password[=password], -p[password]
287 The password to use when connecting to the server. If you use the
289 short option form (-p), you cannot have a space between the option
290 and the password. If you omit the password value following the
291 --password or -p option on the command line, mysqladmin prompts for
292 one.
293 Specifying a password on the command line should be considered
295 insecure. See Section 6.1.2.1, “End-User Guidelines for Password
296 Security”. You can use an option file to avoid giving the password
297 on the command line.
298 · --pipe, -W
300 On Windows, connect to the server using a named pipe. This option
302 applies only if the server supports named-pipe connections.
303 · --port=port_num, -P port_num
305 The TCP/IP port number to use for the connection.
307 · --protocol={TCP|SOCKET|PIPE|MEMORY}
309 The connection protocol to use for connecting to the server. It is
311 useful when the other connection parameters normally would cause a
312 protocol to be used other than the one you want. For details on the
313 permissible values, see Section 4.2.2, “Connecting to the MySQL
314 Server”.
315 · --relative, -r
317 Show the difference between the current and previous values when
319 used with the --sleep option. This option works only with the
320 extended-status command.
321 · --silent, -s
323 Exit silently if a connection to the server cannot be established.
325 · --sleep=delay, -i delay
327 Execute commands repeatedly, sleeping for delay seconds in between.
329 The --count option determines the number of iterations. If --count
330 is not given, mysqladmin executes commands indefinitely until
331 interrupted.
332 · --socket=path, -S path
334 For connections to localhost, the Unix socket file to use, or, on
336 Windows, the name of the named pipe to use.
337 · --ssl*
339 Options that begin with --ssl specify whether to connect to the
341 server using SSL and indicate where to find SSL keys and
342 certificates. See Section 6.3.6.4, “SSL Command Options”.
343 · --user=user_name, -u user_name
345 The MySQL user name to use when connecting to the server.
347 · --verbose, -v
349 Verbose mode. Print more information about what the program does.
351 · --version, -V
353 Display version information and exit.
355 · --vertical, -E
357 Print output vertically. This is similar to --relative, but prints
359 output vertically.
360 · --wait[=count], -w[count]
362 If the connection cannot be established, wait and retry instead of
364 aborting. If a count value is given, it indicates the number of
365 times to retry. The default is one time.
366 You can also set the following variables by using --var_name=value The
368 --set-variable format is deprecated and is removed in MySQL 5.5.
369 · connect_timeout
371 The maximum number of seconds before connection timeout. The
373 default value is 43200 (12 hours).
374 · shutdown_timeout
376 The maximum number of seconds to wait for server shutdown. The
378 default value is 3600 (1 hour).
379
381 Copyright © 1997, 2013, Oracle and/or its affiliates. All rights
382 reserved.
383 This documentation is free software; you can redistribute it and/or
385 modify it only under the terms of the GNU General Public License as
386 published by the Free Software Foundation; version 2 of the License.
387 This documentation is distributed in the hope that it will be useful,
389 but WITHOUT ANY WARRANTY; without even the implied warranty of
390 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
391 General Public License for more details.
392 You should have received a copy of the GNU General Public License along
394 with the program; if not, write to the Free Software Foundation, Inc.,
395 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
396 http://www.gnu.org/licenses/.
397
400 For more information, please refer to the MySQL Reference Manual, which
401 may already be installed locally and which is also available online at
402 http://dev.mysql.com/doc/.
403
405 Oracle Corporation (http://dev.mysql.com/).
406MySQL 5.1 11/04/2013 MYSQLADMIN(1)