Upgrade MySQL RDS instance 5.7.36 to 8.0 failing
1
upgrading MySQL RDS instance 5.7.36 to 8.0 but it didn't get upgraded. We checked the prechecked compatibility log and found error "mysql - schema's default character set: utf8" how to fix this.
asked 5 months ago30 views
1 Answers
0
It is because MySQL 8.0 includes a number of incompatibilities with MySQL 5.7. For improved Unicode support, consider converting objects that use the utf8mb3 charset to use the utf8mb4 charset. The utf8mb3 character set is deprecated. Also, consider using utf8mb4 for character set references instead of utf8, because currently utf8 is an alias for the utf8mb3 charset.
For more information, see The utf8mb3 character set (3-byte UTF-8 unicode encoding) in the MySQL documentation.
answered 3 months ago
Relevant questions
Upgrade MySQL RDS instance 5.7.36 to 8.0 failing
asked 5 months agoWhy the LoginFailures metric showing no data for RDS MySQL instance?
asked 3 years agoProblem with deadlock on AWS RDS MySQL
asked 4 years agoRDS MySQL 5.6 > 5.7 Update Issues
asked 3 months agoUpgrading Aurora MySQL 5.6 to 5.7 on cross region replica stuck in pre-upgrade checks and reboots every 30 minutes
asked a month agoRDS MySQL upgrade takes forever due to 0% repeatly snapshot creation
asked 3 months agoError when modifying db.m5.xlarge RDS MySQL for Performance Insights
asked 2 years agoRDS MYSQL 8.0 parameter group value is not updating
asked 5 months agoRDS MySQL not upgrading minor version (even though it shows "upgrading")
asked 3 months agoCan I import an RDS uncrypted mysql snapshot to an RDS encrypted mysql?
Accepted Answerasked 2 months ago