~james-page/ubuntu/precise/mysql-5.5/misc-fixes

capabilities)\&. It supports interactive and noninteractive use\&. When used interactively, query results are presented in an ASCII\-table format\&. When used noninteractively (for example, as a filter), the result is presented in tab\-separated format\&. The output format can be changed using command options\&.

is a simple SQL shell with input line editing capabilities\&. It supports interactive and noninteractive use\&. When used interactively, query results are presented in an ASCII\-table format\&. When used noninteractively (for example, as a filter), the result is presented in tab\-separated format\&. The output format can be changed using command options\&.

.PP

If you have problems due to insufficient memory for large result sets, use the

\fB\-\-quick\fR

230

228

\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR

231

229

.sp

232

230

The directory where character sets are installed\&. See

233

Section\ \&9.5, \(lqCharacter Set Configuration\(rq\&.

231

Section\ \&10.5, \(lqCharacter Set Configuration\(rq\&.

234

232

.RE

235

233

.sp

236

234

.RS 4

376

374

\fB\-\-default\-auth=\fR\fB\fIplugin\fR\fR

377

375

.sp

378

376

The client\-side authentication plugin to use\&. See

379

Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.

377

Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.

380

378

.sp

381

379

This option was added in MySQL 5\&.5\&.7\&.

382

380

.RE

406

404

character set by default\&. You can usually fix such issues by using this option to force the client to use the system character set instead\&.

407

405

.sp

408

406

See

409

Section\ \&9.5, \(lqCharacter Set Configuration\(rq, for more information\&.

407

Section\ \&10.5, \(lqCharacter Set Configuration\(rq, for more information\&.

410

408

.RE

411

409

.sp

412

410

.RS 4

541

539

.sp -1

542

540

.IP \(bu 2.3

543

541

.\}

542

.\" mysql: init-command option

543

.\" init-command option: mysql

544

\fB\-\-init\-command=str\fR

545

.sp

546

SQL statement to execute after connecting to the server\&. If auto\-reconnect is enabled, the statement is executed again after reconnection occurs\&.

547

.RE

548

.sp

549

.RS 4

550

.ie n \{\

551

\h'-04'\(bu\h'+03'\c

552

.\}

553

.el \{\

554

.sp -1

555

.IP \(bu 2.3

556

.\}

544

557

.\" mysql: line-numbers option

545

558

.\" line-numbers option: mysql

546

559

\fB\-\-line\-numbers\fR

846

859

prompts for one\&.

847

860

.sp

848

861

Specifying a password on the command line should be considered insecure\&. See

849

Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.

862

Section\ \&6.1.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&. You can use an option file to avoid giving the password on the command line\&.

850

863

.RE

851

864

.sp

852

865

.RS 4

882

895

option is used to specify an authentication plugin but

883

896

\fBmysql\fR

884

897

does not find it\&. See

885

Section\ \&5.5.6, \(lqPluggable Authentication\(rq\&.

898

Section\ \&6.3.6, \(lqPluggable Authentication\(rq\&.

886

899

.sp

887

900

This option was added in MySQL 5\&.5\&.7\&.

888

901

.RE

1182

1195

Options that begin with

1183

1196

\fB\-\-ssl\fR

1184

1197

specify whether to connect to the server using SSL and indicate where to find SSL keys and certificates\&. See

1185

Section\ \&5.5.8.3, \(lqSSL Command Options\(rq\&.

1198

Section\ \&6.3.8.3, \(lqSSL Command Options\(rq\&.

1186

1199

.RE

1187

1200

.sp

1188

1201

.RS 4

1640

1653

\(lq;\(rq, instances of that character are sent to the server without interpretation\&. However, the server itself still interprets

1641

1654

\(lq;\(rq

1642

1655

as a statement delimiter and processes statements accordingly\&. This behavior on the server side comes into play for multiple\-statement execution (see

1643

Section\ \&21.9.13, \(lqC API Support for Multiple Statement Execution\(rq), and for parsing the body of stored procedures and functions, triggers, and events (see

1644

Section\ \&18.1, \(lqDefining Stored Programs\(rq)\&.

1656

Section\ \&22.9.13, \(lqC API Support for Multiple Statement Execution\(rq), and for parsing the body of stored procedures and functions, triggers, and events (see

1657

Section\ \&19.1, \(lqDefining Stored Programs\(rq)\&.

1645

1658

.RE

1646

1659

.sp

1647

1660

.RS 4

2520

2533

The

2521

2534

\&.mysql_history

2522

2535

should be protected with a restrictive access mode because sensitive information might be written to it, such as the text of SQL statements that contain passwords\&. See

2523

Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.

2536

Section\ \&6.1.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.

2524

2537

.PP

2525

2538

It is possible to suppress logging of statements to the history file by using the

2526

2539

\fB\-\-batch\fR

2590

2603

uses it as a search string to access server\-side help from the contents of the MySQL Reference Manual\&. The proper operation of this command requires that the help tables in the

2591

2604

mysql

2592

2605

database be initialized with help topic information (see

2593

Section\ \&5.1.8, \(lqServer-Side Help\(rq)\&.

2606

Section\ \&5.1.9, \(lqServer-Side Help\(rq)\&.

2594

2607

.PP

2595

2608

If there is no match for the search string, the search fails:

2596

2609

.sp

2979

2992

option\&.

2980

2993

.PP

2981

2994

For more information about auto\-reconnect and its effect on state information when a reconnection occurs, see

2982

Section\ \&21.9.12, \(lqControlling Automatic Reconnection Behavior\(rq\&.

2995

Section\ \&22.9.12, \(lqControlling Automatic Reconnection Behavior\(rq\&.

2983

2996

.SH "COPYRIGHT"

2984

2997

.br

2985

2998

.PP

Older »