Table of Contents
...
The database server on Linux is case-sensitive with regards to database and table names.
Add below lines line below [mysqld] section:
lower_case_table_names=1
...
Note: The value of the innodb_buffer_pool_size the variable can be safely set to 50% of the available RAM memory if the database server is on a different VM and no other apps are running on it.
...
A database collation is a set of rules used to compare characters in a character set. We configure collation as 'utf8_unicode_ci' because it supports all character characters used in the US, Canada, Australia, and Europe (Latin and Greek).
Add below lines under [mysqld] section in my.cnf file:
- init_connect='SET collation_connection = utf8_unicode_ci'
- init_connect='SET NAMES utf8'
- collation-server=utf8_unicode_ci
- skip-character-set-client-handshakehandshake ##Remove this setting for MySQL 8 to avoid the collation error in mysqldump.
Restarting service
| Code Block | ||||
|---|---|---|---|---|
| ||||
service mysql restart |
...