MySQL Settings

MySQL settings

Adding the configuration settings

1. Open my.cnf file
   
   vi /etc/my.cnf
   
   
2. 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

1. Restart the MySQL daemon after adding the configuration changes

systemctl restart mysqld