MARIADB Set database default encoding __ Database

MARIADB's default encoding is latin1, insert Chinese will garbled, so need to change the encoding to UTF8, but the current online modification methods are mostly for MySQL, although MySQL and Mariadb is a, but the method for the MARIADB does not apply, The solution is documented here.

For more mariadb tutorials, focus on the Linux University Network (linuxdaxue.com)

1, login MySQL, use

Show VARIABLES like ' character% ';

See the character set currently in use, there should be several not UTF-8 format.

2. The configuration file to be modified is located in the/ETC/MY.CNF.D directory:

Client.cnf

Join in the [Client] field

Default-character-set=utf8

Server.cnf

Join in the [mysqld] field

Character-set-server=utf8

The Systemctl restart MARIADB configuration takes effect and the modified effect is as follows: