DirectAdmin setup database error "Server sent charset unknown to the client"
by
RV Support
RV Support
When you're installing RVsitebuilder on DirecAdmin and it's putting an error on Database setup process.
Error
Cannot connect to DB, check your credentials, exiting ...
Error message: Server sent charset unknown to the client
Solution:
Add the following text in
/etc/my.cnf:Default:
[mysqld] max_allowed_packet=64M local-infile=0 innodb_file_per_table=1
Add following:
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] collation-server = utf8_unicode_ci character-set-server = utf8 default_authentication_plugin = mysql_native_password max_allowed_packet=64M local-infile=0 innodb_file_per_table=1
And restart MySQL run command
service mysqld restart
And follow MySQL strict mode function, breaks RVsitebuilder program
