Search Results
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded and are unavailable. If you need to load plugins for a single server startup when the --skip-grant-tables option is given ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
To prevent a client from loading XML files from the server, do not grant the FILE privilege to the corresponding MySQL user account, or revoke this privilege if the client user account already has it. Important Revoking the FILE privilege (or not ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-locks.html
This is reset to 0 when a lock is granted for a waiting request. The lock state is shown in the lock_state column; if this is W, the lock is waiting to be granted, and the waiting_for column shows the lock ID of the lock object this request is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
This is reset to 0 when a lock is granted for a waiting request. If the lock_state column's value is W, this lock is waiting to be granted, and the waiting_for column shows the lock ID of the lock object this request is waiting for. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host value is always a specific nonpattern host name. When a client connects to the MySQL server, it does so under a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-rwlock-instances-table.html
Depending on how many threads are requesting a lock, and the nature of the locks requested, access can be either granted in shared mode, exclusive mode, shared-exclusive mode or not granted at all, waiting for other threads to finish first. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host value is always a specific nonpattern host name. The Performance Schema makes status variable information available ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded and are unavailable. --plugin-load, --plugin-load-add, and --early-plugin-load enable plugins to be loaded even when ... Server ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Assign passwords to the initial root account in the grant tables, if that was not already ...