PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html
This section describes how to select these protocols, and how they are similar and different. Transport Protocol Selection Transport Support for Local and Remote Connections Interpretation of localhost Encryption and Security Characteristics ... For ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
A subsequent SELECT from the OPTIMIZER_TRACE table returns the first limit traces of the offset oldest stored traces (if offset >= 0), or the first limit traces of the -offset newest stored traces (if offset < 0). For example: SET ...Thus, if a ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
You can determine the default storage engine on a MySQL Server instance by issuing the following statement: mysql> SELECT @@default_storage_engine; +--------------------------+ | @@default_storage_engine | +--------------------------+ | InnoDB | ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This plugin exposes a set of system variables that enable you to configure password policy. The ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. Next select the ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
To identify such accounts, use this query: SELECT User, Host, Password FROM mysql.user WHERE (plugin = '' AND LENGTH(Password) = 16) OR plugin = 'mysql_old_password'; The following discussion provides two methods for updating that set of accounts.
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been ...