Shulou(Shulou.com)06/03 Report--

Modify MySQL character encoding

1. Log in to the database and view the database character coding table (SHOW VARIABLES LIKE 'character%';)

two。 Exit the database, modify the mysql configuration file, and change the database character encoding (vi / etc/my.cnf)

4. Add the following code after entering the configuration file, and then save and exit

[client]

Default-character-set=utf8

Character-set-server=utf8

Collation-server=utf8_unicode_ci

5. Restart the database service and log in to the database (systemctl restart mysql.service)

6. Check the coding table again to confirm that the modification is complete (SHOW VARIABLES LIKE 'character%';)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.