MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 271 to 280 of 328 total results

6.4.2 mysql_secure_installation — Improve MySQL Installation Security

https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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.4, “Client-Side Cleartext Pluggable Authentication”.) ...

6.6.9.2 mysqlbinlog Row Event Display

https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysqlcheck.html

6.5.6 mysqlpump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

6.5.7 mysqlshow — Display Database, Table, and Column Information

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

6.5.8 mysqlslap — A Load Emulation Client

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

7.1.9.4 Nonpersistible and Persist-Restricted System Variables

https://dev.mysql.com/doc/refman/8.0/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 ...

11.1.7 NULL Values

https://dev.mysql.com/doc/refman/8.0/en/null-values.html

For text file import or export operations performed with LOAD DATA or SELECT ... The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from values such as 0 for numeric types or the ...

Displaying 271 to 280 of 328 total results