i have created cnf file on /devilbox/cfg/mysql-5.6/devilbox-custom.cnf
this fila contain
[mysqld]
lower_case_table_names=1
seeing mysql info, lower case table name is 0
created file, then run docker-compose up -d
im trying to add
command: mysqld --lower_case_table_names=1 --skip-ssl
but not work
i have deleted all docker images and re run docker-compose up, but lowe case table name still on 0
@jlopezjuy I am really stuck on this one. Debian here as well and it works like a charm.
Can you try out a different MySQL version. Are there any other configuration files already present in that directory?
@jlopezjuy did you encounter any errors on file permissions. This file is NOT READ if it has the wrong permissions. See here: https://devilbox.readthedocs.io/en/latest/support/troubleshooting.html#warning-world-writable-config-file-etc-mysql-docker-default-d-my-cnf-is-ignored
Stale issue
This issue was marked with waiting for reply and did not receive an answer for a long time. If the requested information is not provided, it will be auto-closed.
Beep beep, I am a bot - do not reply to me.
I will close this issue as the requested information was not provided and I was unable to reproduce it. Feel free to reply here for re-opening.
With last version (commit 3cbbdb35b0434d7c71ad0e71bd205494c23a96ca)
Host operating system: Ubuntu 18.04
Native Docker or Docker Toolbox: Native Docker
Docker version: Docker version 18.09.3
Docker Compose version: docker-compose version 1.23.2
SUMMARY
i have created cnf file on
/devilbox/cfg/mysql-5.6/lower_case_table_names.cnf
and
/devilbox/cfg/mysql-5.5/lower_case_table_names.cnf
chmod 0444
file contents:
[mysqld]
lower_case_table_names=1
mysql info, lower lower_case_table_names is always 0
@manzolo I've reproduced the behaviour and identified the issue: The currently mounted config directory does not evaluate in any of the official MySQL images. The fix will be provided shortly.
CC @jlopezjuy
Fix will be available today. I've also added regression tests so that this issue won't be able to occur again:
https://github.com/devilbox/docker-mysql/pull/5/files
Fix is merged and available. Update all your MySQL, MariaDB and Percona images.
The next Devilbox Bugfix release will also enforce this new version even though if you haven't explicitly pulled those images.
Has been properly addressed in Release v1.0.1
Most helpful comment
@manzolo I've reproduced the behaviour and identified the issue: The currently mounted config directory does not evaluate in any of the official MySQL images. The fix will be provided shortly.
CC @jlopezjuy