PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
TLS is sometimes referred to as SSL (Secure Sockets Layer) but MySQL does not actually use the SSL protocol for encrypted connections because its encryption is weak (see Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”). By ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, which is available in MySQL 8.0.17 and later, this replication user is also used as the clone user on the donor, and requires the ...
https://dev.mysql.com/doc/refman/8.0/en/preface.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.46. Differences between minor versions of MySQL 8.0 are noted in the present text with reference to release numbers (8.0.x). This manual is not intended ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
Beginning with MySQL 8.0.30, all the forms shown for REVOKE support an IF EXISTS option as well as an IGNORE UNKNOWN USER option. To use these REVOKE statements, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. For geographic SRS geometry arguments, if any argument has a longitude or latitude that is out of ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart. Password Validation Plugin Options Note In MySQL 8.0, the validate_password plugin was reimplemented as the ...
https://dev.mysql.com/doc/refman/8.0/en/compiling-for-debugging.html
If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL with the -DWITH_DEBUG=1 option. You can check whether MySQL was compiled with debugging by doing: mysqld --help. If mysqld stops crashing ...If the --debug flag is listed with the options then you have debugging ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.0 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use ...