MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 281 to 290 of 353 total results

https://dev.mysql.com/doc/refman/9.7/en/mysql-commands.html

For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. mysql sends each SQL statement that you issue ...

6.4.2 mysql_secure_installation — Improve MySQL Installation Security

https://dev.mysql.com/doc/refman/9.7/en/mysql-secure-installation.html

--protocol={TCP|SOCKET|PIPE|MEMORY} Command-Line Format --protocol=type Type String Default Value [see text] Valid Values TCPSOCKETPIPEMEMORY The transport protocol to use for connecting to the server. This program enables you to improve the ...

6.5.1.6 mysql Client Tips

https://dev.mysql.com/doc/refman/9.7/en/mysql-tips.html

For example, longer text values that include newlines often are much easier to read with vertical output: mysql> SELECT * FROM mails WHERE LENGTH(txt) < 300 LIMIT 300,1\G *************************** 1. This section provides information about ...

6.5.2 mysqladmin — A MySQL Server Administration Program

https://dev.mysql.com/doc/refman/9.7/en/mysqladmin.html

--enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Type Boolean Default Value FALSE Enable the mysql_clear_password cleartext authentication plugin. (See Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”.) ...

6.6.9.2 mysqlbinlog Row Event Display

https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html

Character set information is not available in the binary log, which affects string column display: There is no distinction made between corresponding binary and nonbinary string types (BINARY and CHAR, VARBINARY and VARCHAR, BLOB and TEXT). The ...

6.5.3 mysqlcheck — A Table Maintenance Program

https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html

6.5.8.1 Options

https://dev.mysql.com/doc/refman/9.7/en/mysqldm-options.html

6.5.6 mysqlshow — Display Database, Table, and Column Information

https://dev.mysql.com/doc/refman/9.7/en/mysqlshow.html

6.5.7 mysqlslap — A Load Emulation Client

https://dev.mysql.com/doc/refman/9.7/en/mysqlslap.html

7.1.9.4 Nonpersistible and Persist-Restricted System Variables

https://dev.mysql.com/doc/refman/9.7/en/nonpersistible-system-variables.html

SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). However, not all system variables can be ...

Displaying 281 to 290 of 353 total results