Como cambiar la sensibilidad de las tablas de mayúsculas, minúsculas en Linux (Centos 7, Red Hat 8, etc)

You are viewing an old version of this question. View the current version here.

Tengo el problema que no puedo cambiar la sensibilidad de tablas para que el motor busque el nombre de la tabla sea mayúscula o minúscula en Linux, y no encuentro en el directorio el archivo my.cnf que en versiones anteriores estaba en "/etc/mysql/my.cnf" para cambios en la configuración


There is lower_case_table_names, however note " This system variable's value cannot be changed after the datadir has been initialized". You may need to dump and restore the database with the new settings.

Centos/RHEL use /etc/my.cnf as the configuration file. If in doubt, use mysqld --help --verbose to see what files are read by reading the first few lines of the output.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.