MySQL: Server sent charset (255) unknown to the client

Websites are giving a mysql error, and the log shows “MySQL: Server sent charset (255) unknown to the client.”

With the release of MySQL 8, the default character set was changed to utfmb4. Since this differs than what may be in the mysql database, the error is presented.

 

The fix for this involves modifying the /etc/my.cnf file to set the default character set to UT8:

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

Once modified, restart mysql and the websites should load properly.

You May Also Like

About the Author: admin

Leave a Reply

Your email address will not be published. Required fields are marked *