PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/security-guidelines.html
This information is accessible to everyone who has the time and ability to intercept it and use it for their own purposes. Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
This helps MySQL free the table locks early and helps in cases where it takes a long time to send the result set to the client. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”. After completing the installation process, you can edit the default option file ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration-validation.html
--validate-config can be used any time, but is particularly useful after an upgrade, to check whether any options previously used with the older server are considered by the upgraded server to be deprecated or obsolete. MySQL supports a ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration.html
To use the option every time the server runs, put it in an option file. The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and ...
https://dev.mysql.com/doc/refman/9.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/9.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/9.7/en/set-default-role.html
role [, role ] ...: Set the default to the named roles, which must exist and be granted to the account at the time SET DEFAULT ROLE is executed. SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} TO user [, user ] ... For each user named ...
https://dev.mysql.com/doc/refman/9.7/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/9.7/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...