Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the recovery users must be properly set up, as they are also ... State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
To create the replication user for distributed recovery, follow these steps: Start the MySQL server instance, then connect a client to it. If you choose to provide the user credentials using a CHANGE REPLICATION SOURCE TO statement, issue the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
$> cd BASEDIR/data/#innodb_temp $> ls temp_10.ibt temp_2.ibt temp_4.ibt temp_6.ibt temp_8.ibt temp_1.ibt temp_3.ibt temp_5.ibt temp_7.ibt temp_9.ibt In statement based replication (SBR) mode, temporary tables created on a replica reside in a single ...Session temporary tablespaces are allocated to a session from a pool of temporary tablespaces on the first request to create an on-disk temporary ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-plugin-installation.html
Plugins installed using INSTALL PLUGIN are registered in the mysql.plugin system table and loaded automatically for subsequent server restarts. A keyring component must be enabled on the MySQL Server instance if you need to support secure storage ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
keyring_hashicorp_ca_path Command-Line Format --keyring-hashicorp-ca-path=file_name System Variable keyring_hashicorp_ca_path Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string The absolute path name of a ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-prefpane.html
Figure 2.8 MySQL Preference Pane: Location The MySQL preference pane is installed with the same DMG file that installs MySQL Server. Typically it is installed with MySQL Server but it can be installed by itself too. To install the MySQL preference ... The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
Note Make sure that the limit MAX_QUERIES_PER_HOUR is not set for the user mysqlbackup uses to access the server, or backup operations might fail unexpectedly. The mysqlbackup command connects to the MySQL server using the credentials supplied with ...CREATE, INSERT, DROP, and UPDATE on the tables mysql.backup_progress and mysql.backup_history, and also SELECT and ALTER on ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-setup.html
Create a user for whom the server will use the auth_simple plugin for authentication: mysql> CREATE USER 'x'@'localhost' -> IDENTIFIED WITH auth_simple; Use a client program to connect to the server as user x. Invoke the client program each way to ...For example, to load the plugin at server startup, use a --plugin-load=auth_simple.so option, adjusting the .so suffix for your platform as ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-installation-source-code.html
MySQL Router is part of the MySQL Server source code tree; compiling MySQL Server also compiles MySQL Router. Note MySQL Router source code can be found in the router directory inside the MySQL Server source code repository. Get Source Code To ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean-cmdline.html
--mysql-studio-port=port#: Replace the default port number (8000) with another one for MySQL Studio's server to listen for connections. --mysql-shell-gui-port=port#: Replace the default port number (8000) with another one for MySQL Shell GUI web ...