| blob | 94000c3bc1a3d25e0cecffa91c47e024edf26ff8 |
1 '\" t
2 .\" Title: \fBmysqladmin\fR
3 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4 .\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
5 .\" Date: 11/04/2013
6 .\" Manual: MySQL Database System
7 .\" Source: MySQL 5.1
8 .\" Language: English
9 .\"
10 .TH "\FBMYSQLADMIN\FR" "1" "11/04/2013" "MySQL 5\&.1" "MySQL Database System"
11 .\" -----------------------------------------------------------------
12 .\" * Define some portability stuff
13 .\" -----------------------------------------------------------------
14 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15 .\" http://bugs.debian.org/507673
16 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
18 .ie \n(.g .ds Aq \(aq
19 .el .ds Aq '
20 .\" -----------------------------------------------------------------
21 .\" * set default formatting
22 .\" -----------------------------------------------------------------
23 .\" disable hyphenation
24 .nh
25 .\" disable justification (adjust text to left margin only)
26 .ad l
27 .\" -----------------------------------------------------------------
28 .\" * MAIN CONTENT STARTS HERE *
29 .\" -----------------------------------------------------------------
30 .\" mysqladmin
31 .\" administration: server
32 .\" server administration
33 .SH "NAME"
34 mysqladmin \- client for administering a MySQL server
35 .SH "SYNOPSIS"
36 .HP \w'\fBmysqladmin\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIcommand\fR\fR\fB\ [\fR\fB\fIcommand\-options\fR\fR\fB]\ [\fR\fB\fIcommand\fR\fR\fB\ [\fR\fB\fIcommand\-options\fR\fR\fB]]\ \&.\&.\&.\fR\ 'u
37 \fBmysqladmin [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-options\fR\fR\fB] [\fR\fB\fIcommand\fR\fR\fB [\fR\fB\fIcommand\-options\fR\fR\fB]] \&.\&.\&.\fR
38 .SH "DESCRIPTION"
39 .PP
40 \fBmysqladmin\fR
41 is a client for performing administrative operations\&. You can use it to check the server\*(Aqs configuration and current status, to create and drop databases, and more\&.
42 .PP
43 Invoke
44 \fBmysqladmin\fR
45 like this:
46 .sp
47 .if n \{\
48 .RS 4
49 .\}
50 .nf
51 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
52 .fi
53 .if n \{\
54 .RE
55 .\}
56 .PP
57 \fBmysqladmin\fR
58 supports the following commands\&. Some of the commands take an argument following the command name\&.
59 .sp
60 .RS 4
61 .ie n \{\
62 \h'-04'\(bu\h'+03'\c
63 .\}
64 .el \{\
65 .sp -1
66 .IP \(bu 2.3
67 .\}
68 create \fIdb_name\fR
69 .sp
70 Create a new database named
71 \fIdb_name\fR\&.
72 .RE
73 .sp
74 .RS 4
75 .ie n \{\
76 \h'-04'\(bu\h'+03'\c
77 .\}
78 .el \{\
79 .sp -1
80 .IP \(bu 2.3
81 .\}
82 debug
83 .sp
84 Tell the server to write debug information to the error log\&. Format and content of this information is subject to change\&.
85 .sp
86 Beginning with MySQL 5\&.1\&.12, this includes information about the Event Scheduler\&. See
87 Section\ \&19.4.5, \(lqEvent Scheduler Status\(rq\&.
88 .RE
89 .sp
90 .RS 4
91 .ie n \{\
92 \h'-04'\(bu\h'+03'\c
93 .\}
94 .el \{\
95 .sp -1
96 .IP \(bu 2.3
97 .\}
98 drop \fIdb_name\fR
99 .sp
100 Delete the database named
101 \fIdb_name\fR
102 and all its tables\&.
103 .RE
104 .sp
105 .RS 4
106 .ie n \{\
107 \h'-04'\(bu\h'+03'\c
108 .\}
109 .el \{\
110 .sp -1
111 .IP \(bu 2.3
112 .\}
113 extended\-status
114 .sp
115 Display the server status variables and their values\&.
116 .RE
117 .sp
118 .RS 4
119 .ie n \{\
120 \h'-04'\(bu\h'+03'\c
121 .\}
122 .el \{\
123 .sp -1
124 .IP \(bu 2.3
125 .\}
126 flush\-hosts
127 .sp
128 Flush all information in the host cache\&.
129 .RE
130 .sp
131 .RS 4
132 .ie n \{\
133 \h'-04'\(bu\h'+03'\c
134 .\}
135 .el \{\
136 .sp -1
137 .IP \(bu 2.3
138 .\}
139 flush\-logs
140 .sp
141 Flush all logs\&.
142 .RE
143 .sp
144 .RS 4
145 .ie n \{\
146 \h'-04'\(bu\h'+03'\c
147 .\}
148 .el \{\
149 .sp -1
150 .IP \(bu 2.3
151 .\}
152 flush\-privileges
153 .sp
154 Reload the grant tables (same as
155 reload)\&.
156 .RE
157 .sp
158 .RS 4
159 .ie n \{\
160 \h'-04'\(bu\h'+03'\c
161 .\}
162 .el \{\
163 .sp -1
164 .IP \(bu 2.3
165 .\}
166 flush\-status
167 .sp
168 Clear status variables\&.
169 .RE
170 .sp
171 .RS 4
172 .ie n \{\
173 \h'-04'\(bu\h'+03'\c
174 .\}
175 .el \{\
176 .sp -1
177 .IP \(bu 2.3
178 .\}
179 flush\-tables
180 .sp
181 Flush all tables\&.
182 .RE
183 .sp
184 .RS 4
185 .ie n \{\
186 \h'-04'\(bu\h'+03'\c
187 .\}
188 .el \{\
189 .sp -1
190 .IP \(bu 2.3
191 .\}
192 flush\-threads
193 .sp
194 Flush the thread cache\&.
195 .RE
196 .sp
197 .RS 4
198 .ie n \{\
199 \h'-04'\(bu\h'+03'\c
200 .\}
201 .el \{\
202 .sp -1
203 .IP \(bu 2.3
204 .\}
205 kill \fIid\fR,\fIid\fR,\&.\&.\&.
206 .sp
207 Kill server threads\&. If multiple thread ID values are given, there must be no spaces in the list\&.
208 .RE
209 .sp
210 .RS 4
211 .ie n \{\
212 \h'-04'\(bu\h'+03'\c
213 .\}
214 .el \{\
215 .sp -1
216 .IP \(bu 2.3
217 .\}
218 old\-password \fInew\-password\fR
219 .sp
220 This is like the
221 password
222 command but stores the password using the old (pre\-4\&.1) password\-hashing format\&. (See
223 Section\ \&6.1.2.4, \(lqPassword Hashing in MySQL\(rq\&.)
224 .RE
225 .sp
226 .RS 4
227 .ie n \{\
228 \h'-04'\(bu\h'+03'\c
229 .\}
230 .el \{\
231 .sp -1
232 .IP \(bu 2.3
233 .\}
234 password \fInew\-password\fR
235 .sp
236 Set a new password\&. This changes the password to
237 \fInew\-password\fR
238 for the account that you use with
239 \fBmysqladmin\fR
240 for connecting to the server\&. Thus, the next time you invoke
241 \fBmysqladmin\fR
242 (or any other client program) using the same account, you will need to specify the new password\&.
243 .sp
244 If the
245 \fInew\-password\fR
246 value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotation marks\&. On Windows, be sure to use double quotation marks rather than single quotation marks; single quotation marks are not stripped from the password, but rather are interpreted as part of the password\&. For example:
247 .sp
248 .if n \{\
249 .RS 4
250 .\}
251 .nf
252 shell> \fBmysqladmin password "my new password"\fR
253 .fi
254 .if n \{\
255 .RE
256 .\}
257 .if n \{\
258 .sp
259 .\}
260 .RS 4
261 .it 1 an-trap
262 .nr an-no-space-flag 1
263 .nr an-break-flag 1
264 .br
265 .ps +1
266 \fBCaution\fR
267 .ps -1
268 .br
269 Do not use this command used if the server was started with the
270 \fB\-\-skip\-grant\-tables\fR
271 option\&. No password change will be applied\&. This is true even if you precede the
272 password
273 command with
274 flush\-privileges
275 on the same command line to re\-enable the grant tables because the flush operation occurs after you connect\&. However, you can use
276 \fBmysqladmin flush\-privileges\fR
277 to re\-enable the grant table and then use a separate
278 \fBmysqladmin password\fR
279 command to change the password\&.
280 .sp .5v
281 .RE
282 .RE
283 .sp
284 .RS 4
285 .ie n \{\
286 \h'-04'\(bu\h'+03'\c
287 .\}
288 .el \{\
289 .sp -1
290 .IP \(bu 2.3
291 .\}
292 ping
293 .sp
294 Check whether the server is available\&. The return status from
295 \fBmysqladmin\fR
296 is 0 if the server is running, 1 if it is not\&. This is 0 even in case of an error such as
297 Access denied, because this means that the server is running but refused the connection, which is different from the server not running\&.
298 .RE
299 .sp
300 .RS 4
301 .ie n \{\
302 \h'-04'\(bu\h'+03'\c
303 .\}
304 .el \{\
305 .sp -1
306 .IP \(bu 2.3
307 .\}
308 processlist
309 .sp
310 Show a list of active server threads\&. This is like the output of the
311 SHOW PROCESSLIST
312 statement\&. If the
313 \fB\-\-verbose\fR
314 option is given, the output is like that of
315 SHOW FULL PROCESSLIST\&. (See
316 Section\ \&13.7.5.31, \(lqSHOW PROCESSLIST Syntax\(rq\&.)
317 .RE
318 .sp
319 .RS 4
320 .ie n \{\
321 \h'-04'\(bu\h'+03'\c
322 .\}
323 .el \{\
324 .sp -1
325 .IP \(bu 2.3
326 .\}
327 reload
328 .sp
329 Reload the grant tables\&.
330 .RE
331 .sp
332 .RS 4
333 .ie n \{\
334 \h'-04'\(bu\h'+03'\c
335 .\}
336 .el \{\
337 .sp -1
338 .IP \(bu 2.3
339 .\}
340 refresh
341 .sp
342 Flush all tables and close and open log files\&.
343 .RE
344 .sp
345 .RS 4
346 .ie n \{\
347 \h'-04'\(bu\h'+03'\c
348 .\}
349 .el \{\
350 .sp -1
351 .IP \(bu 2.3
352 .\}
353 shutdown
354 .sp
355 Stop the server\&.
356 .RE
357 .sp
358 .RS 4
359 .ie n \{\
360 \h'-04'\(bu\h'+03'\c
361 .\}
362 .el \{\
363 .sp -1
364 .IP \(bu 2.3
365 .\}
366 start\-slave
367 .sp
368 Start replication on a slave server\&.
369 .RE
370 .sp
371 .RS 4
372 .ie n \{\
373 \h'-04'\(bu\h'+03'\c
374 .\}
375 .el \{\
376 .sp -1
377 .IP \(bu 2.3
378 .\}
379 status
380 .sp
381 Display a short server status message\&.
382 .RE
383 .sp
384 .RS 4
385 .ie n \{\
386 \h'-04'\(bu\h'+03'\c
387 .\}
388 .el \{\
389 .sp -1
390 .IP \(bu 2.3
391 .\}
392 stop\-slave
393 .sp
394 Stop replication on a slave server\&.
395 .RE
396 .sp
397 .RS 4
398 .ie n \{\
399 \h'-04'\(bu\h'+03'\c
400 .\}
401 .el \{\
402 .sp -1
403 .IP \(bu 2.3
404 .\}
405 variables
406 .sp
407 Display the server system variables and their values\&.
408 .RE
409 .sp
410 .RS 4
411 .ie n \{\
412 \h'-04'\(bu\h'+03'\c
413 .\}
414 .el \{\
415 .sp -1
416 .IP \(bu 2.3
417 .\}
418 version
419 .sp
420 Display version information from the server\&.
421 .RE
422 .PP
423 All commands can be shortened to any unique prefix\&. For example:
424 .sp
425 .if n \{\
426 .RS 4
427 .\}
428 .nf
429 shell> \fBmysqladmin proc stat\fR
430 +\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
431 | Id | User | Host | db | Command | Time | State | Info |
432 +\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
433 | 51 | monty | localhost | | Query | 0 | | show processlist |
434 +\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
435 Uptime: 1473624 Threads: 1 Questions: 39487
436 Slow queries: 0 Opens: 541 Flush tables: 1
437 Open tables: 19 Queries per second avg: 0\&.0268
438 .fi
439 .if n \{\
440 .RE
441 .\}
442 .sp
443 .\" status command: results
444 .PP
445 The
446 \fBmysqladmin status\fR
447 command result displays the following values:
448 .sp
449 .RS 4
450 .ie n \{\
451 \h'-04'\(bu\h'+03'\c
452 .\}
453 .el \{\
454 .sp -1
455 .IP \(bu 2.3
456 .\}
457 .\" uptime
458 Uptime
459 .sp
460 The number of seconds the MySQL server has been running\&.
461 .RE
462 .sp
463 .RS 4
464 .ie n \{\
465 \h'-04'\(bu\h'+03'\c
466 .\}
467 .el \{\
468 .sp -1
469 .IP \(bu 2.3
470 .\}
471 .\" threads
472 Threads
473 .sp
474 The number of active threads (clients)\&.
475 .RE
476 .sp
477 .RS 4
478 .ie n \{\
479 \h'-04'\(bu\h'+03'\c
480 .\}
481 .el \{\
482 .sp -1
483 .IP \(bu 2.3
484 .\}
485 .\" questions
486 Questions
487 .sp
488 The number of questions (queries) from clients since the server was started\&.
489 .RE
490 .sp
491 .RS 4
492 .ie n \{\
493 \h'-04'\(bu\h'+03'\c
494 .\}
495 .el \{\
496 .sp -1
497 .IP \(bu 2.3
498 .\}
499 .\" slow queries
500 Slow queries
501 .sp
502 The number of queries that have taken more than
503 long_query_time
504 seconds\&. See
505 Section\ \&5.2.5, \(lqThe Slow Query Log\(rq\&.
506 .RE
507 .sp
508 .RS 4
509 .ie n \{\
510 \h'-04'\(bu\h'+03'\c
511 .\}
512 .el \{\
513 .sp -1
514 .IP \(bu 2.3
515 .\}
516 .\" opens
517 Opens
518 .sp
519 The number of tables the server has opened\&.
520 .RE
521 .sp
522 .RS 4
523 .ie n \{\
524 \h'-04'\(bu\h'+03'\c
525 .\}
526 .el \{\
527 .sp -1
528 .IP \(bu 2.3
529 .\}
530 .\" flush tables
531 .\" tables: flush
532 Flush tables
533 .sp
534 The number of
535 flush\-*,
536 refresh, and
537 reload
538 commands the server has executed\&.
539 .RE
540 .sp
541 .RS 4
542 .ie n \{\
543 \h'-04'\(bu\h'+03'\c
544 .\}
545 .el \{\
546 .sp -1
547 .IP \(bu 2.3
548 .\}
549 .\" open tables
550 Open tables
551 .sp
552 The number of tables that currently are open\&.
553 .RE
554 .sp
555 .RS 4
556 .ie n \{\
557 \h'-04'\(bu\h'+03'\c
558 .\}
559 .el \{\
560 .sp -1
561 .IP \(bu 2.3
562 .\}
563 .\" memory use
564 Memory in use
565 .sp
566 The amount of memory allocated directly by
567 \fBmysqld\fR\&. This value is displayed only when MySQL has been compiled with
568 \fB\-\-with\-debug=full\fR\&.
569 .RE
570 .sp
571 .RS 4
572 .ie n \{\
573 \h'-04'\(bu\h'+03'\c
574 .\}
575 .el \{\
576 .sp -1
577 .IP \(bu 2.3
578 .\}
579 .\" maximum memory used
580 Maximum memory used
581 .sp
582 The maximum amount of memory allocated directly by
583 \fBmysqld\fR\&. This value is displayed only when MySQL has been compiled with
584 \fB\-\-with\-debug=full\fR\&.
585 .RE
586 .PP
587 If you execute
588 \fBmysqladmin shutdown\fR
589 when connecting to a local server using a Unix socket file,
590 \fBmysqladmin\fR
591 waits until the server\*(Aqs process ID file has been removed, to ensure that the server has stopped properly\&.
592 .\" mysqladmin command options
593 .\" command options: mysqladmin
594 .\" options: command-line: mysqladmin
595 .\" startup parameters: mysqladmin
596 .PP
597 \fBmysqladmin\fR
598 supports the following options, which can be specified on the command line or in the
599 [mysqladmin]
600 and
601 [client]
602 groups of an option file\&.
603 \fBmysqladmin\fR
604 also supports the options for processing option files described at
605 Section\ \&4.2.3.4, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
606 .sp
607 .RS 4
608 .ie n \{\
609 \h'-04'\(bu\h'+03'\c
610 .\}
611 .el \{\
612 .sp -1
613 .IP \(bu 2.3
614 .\}
615 .\" mysqladmin: help option
616 .\" help option: mysqladmin
617 \fB\-\-help\fR,
618 \fB\-?\fR
619 .sp
620 Display a help message and exit\&.
621 .RE
622 .sp
623 .RS 4
624 .ie n \{\
625 \h'-04'\(bu\h'+03'\c
626 .\}
627 .el \{\
628 .sp -1
629 .IP \(bu 2.3
630 .\}
631 .\" mysqladmin: bind-address option
632 .\" bind-address option: mysqladmin
633 \fB\-\-bind\-address=\fR\fB\fIip_address\fR\fR
634 .sp
635 On a computer having multiple network interfaces, this option can be used to select which interface is employed when connecting to the MySQL server\&.
636 .sp
637 This option is supported only in the version of
638 \fBmysqladmin\fR
639 that is supplied with MySQL Cluster, beginning with MySQL Cluster NDB 6\&.3\&.4\&. It is not available in standard MySQL 5\&.1 releases\&.
640 .RE
641 .sp
642 .RS 4
643 .ie n \{\
644 \h'-04'\(bu\h'+03'\c
645 .\}
646 .el \{\
647 .sp -1
648 .IP \(bu 2.3
649 .\}
650 .\" mysqladmin: character-sets-dir option
651 .\" character-sets-dir option: mysqladmin
652 \fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR
653 .sp
654 The directory where character sets are installed\&. See
655 Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
656 .RE
657 .sp
658 .RS 4
659 .ie n \{\
660 \h'-04'\(bu\h'+03'\c
661 .\}
662 .el \{\
663 .sp -1
664 .IP \(bu 2.3
665 .\}
666 .\" mysqladmin: compress option
667 .\" compress option: mysqladmin
668 \fB\-\-compress\fR,
669 \fB\-C\fR
670 .sp
671 Compress all information sent between the client and the server if both support compression\&.
672 .RE
673 .sp
674 .RS 4
675 .ie n \{\
676 \h'-04'\(bu\h'+03'\c
677 .\}
678 .el \{\
679 .sp -1
680 .IP \(bu 2.3
681 .\}
682 .\" mysqladmin: count option
683 .\" count option: mysqladmin
684 \fB\-\-count=\fR\fB\fIN\fR\fR,
685 \fB\-c \fR\fB\fIN\fR\fR
686 .sp
687 The number of iterations to make for repeated command execution if the
688 \fB\-\-sleep\fR
689 option is given\&.
690 .RE
691 .sp
692 .RS 4
693 .ie n \{\
694 \h'-04'\(bu\h'+03'\c
695 .\}
696 .el \{\
697 .sp -1
698 .IP \(bu 2.3
699 .\}
700 .\" mysqladmin: debug option
701 .\" debug option: mysqladmin
702 \fB\-\-debug[=\fR\fB\fIdebug_options\fR\fR\fB]\fR,
703 \fB\-# [\fR\fB\fIdebug_options\fR\fR\fB]\fR
704 .sp
705 Write a debugging log\&. A typical
706 \fIdebug_options\fR
707 string is
708 \*(Aqd:t:o,\fIfile_name\fR\*(Aq\&. The default is
709 \*(Aqd:t:o,/tmp/mysqladmin\&.trace\*(Aq\&.
710 .RE
711 .sp
712 .RS 4
713 .ie n \{\
714 \h'-04'\(bu\h'+03'\c
715 .\}
716 .el \{\
717 .sp -1
718 .IP \(bu 2.3
719 .\}
720 .\" mysqladmin: debug-check option
721 .\" debug-check option: mysqladmin
722 \fB\-\-debug\-check\fR
723 .sp
724 Print some debugging information when the program exits\&. This option was added in MySQL 5\&.1\&.21\&.
725 .RE
726 .sp
727 .RS 4
728 .ie n \{\
729 \h'-04'\(bu\h'+03'\c
730 .\}
731 .el \{\
732 .sp -1
733 .IP \(bu 2.3
734 .\}
735 .\" mysqladmin: debug-info option
736 .\" debug-info option: mysqladmin
737 \fB\-\-debug\-info\fR
738 .sp
739 Print debugging information and memory and CPU usage statistics when the program exits\&. This option was added in MySQL 5\&.1\&.14\&.
740 .RE
741 .sp
742 .RS 4
743 .ie n \{\
744 \h'-04'\(bu\h'+03'\c
745 .\}
746 .el \{\
747 .sp -1
748 .IP \(bu 2.3
749 .\}
750 .\" mysqladmin: default-character-set option
751 .\" default-character-set option: mysqladmin
752 \fB\-\-default\-character\-set=\fR\fB\fIcharset_name\fR\fR
753 .sp
754 Use
755 \fIcharset_name\fR
756 as the default character set\&. See
757 Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.
758 .RE
759 .sp
760 .RS 4
761 .ie n \{\
762 \h'-04'\(bu\h'+03'\c
763 .\}
764 .el \{\
765 .sp -1
766 .IP \(bu 2.3
767 .\}
768 .\" mysqladmin: force option
769 .\" force option: mysqladmin
770 \fB\-\-force\fR,
771 \fB\-f\fR
772 .sp
773 Do not ask for confirmation for the
774 drop \fIdb_name\fR
775 command\&. With multiple commands, continue even if an error occurs\&.
776 .RE
777 .sp
778 .RS 4
779 .ie n \{\
780 \h'-04'\(bu\h'+03'\c
781 .\}
782 .el \{\
783 .sp -1
784 .IP \(bu 2.3
785 .\}
786 .\" mysqladmin: host option
787 .\" host option: mysqladmin
788 \fB\-\-host=\fR\fB\fIhost_name\fR\fR,
789 \fB\-h \fR\fB\fIhost_name\fR\fR
790 .sp
791 Connect to the MySQL server on the given host\&.
792 .RE
793 .sp
794 .RS 4
795 .ie n \{\
796 \h'-04'\(bu\h'+03'\c
797 .\}
798 .el \{\
799 .sp -1
800 .IP \(bu 2.3
801 .\}
802 .\" mysqladmin: no-beep option
803 .\" no-beep option: mysqladmin
804 \fB\-\-no\-beep\fR,
805 \fB\-b\fR
806 .sp
807 Suppress the warning beep that is emitted by default for errors such as a failure to connect to the server\&. This option was added in MySQL 5\&.1\&.17\&.
808 .RE
809 .sp
810 .RS 4
811 .ie n \{\
812 \h'-04'\(bu\h'+03'\c
813 .\}
814 .el \{\
815 .sp -1
816 .IP \(bu 2.3
817 .\}
818 .\" mysqladmin: password option
819 .\" password option: mysqladmin
820 \fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
821 \fB\-p[\fR\fB\fIpassword\fR\fR\fB]\fR
822 .sp
823 The password to use when connecting to the server\&. If you use the short option form (\fB\-p\fR), you
824 \fIcannot\fR
825 have a space between the option and the password\&. If you omit the
826 \fIpassword\fR
827 value following the
828 \fB\-\-password\fR
829 or
830 \fB\-p\fR
831 option on the command line,
832 \fBmysqladmin\fR
833 prompts for one\&.
834 .sp
835 Specifying a password on the command line should be considered insecure\&. See
836 Section\ \&6.1.2.1, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.
837 .RE
838 .sp
839 .RS 4
840 .ie n \{\
841 \h'-04'\(bu\h'+03'\c
842 .\}
843 .el \{\
844 .sp -1
845 .IP \(bu 2.3
846 .\}
847 .\" mysqladmin: pipe option
848 .\" pipe option: mysqladmin
849 \fB\-\-pipe\fR,
850 \fB\-W\fR
851 .sp
852 On Windows, connect to the server using a named pipe\&. This option applies only if the server supports named\-pipe connections\&.
853 .RE
854 .sp
855 .RS 4
856 .ie n \{\
857 \h'-04'\(bu\h'+03'\c
858 .\}
859 .el \{\
860 .sp -1
861 .IP \(bu 2.3
862 .\}
863 .\" mysqladmin: port option
864 .\" port option: mysqladmin
865 \fB\-\-port=\fR\fB\fIport_num\fR\fR,
866 \fB\-P \fR\fB\fIport_num\fR\fR
867 .sp
868 The TCP/IP port number to use for the connection\&.
869 .RE
870 .sp
871 .RS 4
872 .ie n \{\
873 \h'-04'\(bu\h'+03'\c
874 .\}
875 .el \{\
876 .sp -1
877 .IP \(bu 2.3
878 .\}
879 .\" mysqladmin: protocol option
880 .\" protocol option: mysqladmin
881 \fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR
882 .sp
883 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\&. For details on the permissible values, see
884 Section\ \&4.2.2, \(lqConnecting to the MySQL Server\(rq\&.
885 .RE
886 .sp
887 .RS 4
888 .ie n \{\
889 \h'-04'\(bu\h'+03'\c
890 .\}
891 .el \{\
892 .sp -1
893 .IP \(bu 2.3
894 .\}
895 .\" mysqladmin: relative option
896 .\" relative option: mysqladmin
897 \fB\-\-relative\fR,
898 \fB\-r\fR
899 .sp
900 Show the difference between the current and previous values when used with the
901 \fB\-\-sleep\fR
902 option\&. This option works only with the
903 extended\-status
904 command\&.
905 .RE
906 .sp
907 .RS 4
908 .ie n \{\
909 \h'-04'\(bu\h'+03'\c
910 .\}
911 .el \{\
912 .sp -1
913 .IP \(bu 2.3
914 .\}
915 .\" mysqladmin: silent option
916 .\" silent option: mysqladmin
917 \fB\-\-silent\fR,
918 \fB\-s\fR
919 .sp
920 Exit silently if a connection to the server cannot be established\&.
921 .RE
922 .sp
923 .RS 4
924 .ie n \{\
925 \h'-04'\(bu\h'+03'\c
926 .\}
927 .el \{\
928 .sp -1
929 .IP \(bu 2.3
930 .\}
931 .\" mysqladmin: sleep option
932 .\" sleep option: mysqladmin
933 \fB\-\-sleep=\fR\fB\fIdelay\fR\fR,
934 \fB\-i \fR\fB\fIdelay\fR\fR
935 .sp
936 Execute commands repeatedly, sleeping for
937 \fIdelay\fR
938 seconds in between\&. The
939 \fB\-\-count\fR
940 option determines the number of iterations\&. If
941 \fB\-\-count\fR
942 is not given,
943 \fBmysqladmin\fR
944 executes commands indefinitely until interrupted\&.
945 .RE
946 .sp
947 .RS 4
948 .ie n \{\
949 \h'-04'\(bu\h'+03'\c
950 .\}
951 .el \{\
952 .sp -1
953 .IP \(bu 2.3
954 .\}
955 .\" mysqladmin: socket option
956 .\" socket option: mysqladmin
957 \fB\-\-socket=\fR\fB\fIpath\fR\fR,
958 \fB\-S \fR\fB\fIpath\fR\fR
959 .sp
960 For connections to
961 localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use\&.
962 .RE
963 .sp
964 .RS 4
965 .ie n \{\
966 \h'-04'\(bu\h'+03'\c
967 .\}
968 .el \{\
969 .sp -1
970 .IP \(bu 2.3
971 .\}
972 .\" mysqladmin: SSL options
973 .\" SSL options: mysqladmin
974 \fB\-\-ssl*\fR
975 .sp
976 Options that begin with
977 \fB\-\-ssl\fR
978 specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See
979 Section\ \&6.3.6.4, \(lqSSL Command Options\(rq\&.
980 .RE
981 .sp
982 .RS 4
983 .ie n \{\
984 \h'-04'\(bu\h'+03'\c
985 .\}
986 .el \{\
987 .sp -1
988 .IP \(bu 2.3
989 .\}
990 .\" mysqladmin: user option
991 .\" user option: mysqladmin
992 \fB\-\-user=\fR\fB\fIuser_name\fR\fR,
993 \fB\-u \fR\fB\fIuser_name\fR\fR
994 .sp
995 The MySQL user name to use when connecting to the server\&.
996 .RE
997 .sp
998 .RS 4
999 .ie n \{\
1000 \h'-04'\(bu\h'+03'\c
1001 .\}
1002 .el \{\
1003 .sp -1
1004 .IP \(bu 2.3
1005 .\}
1006 .\" mysqladmin: verbose option
1007 .\" verbose option: mysqladmin
1008 \fB\-\-verbose\fR,
1009 \fB\-v\fR
1010 .sp
1011 Verbose mode\&. Print more information about what the program does\&.
1012 .RE
1013 .sp
1014 .RS 4
1015 .ie n \{\
1016 \h'-04'\(bu\h'+03'\c
1017 .\}
1018 .el \{\
1019 .sp -1
1020 .IP \(bu 2.3
1021 .\}
1022 .\" mysqladmin: version option
1023 .\" version option: mysqladmin
1024 \fB\-\-version\fR,
1025 \fB\-V\fR
1026 .sp
1027 Display version information and exit\&.
1028 .RE
1029 .sp
1030 .RS 4
1031 .ie n \{\
1032 \h'-04'\(bu\h'+03'\c
1033 .\}
1034 .el \{\
1035 .sp -1
1036 .IP \(bu 2.3
1037 .\}
1038 .\" mysqladmin: vertical option
1039 .\" vertical option: mysqladmin
1040 \fB\-\-vertical\fR,
1041 \fB\-E\fR
1042 .sp
1043 Print output vertically\&. This is similar to
1044 \fB\-\-relative\fR, but prints output vertically\&.
1045 .RE
1046 .sp
1047 .RS 4
1048 .ie n \{\
1049 \h'-04'\(bu\h'+03'\c
1050 .\}
1051 .el \{\
1052 .sp -1
1053 .IP \(bu 2.3
1054 .\}
1055 .\" mysqladmin: wait option
1056 .\" wait option: mysqladmin
1057 \fB\-\-wait[=\fR\fB\fIcount\fR\fR\fB]\fR,
1058 \fB\-w[\fR\fB\fIcount\fR\fR\fB]\fR
1059 .sp
1060 If the connection cannot be established, wait and retry instead of aborting\&. If a
1061 \fIcount\fR
1062 value is given, it indicates the number of times to retry\&. The default is one time\&.
1063 .RE
1064 .PP
1065 You can also set the following variables by using
1066 \fB\-\-\fR\fB\fIvar_name\fR\fR\fB=\fR\fB\fIvalue\fR\fR
1067 The
1068 \fB\-\-set\-variable\fR
1069 format is deprecated and is removed in MySQL 5\&.5\&.
1070 .sp
1071 .RS 4
1072 .ie n \{\
1073 \h'-04'\(bu\h'+03'\c
1074 .\}
1075 .el \{\
1076 .sp -1
1077 .IP \(bu 2.3
1078 .\}
1079 .\" connect_timeout variable
1080 .\" timeout: connect_timeout variable
1081 connect_timeout
1082 .sp
1083 The maximum number of seconds before connection timeout\&. The default value is 43200 (12 hours)\&.
1084 .RE
1085 .sp
1086 .RS 4
1087 .ie n \{\
1088 \h'-04'\(bu\h'+03'\c
1089 .\}
1090 .el \{\
1091 .sp -1
1092 .IP \(bu 2.3
1093 .\}
1094 .\" shutdown_timeout variable
1095 .\" timeout: shutdown_timeout variable
1096 shutdown_timeout
1097 .sp
1098 The maximum number of seconds to wait for server shutdown\&. The default value is 3600 (1 hour)\&.
1099 .RE
1100 .SH "COPYRIGHT"
1101 .br
1102 .PP
1103 Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
1104 .PP
1105 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.
1106 .PP
1107 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.
1108 .PP
1109 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-1301 USA or see http://www.gnu.org/licenses/.
1110 .sp
1111 .SH "SEE ALSO"
1112 For more information, please refer to the MySQL Reference Manual,
1113 which may already be installed locally and which is also available
1114 online at http://dev.mysql.com/doc/.
1115 .SH AUTHOR
1116 Oracle Corporation (http://dev.mysql.com/).