Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To perform the user-creation operation without either of these, drop the orphan objects, create the account and grant its privileges, and then re-create the dropped objects. To assign privileges or roles to this account, use one or more GRANT ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
Within the data directory, the server creates the mysql system schema and its tables, including the data dictionary tables, grant tables, time zone tables, and server-side help tables. These include statements that relate to account management (such ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. The mysql.user grant table defines the initial MySQL user account and its access privileges.
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
We also assume that, after the server has been started, the required privileges have also been set up for MySQL Enterprise Backup to access the server (see Grant MySQL Privileges to Backup Administrator, for details). If a user name and a password ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
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 channels. The same replication user is used for distributed recovery on all the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
Group Replication uses a distributed recovery process to synchronize group members when joining them to the group. Distributed recovery involves transferring transactions from a donor's binary log to a joining member using a replication channel ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
This applies to identifiers in table definitions and to identifiers stored in the grant tables in the mysql database. The sizes of the identifier string columns in the grant tables are measured in characters. For information about the maximum length ... The following table describes the maximum length for each type of ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Suppose that an account is granted roles as follows: GRANT 'r1', 'r2' TO 'u1'@'localhost'; SET DEFAULT ROLE ALL TO 'u1'@'localhost'; In sessions for u1, the initial CURRENT_ROLE() value names the default account roles. One way this might occur is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-applicable-roles-table.html
GRANTEE The user name part of the account to which the role is granted. GRANTEE_HOST The host name part of the account to which the role is granted. IS_GRANTABLE YES or NO, depending on whether the role is grantable to other accounts. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...