Help Center> Relational Database Service> User Guide (Ankara Region)> FAQs> Database Connection> How Do I Set the Encoding Format of the MySQL 8.0 Character Set?

Updated on 2024-04-11 GMT+08:00

View PDF

How Do I Set the Encoding Format of the MySQL 8.0 Character Set?

Set character_set_server to utf8 and collation_server to utf8_general_ci.
1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
4. On the Instances page, click the instance name.
5. In the navigation pane on the left, choose Parameters.
6. Search for character_set_server and collation_server, respectively, in the search box.
7. Set the parameters to utf8 and utf8_general_ci, respectively, and click Save.
If you use a client of PHP 7.1.x, change the PHP version because it will fail to connect to MySQL 8.0 DB instances with the utf8mb4 character set.

Parent topic: Database Connection

Previous topic: Why Did the New Password Not Take Effect After I Reset the Administrator Password?

Next topic: What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.