I am having problem working on a database my friend gave me. He created it on MAC and seems like Linux (debian) is case sensitive. Any idea how to make workbench convert everything to non-capital? Thanks

1 Answers

1
scaisEdge On

unix is case sensitive .. ..

You could try change the etc/mysql/my.cnf or you debian/MAC dir for mysql config

accordinng to https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html

Underneath the [mysqld] section add:

lower_case_table_names = 1 // or 0 or 2

Restart mysql