Search Results
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...If ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-security-standard-rules.html
There are two potential security issues with supporting the LOCAL version of LOAD DATA statements: The transfer of the file from the client host to the server host is initiated by the MySQL server. In a Web environment where the clients are ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line. For example, for MySQL ...To install MySQL using the package installer: Download the disk image (.dmg) file (the community version is available here) that contains the MySQL package ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
If you are shutting down the replica server, you can edit the [mysqld] section of the configuration file to specify a unique server ID. Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up ...If the replica's server ID is not already set, or the current value conflicts with the value that you have chosen for the source or another replica, you must change ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
SET can also be used to persist certain system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. SET counter = counter + increment; END WHILE; END; System Variable Assignment The MySQL ...| @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients: User-defined ...variable: { ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of ...For example, if a member is running MySQL 8.4.6 then that is the version of the Group Replication ...For example, if a feature has been deprecated between major versions, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
When a read/write transaction is ready to commit at the originating server, the server atomically broadcasts the write values (the rows that were changed) and the corresponding write set (the unique identifiers of the rows that were updated). Group ...The communication layer provides a set of guarantees such as atomic message and total order message ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
For example, put these lines in your server my.cnf file: [mysqld] persist_only_admin_x509_subject="subject-value" The format of the Subject value is the same as used for CREATE USER ... You must perform this step directly on the MySQL server host ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”). A ...The keyring service handles the creation, retrieval, and deletion of the binary log encryption ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...This server ID is used to identify individual servers within the replication topology, and must be a positive integer between 1 and ...