Search Results
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
When GTID_ONLY = 1 is set, the replica uses replica_parallel_workers=1 if that system variable is set to zero for the server, so it is always technically a multi-threaded applier. You can avoid this in such cases by making sure that the value of the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...The ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...The ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
Connection Character Set and Collation System Variables Impermissible Client Character Sets Client Program Connection Character Set Configuration SQL Statements for Connection Character Set Configuration Connection Character Set Error Handling ... A ...The client sends SQL statements, such as queries, over the session ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
You can check the status of the MySQL server with the following command: $> systemctl status mysql If the operating system is systemd enabled, standard systemctl (or alternatively, service with the arguments reversed) commands such as stop, start, ...First, add the MySQL APT repository to your system's software repository ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...The ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...By default, a user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The gtid_next System Variable By default, for new transactions committed in user sessions, the server automatically generates and assigns a new GTID. You can change this behavior by setting the session value of the gtid_next system variable: When ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file must be located in the directory named by the plugin_dir system variable. Table 8.26 ...MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
The server looks for plugin library files in the directory named by the plugin_dir system variable. Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL ...It ...