Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
mysqld starts, then switches to run as the Unix user user_name before accepting any connections. On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
For more information about character_set_results, see Section 12.4, “Connection Character Sets and Collations”. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
(See Section 12.4, “Connection Character Sets and Collations”.) Alternatively, a client program can perform the conversion after receiving the result from the server. Metadata is “the data about the data.” Anything that describes the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
The following items summarize other potential incompatibilities: SET NAMES 'utf8mb4' causes use of the 4-byte character set for connection character sets. This section describes issues that you may face when converting character data between the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
Connecting to the donor MySQL server instance through MySQL Router is not supported. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
If the read_only system variable is enabled, explicitly starting a transaction with START TRANSACTION READ WRITE requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). See Chapter 31, Connectors and APIs, or the documentation ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
See Obtaining Auto-Increment Values, and the description for the FLAG_AUTO_IS_NULL option at Connector/ODBC Connection Parameters. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less ...