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
Answer
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
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.
