Search Results
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
The MySQL Installer Options icon () includes the following tabs: General: Enables or disables the Offline mode option. When running MySQL Installer in offline mode, you see a warning together with a Disable quick action on the dashboard. To enable ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...This advice applies whether you are using statement-based or row-based ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
The following modes are permissible: DISABLED PREFERRED REQUIRED VERIFY_CA VERIFY_IDENTITY Important VERIFY_CA and VERIFY_IDENTITY are better choices than the default PREFERRED, because they help prevent man-in-the-middle attacks. This option ...The ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
To keep this file safe, use a restrictive access mode, the same way as described earlier for the .my.cnf file. In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/upgrade-mysql-replicaset-from-8027to8028.html
Set an upgraded secondary instance to be the primary instance: <ReplicaSet>.setPrimaryInstance('<host>:<port>') Use the <ReplicaSet>.setPrimaryInstance() operation to safely perform a change of the primary of a ReplicaSet to another instance. Use ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Strict mode: Specify whether the mapping takes place during data mapping in strict mode (Enabled) or non-strict mode (Disabled). This parameter overrides the Strict mode setting that you specify in the File parsing settings for CSV files. The ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-30.html
The value is set by libmysqlclient if not set, and has no effect with ssl-mode=DISABLED. Also improved BUNDLE_DEPENDENCIES and MAINTAINER_MODE CMake options to check if the required bundled plugins and 3rd party libraries are present. The option ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
To disable use of statistics and always use index dives regardless of N, set eq_range_index_dive_limit to 0. For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...