Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-process.html
If the added nodes are started with start process --initial instead, you are then required to run CREATE NODEGROUP manually via the ndb_mgm client. Using add process to Simplify create cluster Commands Processes added before the cluster is started ...Any hosts referenced in the list must be members of the site to which the cluster ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-ldap-kerberos-authentication.html
To use simple LDAP authentication with MySQL Shell, the following conditions must be satisfied: A user account must be created on the MySQL server that is set up to communicate with the LDAP server. For example: CREATE USER 'admin'@'localhost' ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store. OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
An instance of NdbBlob is created using the NdbOperation::getBlobHandle() method during the operation preparation phase. getLength() Gets the length of a blob, in bytes getNdbError() Gets an error (an NdbError object) getNdbOperation() Get a pointer ... This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/group-management.html
For example, you can create groups for development and production instances. User-defined groups are those created and managed in MySQL Enterprise Service Manager's Manage Groups page. You can use the configuration utility to add connections to ...