CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers code example

Example 1: mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers

Create a file called my.cnf in your /etc/ folder.

    Now add the following text to /etc/my.cnf:

    [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

Finally, restart mysql and all should be well! If you still have an issue, try upgrading PHP to a later version.

Example 2: mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers

Editaremos el archivo de configuración my.cnf
El cual se debe encontrar en C:\ProgramData\MySQL\MySQL Server 8.0
Agregamos y/o modificamos las siguientes lineas:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci

character-set-server = utf8 

Una vez hecho esto, reinicien su servicio de Mysql