PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as my.ini. Advanced configuration options are related to the following MySQL log files: Error Log General Log Slow Query Log Bin Log Note The binary ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer.html
Note MySQL Installer cannot install both Community and Commercial releases of MySQL server on the same host. Note The connectors were bundled before MySQL Installer 1.6.7 (MySQL Server 8.0.34), and MySQL Installer could install each connector up to ... MySQL Installer is a standalone application designed to ease the complexity of installing and configuring MySQL products that run on Microsoft ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
(See Bug #42849.) Note It is also possible in MySQL 8.0 to use UNIX_TIMESTAMP(timestamp_column) as a partitioning expression for tables that are partitioned by LIST. A table that is partitioned by range is partitioned in such a way that each ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Note Although it is possible to “reset” an expired password by setting it to its current value, it is preferable, as a matter of good policy, to choose a different password. Note The empty password does not count in the password history and is ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
It is important to note that the replica sets gtid_next in a session context. Note that after you set gtid_next to a specific GTID, and the transaction has been committed or rolled back, an explicit SET @@SESSION.gtid_next statement must be issued ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
Note that although you can change the server ID dynamically to a nonzero value, doing so does not enable replication to start immediately. Note The presence of the server_uuid system variable does not change the requirement for setting a unique ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Note By default, if GTIDs are in use on the source (gtid_mode=ON), mysqldump includes the GTIDs from the gtid_executed set on the source in the dump output to add them to the gtid_purged set on the replica. If the source database contains existing ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
Note In the name sha256_password, “sha256” refers to the 256-bit digest length the plugin uses for encryption. Note Unlike caching_sha2_password, the sha256_password plugin does not treat shared-memory connections as secure, even though ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Note When the replication SQL thread receives an error, it reports the error first, then stops the SQL thread. Note The Ignored_server_ids value in the slave_master_info table also shows the server IDs to be ignored, but as a space-delimited list, ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...