WordPress unknown character set utf8mb4 error

WordPress Logotype

How to fix this “WordPress database error: [Unknown character set: ‘utf8mb4’] ~” error. Simply change “utf8mb4” to “utf8” in the Database Charset setting in your wp-config.php file.

Voila.

Update (2018.02.01): Do NOT follow any of that above. You’re going to want to keep the ‘utf8mb4’ under Database Charset in your wp-config.php file, but you’ll need to upgrade your WordPress database. You can do so by navigating here YOUR_WP_INSTALL_FOLDER/wp-admin/includes/upgrade.php. For reasons why, read this from WordPress about utf8mb4 being the standard charset for WordPress. And then why you should never use utf8 for WordPress databases, instead utf8mb4.

Cheers.

(Visited 176 times, 1 visits today)

If you found this post useful ...

Buy Me a Coffee logo
Wondering why you keep seeing lower-cased 'i' in my posts? Read -> Why ‘i’ is not capitalized
0 0 votes
Article Rating
Subscribe
Notify of
guest

1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
trackback
7 years ago

[…] if you’re like me, you do a lot of WordPress development locally and experience annoying issues. I use MAMP, personally, as do many others. One of these common headaches is the MySQL server not […]

1
0
Would love your thoughts, please comment.x
()
x