Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel. Details of the error and the last applied transaction are recorded in the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ... You ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
To start mysqld as a different Unix user, add a user option that specifies the user name in the [mysqld] group of the my.cnf option file where you specify server options. When you connect to a MySQL server, you should use a password. All other ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If the SQL thread is in the middle of a transaction at this point, the server waits until the current replication event group (if any) has finished executing, or until the user issues a KILL QUERY or KILL CONNECTION statement. The server shutdown ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
For Group Replication, the group_replication_recovery_get_public_key system variable serves the same purpose. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where those function descriptions occur. Spatial values, or geometries, have the properties described in ...