MySQL Settings

MySQL settings

Adding the configuration settings

Open my.cnf filevi /etc/my.cnf

Add the below config settings to the end of the file

[client]

default-character-set = utf8mb4

[mysqld]

innodb_file_format = Barracuda

innodb_file_per_table = 1

innodb_large_prefix

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

skip-character-set-client-handshake

[mysql]

default-character-set = utf8mb4

Restart the MySQL daemon

Restart the MySQL daemon after adding the configuration changes

systemctl restart mysqld