Search Results
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
(For a discussion of concepts involved in proxying, see Section 8.2.19, “Proxy Users”.) An account that authenticates using mysql_no_login may be used as a proxied user for proxy accounts: -- create proxied account CREATE USER ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. The name of the performance_schema database is ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
Following the principle of least privilege, a MySQL account should only be granted privileges required to for its legitimate purposes. A user account can be granted roles, which grants to the account the privileges associated with each role. This ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
FLUSH PRIVILEGES Re-reads the privileges from the grant tables in the mysql system schema. As part of this operation, the server reads the global_grants table containing dynamic privilege assignments and registers any unregistered privileges found ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
When managing NDB Cluster 8.0.19 and later, the restore cluster command does not restore shared users and grants to the mysql.ndb_sql_metadata table by default; use the --include-stored-grants option to override this behavior and enable the restore ...Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file systems to be ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
Caution Do not use this command used if the server was started with the --skip-grant-tables option. This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
(See Section 2.3.25, “The NdbTransaction Class”.) Types The Ndb class does not define any public typesbut does define three data structures, which are listed here: EventBuffermemoryUsage Key_part_ptr PartitionSpec. See Section 1.5, ... This ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. MySQL stores account names in grant tables in the mysql system database using separate ...