Search Results
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-9.html
X Protocol connection example: "server=/path/to/socket;protocol=unix;user=root;password=mypass;ssl-mode=none" Classic MySQL protocol connection example: "server=/path/to/socket;protocol=unix;user=root;password=mypass" (WL #10201, WL #10613) ...For ...
https://dev.mysql.com/doc/refman/8.4/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. Identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
For MIXED mode, statement-based logging is used by default but replication switches automatically to row-based logging under certain conditions, such as unsafe statements. This means that you should not chain two servers together in a two-way ... In ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If you are able to dump your tables with an innodb_force_recovery value of 3 or less, then you are relatively safe that only some data on corrupt individual pages is lost. As a safety measure, InnoDB prevents INSERT, UPDATE, or DELETE operations ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows-service.html
The installation also configures the agent to start automatically whenever Windows starts, and to shut down safely whenever Windows shuts down. Important Installation of the MySQL Cluster Manager agent as a service is recommended. However, you ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #117579, Bug #37639722) The ResultSet.HOLD_CURSORS_OVER_COMMIT mode is now consistently supported across connections, statements, and result sets, which was not the case before this fix. This patch corrects the unexpected behavior, so that a ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ...Installing SHA-2 Pluggable Authentication The caching_sha2_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading ... MySQL provides two authentication plugins that implement ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are ...
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER ...This ...