# 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
```