How to change the character set encoding to UTF8 in MySQL 5.5/5.6 under Linux
|
1. Log in to MySQL and use SHOW VARIABLES LIKE 'character%'; to view the character set, as shown below: +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ The default character set for character_set_database and character_set_server is still latin1. 2. The simplest and most perfect modification method is to modify the character set key value in the my.cnf file of MySQL (pay attention to the configuration field details): 1. Add default-character-set=utf8 to the [client] field, as follows: [client] port = 3306 socket = /var/lib/mysql/mysql.sock default-character-set=utf8 2. Add character-set-server=utf8 to the [mysqld] field as follows: [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock character-set-server=utf8 3. Add default-character-set=utf8 to the [mysql] field, as follows: [mysql] no-auto-rehash default-character-set=utf8 After the modification is completed, restart the MySQL service with service mysql restart to make it take effect. Note: The [mysqld] field is different from the [mysql] field. No one has reported this online. Use SHOW VARIABLES LIKE 'character%'; to check and find that the database encoding has been changed to utf8. +--------------------------+----------------------------+ | 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/ | +--------------------------+----------------------------+ The above method of changing the character set encoding to UTF8 in MySQL 5.5/5.6 under Linux is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM. You may also be interested in:
|
<<: Rsync+crontab regular synchronization backup under centos7
>>: Installation and use tutorial of Elasticsearch tool cerebro
Recommend
Teach you how to create a project using vue-cli3 in five minutes (beginner's guide)
Table of contents 1. Build the Vue environment 2....
MySQL semi-synchronous replication principle configuration and introduction detailed explanation
Environment Introduction: Ubuntu Server 16.04.2+M...
In-depth reading and practice records of conditional types in TypeScript
Table of contents Using conditional types in gene...
An example of using CSS3 animation to achieve the effect of a circle expanding from small to large and spreading outward
Preface This article mainly shares with you an ex...
How to implement CSS mask full screen center alignment
The specific code is as follows: <style> #t...
JavaScript implements countdown on front-end web page
Use native JavaScript to simply implement the cou...
HTML form component example code
HTML forms are used to collect different types of...
XHTML introductory tutorial: Web page Head and DTD
Although head and DTD will not be displayed on th...
How to find websites with SQL injection (must read)
Method 1: Use Google advanced search, for example...
Implementation method of Nginx+tomcat load balancing cluster
The experimental environment is as follows Here y...
MySQL Error 1290 (HY000) Solution
I struggled with a problem for a long time and re...
Analysis of log files in the tomcat logs directory (summary)
Each time tomcat is started, the following log fi...
Basic usage of @Font-face and how to make it compatible with all browsers
@Font-face basic introduction: @font-face is a CSS...
Pure CSS to add style to select (no script) implementation
Change the default style of select, usually throug...
CSS to achieve horizontal lines on both sides of the middle text
1. The vertical-align property achieves the follo...