Solve the Problem of installing mysql garbled in ubuntu, and garbled tumysql

Solve the Problem of installing mysql garbled in ubuntu, and garbled tumysql

 

Installing mysql in ubuntu

 

1. Problem description:

Insert Chinese characters:

Garbled display:

 

2. solution:

Run the following command:

Add the following pink area content:

That is:Character-set-server = utf8

Save and exit.

 

Restart mysql:

 

3. Verify whether garbled data is resolved:

RepeatCreate a database:

 

Enter the database:

Create a table:

Insert data containing Chinese characters:

Query table content:

Normal display of Chinese characters:

 

 

 

After the modification, the Chinese characters are displayed normally.