Configuring Mysql encoding method in Ubuntu

  
                  

Find the configuration file

I installed it via sudo apt-get install mysql. Mysql configuration file in /etc/mysql/my.cnf If you can't find this file, you can run sudo find /-iname ‘*.cnf’ find all cnf files

modify configuration file

Add default-character-set=utf8 under [mysqld] Add default-character-set=utf8

to restart mysql

sudo service mysql restart Login to mysql Succeeded # mysql -u root

mysql> SHOW VARIABLES LIKE 'char%'; +-------------------------- +----------------------------+

Copyright © Windows knowledge All Rights Reserved