Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the account row from the mysql.user table. If the names do not match, the plugin also checks whether the socket user name ...The server authenticates the client, determining from the account row which authentication plugin applies to the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
The examples shown here assume use of the latin1 character set and latin1_swedish_ci collation in particular contexts as an alternative to the defaults of utf8mb4 and utf8mb4_0900_ai_ci. To create a database such that its tables use a given default ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. Command Options for Connection ...These options can be given on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state transfer for distributed recovery. If an alternative port number is specified by the report_port system ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON REPLICA to prevent them from running ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-requirements.html
In such cases data is not automatically distributed to the new nodes, and, following the restore, you must redistribute the data manually by issuing an ALTER ONLINE TABLE ... REORGANIZE PARTITION statement in the mysql client for each NDB table in ... This section provides information about basic requirements for performing backup and restore operations using MySQL Cluster ...
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT SELECT, ALTER ON database_name.* TO 'user_name'@'%'; You need the following privileges to access the database that stores the output tables of generated predictions and explanations. mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
By extracting a session ticket from an established session and then submitting that ticket while establishing the next connection, the overall cost is reduced if the session can be reused. The following table shows the system variables that define ... MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
Select each schema you want to export, optionally choose specific schema objects/tables from each schema, and generate the export. Configuration options include exporting to a project folder or self-contained SQL file, optionally dump stored ... Use ...
https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html
Table 3.1 Default Local Configuration Base File Path Operating System File Path Windows %AppData%\MySQL\Workbench\ macOS ~username/Library/Application Support/MySQL/Workbench/ Linux ~username/.mysql/workbench/ The next table provides a brief ...