PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
An import dialog is displayed; choose Okay, and this certificate should now be listed under the Imported Certificates tab. The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. That ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
The secure_file_priv system variable limits import and export operations to a specific directory. For example: bin/mysqld --initialize --user=mysql For important information about the command, especially regarding command options you might use, see ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
This is important when setting up Group Replication as it ensures you can configure the server before manually starting the plugin. Important This address must be different to the hostname and port used for SQL and it must not be used for client ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
Important Once encrypted tablespaces are created in a MySQL instance, the keyring plugin that was loaded when creating the encrypted tablespace must continue to be loaded at startup using the early-plugin-load option. This file together with the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Important Whether logging of complete rows or of updated columns only is done is decided when the MySQL server is started, and cannot be changed online; you must either restart mysqld, or start a new mysqld instance with different logging options.
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html
To eliminate this requirement, a snapshot of the data set, the binary logs and the global transaction information the source server contains can be imported to the new replica. Then use the mysql client to import the dump file on the target server.
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To determine the current global or session sql_mode setting, select its value: SELECT @@GLOBAL.sql_mode; SELECT @@SESSION.sql_mode; Important SQL mode and user-defined partitioning. The Most Important SQL Modes The most important sql_mode values are ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Because backup speed and compactness are important for busy, important databases, the MySQL Enterprise Backup product performs ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
Important To connect to a MySQL 8.0 or higher server using an account that authenticates with the caching_sha2_password plugin, you must use either a secure connection or an unencrypted connection that supports password exchange using an RSA key ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Upgrading a MySQL Server Container Important Before performing any upgrade to MySQL, follow carefully the instructions in Section 2.10, “Upgrading MySQL”. Among other instructions discussed there, it is especially important to back up your ...