Skip to content

Instantly share code, notes, and snippets.

@mreis1

mreis1/MySQL8-Readme.md

Forked from jansanchez/gist:7893091
Last active January 16, 2021 11:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mreis1/972964bcded0e56e9d6087869da1e829 to your computer and use it in GitHub Desktop.
Save mreis1/972964bcded0e56e9d6087869da1e829 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL lower case table names sensitive in linux
Raw
gistfile1.md

MySQL lower case table names sensitive in linux

Type in your terminal

sudo vim /etc/mysql/my.cnf

Edit the file adding the entry lower_case_table_names=1 just under the group definition: [mysqld]

lower_case_table_names=1

It will look like

[mysqld]
#
# * Basic Settings
#
lower_case_table_names=1
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

Restart mysql

sudo service mysql restart

Enjoy!

Raw
MySQL8-Readme.md
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment