Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
For a list of what is included in each table, see Section 19.2.4.2, “Replication Metadata Repositories”. In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
Authentication involves one party establishing its identity to the satisfaction of a second party. If an account uses 2FA or 3FA, the mysql.user system table stores information about the additional authentication factors in the User_attributes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
NDB TDE encrypts user data files including LCP files, redo log files, tablespace files, and undo log files. Replication of an NDB Cluster whose file system is encrypted to a standalone MySQL server using InnoDB tables which are not encrypted. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-server-side-help.html
The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). To make a more specific request, please type 'help <item>', ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe accepts options on the command line and in option files, as described in the following table. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column Properties. It is possible for a row in the mysql.user system table to serve as both an account and a role. MySQL role ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update. This chapter discusses stored database objects that are defined in ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Alternatively, you can drop and re-create such indexes immediately following the upgrade, but before making use of any of the tables in which they occur. The Performance Schema variables_info table shows, for each system variable, the source from ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/platforms.compatibility.html
However, because Identifier Case Sensitivity is dependent on the case sensitivity of the underlying operating system (which varies across platforms), data transfer problems might occur due to letter case issues with the database or table names. All ... MySQL Enterprise Backup is by nature cross-platform compatible when running on the Linux and Windows operating systems: backups on a Linux machine can, in principle, be restored on a Windows machine, and vice ...