Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins.html
Authentication plugins enable the use of authentication methods other than the built-in method of passwords stored in the mysql.user system table. Also, authentication plugins can support the proxy user capability, such that the connecting user is a ... MySQL supports pluggable authentication, in which plugins are invoked to authenticate client ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
What is a MySQL connection? Why might I need to create more than one? A.2. How do I create a MySQL database (schema) in MySQL Workbench? A.4. What is a MySQL connection? Why might I need to create more than one? A MySQL connection links (connects) ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
Some OS distributions create these as part of the operating system installation process. Change location to the directory containing the downloaded file, unpack the archive, and create a symbolic link named mysql to the mysql directory. This ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
In addition to the mysqlbackup@localhost account created on each host as described in Section 4.1.2, “Grant MySQL Privileges to Backup Administrator”, accounts for the user mysqlbackup to access all hosts in the group have been created on every ... For how to use MySQL Enterprise Backup to back up and subsequently restore a Group Replication member, see Using MySQL Enterprise Backup with Group ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
The location of all undo tablespace files including user-defined undo tablespaces created using CREATE UNDO TABLESPACE syntax can be determined by querying the Information Schema FILES table: SELECT TABLESPACE_NAME, FILE_NAME FROM ...Default undo ...
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/refman/8.4/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. A maximum ...Session temporary tablespaces are allocated to a session from a pool of temporary tablespaces on the first request to create an on-disk temporary ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
database A set of tables and related objects owned by a MySQL user. I .ibd file Each InnoDB tablespace created using the file-per-table setting has a filename with a .ibd extension. .ibz file When the MySQL Enterprise Backup product performs a ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. old-style-user-limits: Enable old-style user limits ... Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in MySQL 8.4 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.4 since ...