Configure the Mysql encoding method in Ubuntu

Find the configuration file

I installed it through sudo apt-get install mysql. Mysql configuration file in/etc/mysql/my. cnf
If the file cannot be found, run sudo find/-iname '*. cnf' to find all cnf files.

Modify configuration file

Add under [mysqld]
Default-character-set = utf8
Add under [client]
Default-character-set = utf8

Restart mysql

Sudo service mysql restart
Log on to mysql and check whether the operation is successful.
# Mysql-u root

Mysql> 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 |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +
8 rows in set (0.00 sec)

Restart mysql

Use unused commands to restart your mysql instance based on the method in which you install mysql. If you have configured the mysqld auto-start mode, you can execute
#/Etc/rc. d/init. d/mysql restart
To restart.
Or you can configure mysql as a system service.
# Service mysql restert