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
Admin