Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
Create any databases on the replica cluster that are present on the source cluster and that are to be replicated. Important A CREATE DATABASE (or CREATE SCHEMA) statement corresponding to each database to be replicated must be executed on each SQL ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ...When setting up circular replication, it is possible to initialize the replica cluster by using the management client START BACKUP command on one NDB Cluster to create a backup and then applying this backup on another NDB Cluster using ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Alternatively, you can drop and re-create such indexes immediately following the upgrade, but before making use of any of the tables in which they occur. When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
mysql_real_connect() attempts to establish a connection to a MySQL server running on host. If passwd is NULL, only entries in the user table for the user that have a blank (empty) password field are checked for a match. See the note following this ... MYSQL * mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) Description Note mysql_real_connect() is a synchronous ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-first-login-dashboard.html
This creates the Manager user described in Section 4.3.3, “Users Created on First Log-in”. Create user with agent role: the Agent user credentials are used by every monitoring agent to connect to MySQL Enterprise Service Manager. This is the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
View Details To view the chat session details, inspect the @chat_options variable: mysql> SELECT JSON_PRETTY(@chat_options); The output includes the following details about a chat session: Vector store tables: in the database which were referenced ... This topic describes how to view a chat session ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
It must correspond to the character set given in the dump metadata that was used when the MySQL dump was created by MySQL Shell instance dump utility, schema dump utility, or table dump utility. See Creating an IAM Policy to Access an Amazon S3 ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. In ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-document-store.html
A non-root account can be used as long as the account has privileges to create new databases. Execute the world_x.sql script to create the database structure and insert the data as follows: mysql> SOURCE /temp/world_x.sql; Replace /temp/ with the ...