Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
To relax the preceding conditions on function creation (that you must have the SUPER privilege and that a function must be declared deterministic or to not modify data), set the global log_bin_trust_function_creators system variable to 1. By ... The ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-using-ssl.html
The system works through two Java keystore files: one file contains the certificate information for the server (truststore in the examples below), and another contains the keys and certificate for the client (keystore in the examples below). All ...
https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html
MySQL Connector/NET 9.x series is a continuation of Connector/NET 8.x series, but now named to synchronize with the (latest) MySQL server version it supports. For general guidance about configuring the server and clients for secure connections, see ...This version continues the functionality of the previous Connector/NET release series, including support for X Protocol ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
row *************************** user: root plugin: auth_socket To verify that the auth_socket plugin works, log in to the MySQL server host as the operating system root user and then connect to the MySQL server locally as the MySQL root user. When ...This deployment uses the caching_sha2_password and auth_socket authentication plugins for user ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html
The system works through two Java keystore files: one file contains the certificate information for the server (truststore in the examples below), and another contains the keys and certificate for the client (keystore in the examples below). All ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client error message includes an error code, SQLSTATE value, and message ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
This is what I'd call a "distinguishing characteristic" because in all the major DBMSs (like IBM DB2, Microsoft SQL Server, and Oracle), the main or default or classic structure is the heap-and-index. Compare Oracle's Index Organized Tables, and ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Message Structure Messages have a: 4 byte length (little endian) 1 byte message type a message_payload of length .length - 1 Mysqlx.Message Container of all messages that are exchanged between client and server. A message sequence either: finishes ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
Protocol::Handshake Initial Handshake Packet When the client connects to the server the server sends a handshake packet to the client. Depending on the server version and configuration options different variants of the initial packet are sent. To ...Since 3.21.0 the Protocol::HandshakeV10 is sent, while it was still supporting Protocol::HandshakeV9 with a compile time ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
To run the server with the LOCK_ORDER tool enabled, enable the lock_order system variable at server startup. lock_order_dependencies Command-Line Format --lock-order-dependencies=file_name System Variable lock_order_dependencies Scope Global Dynamic ...Several other system variables for LOCK_ORDER configuration are available as ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related ...