How to modify the default encoding of mysql in Linux

During the development process, if garbled characters appear in the database data after restoring the MySQL database, you can solve this problem by changing the default encoding of the database.

The following example shows how to modify the default encoding of MySQL to UTF-8:

1. Check the mysql information first

# View the database installation location whereis mysql 
# Log in to the database mysql -u root -p Enter the password as prompted # View the mysql status mysql>status 

2. Modify the my.cnf file

The directory is /etc/my.cnf

If there is no my.cnf file in the system, you need to create this file. For specific steps, please see 3. If it exists, skip step 3 and go directly to step 4.

3. Find files ending with .cnf

Command find / -iname *.cnf -print

The result is as shown below:

Copy any file in the /usr/share/mysql directory in the search results above to the /etc/ directory

Command: cp /usr/share/mysql/my-large.cnf /etc/my.cnf

4. Edit the my.cnf file

Command: vi /etc/my,cnf

Add below [client]

default-character-set=utf8

Add below [mysqld]

character_set_server=utf8

The above modification method may not take effect due to different MySQL versions.

In actual use, basically most of the MySQL will take effect. I have only encountered one unsuccessful modification. The specific reason has not yet been found out due to the limitations of the conditions at the time.

If anyone knows the reason, please let me know, I would be very grateful.

In addition, if the above modification method does not work, please change the line under [mysqld] to the following line:

default-character-set=utf8

5. Restart mysql

service mysql restart 

At this point, after logging in to MySQL, you can view the modification results through show variables like "character%"; If the result is consistent with the modified target encoding, then congratulations, the modification is successful!

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links