Search Results
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. (Direct modification of grant tables is discouraged, anyway.) For the general query log, password rewriting can be ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins.html
Several header files contain information relevant to authentication plugins: plugin.h: Defines the MYSQL_AUTHENTICATION_PLUGIN server plugin type. This includes the type-specific descriptor for server-side authentication plugins and the ... MySQL ...
https://dev.mysql.com/doc/internals/en/a-mysql-client-logs-in.html
which responds with a handshake packet which contains the version, some flags and a password challenge.: client -> server 3a 00 00 01 05 a6 03 00 00 00 00 01 08 00 00 00 :............... The client answers with username, some flags and the response ...00 00 27 75 3e 6f 38 66 79 4e 00 ff f7 08 02 00 ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
If super_read_only is subsequently disabled after being enabled, the server automatically restarts the Event Scheduler as needed. Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding ...The global event_scheduler system variable determines whether the Event Scheduler is enabled and running on the ... Events are ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
With some clients, you may also get a Lost connection to MySQL server during query error if the communication packet is too large. A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, ...Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
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 ...The statement supports these actions: ALTER INSTANCE {ENABLE | DISABLE} INNODB REDO_LOG This action enables or disables InnoDB redo ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
Using MySQL Server’s own connection security in place of Group Replication’s implementation. Using the MySQL protocol means that standard methods of user authentication can be used for granting (or revoking) access to the group in place of the ... MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. This section explains how to create a replication group with three MySQL Server instances on one ...