Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. Users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Attempts to create a new user account or to alter an existing user account identified with mysql_native_password also fail and emit an error. mysql> CREATE USER userxx@localhost IDENTIFIED WITH 'mysql_native_password'; ERROR 1524 (HY000): Plugin ...
https://dev.mysql.com/doc/refman/8.4/en/preface.html
If you are using a Commercial release of MySQL 8.4, see the MySQL 8.4 Commercial Release License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Some conflict resolution functions (NDB$OLD(), NDB$EPOCH(), NDB$EPOCH_TRANS()) require ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/workbench/en/wb-plugins.html
Plugins are special Modules that are exposed to the user through the Workbench GUI. A plugin can be a simple function that performs some action on an input, and ends without further interaction with the user. To create a simple plugin, the function ...This is typically done using the main menu, or the context-sensitive ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn.html
A System DSN can normally only be configured by a systems administrator, or by a user who has specific permissions that let them create System DSNs. There are three types of DSN: A System DSN is a global DSN definition that is available to any user ... A Data Source Name associates the configuration parameters for communicating with a specific ...