Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: MY-010157; Symbol: ER_LOG_FILE_INVALID; SQLSTATE: HY000 Message: Invalid value for %s: %s Error number: MY-010158; Symbol: ER_LOWER_CASE_TABLE_NAMES_CS_DD_ON_CI_FS_UNSUPPORTED; SQLSTATE: HY000 Message: The server option ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. How table and database names are stored on disk and used in MySQL is affected by the ... In MySQL, ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
lower_case_table_names Command-Line Format --lower-case-table-names[=#] System Variable lower_case_table_names Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value (macOS) 2 Default Value (Unix) 0 Default Value (Windows) 1 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
If you intend to change the lower_case_table_names setting to 1 at upgrade time, ensure that schema and table names are lowercase before upgrading. You can use the following queries to check for schema and table names containing uppercase ... Before ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
If the grant tables hold privilege rows that contain mixed-case database or table names and the lower_case_table_names system variable is set to a nonzero value, REVOKE cannot be used to revoke these privileges. (GRANT does not create such rows when ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
A convenient way to ensure that names are created in lowercase is to set lower_case_table_names to 1 before initializing the server. (It is prohibited to start the server with a lower_case_table_names setting that is different from the setting used ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
If the grant tables hold privilege rows that contain mixed-case database or table names and the lower_case_table_names system variable is set to a nonzero value, REVOKE cannot be used to revoke these privileges. (GRANT does not create such rows when ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-system-initialization-variables.html
Table 19-6 Initialization Variables Name Value lower_case_table_names CASE_SENSITIVE: (Default) Table and schema name comparisons are case-sensitive and are stored as you specify them. System Initialization Variables 19.4 System Initialization ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/platforms.compatibility.html
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 versa. However, because Identifier Case ...