Websites hosted on the same cPanel are giving mysql errors. Log is showing
MySQL: Server sent charset (255) unknown to the client.
Default character set is changed to utfmb4 after the release of MySQL8 and that may be one of the causes of the error that occurs.
To Fix, this lets us modify the charset to utf8. Please refer to the following steps for this.
- Login to your server via ssh.
- Open the /etc/my.cnf file using your favorite editor.
- set the default character set to UT8:
collation-server = utf8_unicode_ci
character-set-server = utf8
The issue should be fixed now.
Facing an issue with cPanel update. Please refer to cPanel > Rebuild RPM for more details.