Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Instructions for creating the clone user and granting the required privileges are included in the remote cloning example that follows this prerequisite information. mysql> CREATE USER 'donor_clone_user'@'example.donor.host.com' IDENTIFIED BY ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. The exception is if the activate_all_roles_on_login system variable is enabled, in which case MySQL Server sets all roles granted to the DEFINER ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
MySQL grants table write locks as follows: If there are no locks on the table, put a write lock on it. MySQL grants table read locks as follows: If there are no write locks on the table, put a read lock on it. This section discusses internal ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster Replication”). To provide replication backup capability, you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as my.ini. When you select Named Pipe connectivity, and then proceed to the next step, you are prompted to set the level of access control ...
https://dev.mysql.com/doc/refman/8.4/en/network-namespace-support.html
For example, if you perform an in-place MySQL upgrade, failure to grant the CAP_SYS_ADMIN capability again results in namespace-related failures. A network namespace is a logical copy of the network stack from the host system. Network namespaces ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. (Direct modification of grant tables is discouraged, anyway.) For the general query log, password rewriting can be suppressed by starting the ...