MYSQL Modify Character Set

1. Temporary modification
Set Names UTF8
2. Permanent modification
Mysqld Next Plus
Character_set_server = UTF8

MariaDB [(None)]> show variables like '%char% ';
+--------------------------+-------------------------------------------------------+
| variable_name | Value |
+--------------------------+-------------------------------------------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /var/soft/mariadb-5.5.50-linux-x86_64/share/charsets/|
+--------------------------+-------------------------------------------------------+

Client and MySQL next add
Default-character-set = UTF8
MariaDB [(None)]> show variables like '%char% ';
+--------------------------+-------------------------------------------------------+
| variable_name | Value |
+--------------------------+-------------------------------------------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /var/soft/mariadb-5.5.50-linux-x86_64/share/charsets/|
+--------------------------+-------------------------------------------------------+

Need to add a mysqld under the
Skip-character-set-client-handshake
MariaDB [(None)]> show variables like '%char% ';
+--------------------------+-------------------------------------------------------+
| variable_name | Value |
+--------------------------+-------------------------------------------------------+
| character_set_client | UTF8 |
| character_set_connection | UTF8 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /var/soft/mariadb-5.5.50-linux-x86_64/share/charsets/|

MYSQL Modify Character Set