Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave Console. Note:Click on the name of a system varuable in Table 19-7 to see its description in the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
For example, to use the 4-byte UTF-8 character set with Connector/J, configure the MySQL server with character_set_server=utf8mb4, and leave characterEncoding and connectionCollation out of the Connector/J connection string. MySQL to Java Encoding ...Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and connectionCollation are not ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication deployments. If you now had an additional instance of MySQL running on port 3309, you ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
This article will focus on Java-oriented access to MySQL databases with Spring 2.0. For the examples in this section the MySQL world sample database will be used. The first task is to set up a MySQL data source through Spring. For example, to ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 8.4 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is ...
https://dev.mysql.com/doc/refman/8.4/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-set.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The binary ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
For example, comparisons with SCHEMATA.SCHEMA_NAME match 'information_schema' or 'INFORMATION_SCHEMA' regardless of platform: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'information_schema'; +--------------------+ ... String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning operation. The user you select to perform the cloning operation can be any MySQL user with the BACKUP_ADMIN privilege on *.*. The ...The ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Your identity is based on two pieces of ...A ...