Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-2-0.html
Version 8.2.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 8.2.0 supersedes 8.1 and is recommended for use on production systems. This release can be used against MySQL Server version 5.7 and later. To prevent the exception, a new ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-2-0.html
Version 9.2.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.2.0 supersedes 9.1 and is recommended for use on production systems. This release can be used against MySQL Server version 8.0 and later. It supports the Java Database ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-3-0.html
Version 9.3.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.3.0 supersedes 9.2 and is recommended for use on production systems. This release can be used against MySQL Server version 8.0 and later. (Bug #20802830) When using a ...It ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-tls-cache.html
MySQL Router uses the following caches: Client TLS session cache: Caches TLS session from the client to MySQL Router. Server TLS session cache: Caches TLS sessions from the MySQL Router to the server. TLS sessions from client to router and router ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
Caching SHA-2 Authentication In MySQL 8.0, caching_sha2_password is the default authentication plugin rather than mysql_native_password, which was the default in MySQL 5.7. When a client connects to the MySQL server, the server uses the user name ...The server authenticates the client, determining from the account row which authentication plugin applies to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query performance. MySQL HeatWave supports two string column encoding types: variable-length and dictionary. MySQL HeatWave applies ...For more information about string column encoding, see Section 5.8.1.4, “Encoding String ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. Account manipulation includes creating and dropping accounts, granting and revoking privileges, changing account authentication characteristics such as ...The SYSTEM_USER privilege has an effect on the accounts to which a given user can apply its other privileges, as well as whether the user is protected from other accounts: A system user can modify both system and regular ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature.html
The keyID for MySQL 8.0.44 packages and higher, MySQL 8.4.7 and higher, and MySQL 9.5.0 and higher is B7B3B788A8D3785C. After obtaining this key, you should compare it with the key following value before using it verify MySQL packages. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
For more information about indexes, see Section 10.3.1, “How MySQL Uses Indexes”. If a table contains no primary key, InnoDB automatically promotes the first UNIQUE NOT NULL index to the primary key. MySQL cannot index LONGTEXT columns specified ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...