Help Center>
Relational Database Service>
FAQs>
Database Connection>
How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
Updated on 2024-05-13 GMT+08:00
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.
- Log in to the management console.
- Click
in the upper left corner and select a region and a project. - Click
in the upper left corner of the page and choose Databases > Relational Database Service. - On the Instances page, click the instance name.
- In the navigation pane on the left, choose Parameters.
- Search for character_set_server and collation_server, respectively, in the search box.
- 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
Database Connection FAQs
- What Should I Do If I Can't Connect to My RDS DB Instance?
- Can an External Server Access the RDS Database?
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- Why Can't I Ping My EIP After It Is Bound to a DB Instance?
- How Can I Obtain the IP Address of an Application?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
- Will My Access Be Restricted by Bandwidth When I Connect to My Instance from an ECS over a Private Network?
- Does RDS Support SSL Connections?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password?
- Will I Be Logged Out If the Connection to RDS for SQL Server Instances Times Out?
- How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
- What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
- How Do I View All IP Addresses Connected to a Database?
- Can I Access Standby RDS DB Instances?
- How Do I Check the Connections to an RDS for MySQL Instance?
Feedback
Was this page helpful?
Provide feedbackThank 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.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore
