PDO construct Server sent charset 255 unknown to the client Please report to the developers

Question

I m trying to connect to a MySQL database from Symfony 3 application  But when trying to create MySQL schema from a Symfony console command I get this error  PDO    construct    Server sent charset  255  unknown to the client  Please  report to the developers  Both PHP and MySQL are running in Docker containers   MySQL version  8 0 1  PHP version  7 1 3  Driver  pdo mysql  charset  UTF8  dsn   mysql host mysql dbname database charset UTF8    Any ideas

User · Answer

I had a very similar issue to this when testing a restored backup of a mysql and associated php system. No matter what configuration settings I added on mysql it was not making any difference. After troubleshooting the issue for some time I noticed in the mysql logs that the mysql config files were being largely ignored by mysql. The reason was due to the file permissions being too open which was due to the fact my zip backup and restore process was losing all file permissions. I modified my backup and restore scripts to use tar instead and then everything worked as it should.

In summary, check the file permissions on your mysql config files are correct. Hope this helps someone.

User · Answer

MySQL 8 changed the default charset to utf8mb4  But some clients don t know this charset  Hence when the server reports its default charset to the client  and the client doesn t know what the server means  it throws this error   See also https   bugs mysql com bug php id 71606  That bug is against the MySQL Connector C   so it s affecting more than just PHP   Okay   I got it to work by changing the character set to utf8  to be compatible with non-upgraded clients  I added this to  etc my cnf and restarted mysqld    client  default-character-set utf8   mysql  default-character-set utf8    mysqld  collation-server   utf8 unicode ci character-set-server   utf8   I found these settings in an answer from 2010  Change MySQL default character set to UTF-8 in my cnf

User · Answer

Works for me    the environment   localhost Windows 10 PHP 5 6 31 MYSQL 8   set   default-character-set utf8   on      c  programdata mysql mysql server 8 0 my ini    Not works on  C  Program Files MySQL MySQL Server 5 5 my ini   Tools that helps   C  Program Files MySQL MySQL Server 8 0 bin gt mysql -u root -p  mysql gt  show variables like  char     mysql gt  show variables like  collation      m

User · Answer

I was facing same issue so I have reinstall MySQL 8 with different Authentication Method  Use Legacy Authentication Method  Retain MySQL 5 x compatibility   then work properly   Choose Second Method of Authentication while installing

User · Answer

In My Aws Windows I Solved it and steps are  Open  quot C  ProgramData MySQL MySQL Server 8 0 quot  Open My ini Find  quot  mysql  quot  After  quot no-beep  quot  Brake Line and insert  quot default-character-set utf8 quot  Find  quot  mysqld  quot  Insert  quot collation-server   utf8 unicode ci quot  Insert  quot character-set-server   utf8 quot   example       socket MYSQL  port 3306   mysql  no-beep  default-character-set utf8   default-character-set     SERVER SECTION   ----------------------------------------------------------------------      The following options will be read by the MySQL Server  Make sure that   you have installed the server correctly  see above  so it reads this    file        server type 2  mysqld   collation-server   utf8 unicode ci character-set-server   utf8   The next three options are mutually exclusive to SERVER PORT below    skip-networking    enable-named-pipe    shared-memory

User · Answer

My case was that i was using RDS  mysql db verion 8  of AWS and was connecting my application through EC2  my php code 5 6 was in EC2    Here in this case since it is RDS there is no my cnf the parameters are maintained by PARAMETER Group of AWS  Refer  https   docs aws amazon com AmazonRDS latest UserGuide USER WorkingWithParamGroups html  so what i did was    Created a new Parameter group and then edited them  Searched all character-set parameters  These are blank by default  edit them individually and select utf8 from drop down list    character set client   character set connection   character set database   character set server   SAVE    And then most important  Rebooted RDS instance   This has solved my problem and connection from php5 6 to mysql 8 x was working great   hope this helps   Please view this image for better understanding  enter image description here

User · Answer

The accepted answer saved me  thanks  Bill      but I ran into another related issue  just wanted to provide some details on my experience -   After upgrading to MySQL 8 0 11  I experienced the same problem as the OP when using PHP s mysqli connect   function  In my MySQL directory  in my case  usr local mysql   I created the my cnf file  added the content in the accepted answer  then restarted the MySQL server  However  this produced a new error   mysqli connect    The server requested authentication method unknown to the client  caching sha2 password   I added the line default authentication plugin   mysql native password  so my cnf now looked like    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   and I was good to go   For additional reference  https   github com laradock laradock issues 1392

User · Answer

find section  MySQLi  in your php ini and add line    mysqli default charset    UTF-8   Similar changes my require for section  Pdo mysql  and  mysqlnd    Issue seems to be specifically with MySQL version 8 0  and above solution found working with PHP Version 7 2  and solution didn t work with PHP 7 0

User · Answer

I had the same issue to connect to local system   I checked in the services list  Run- Services msc- Enter  wampmysqld64 was stopped    Restarted it  and was able to login

User · Answer

I solved this problem by adding following code into my  etc my cnf file -     client  default-character-set utf8   mysql  default-character-set utf8    mysqld  collation-server   utf8 unicode ci character-set-server   utf8   After saving that I went into my system settings and stopped MYSQL server and started again  and it worked

User · Answer

I had this problem also  The issue was because I was running an old version of PHP  5 6  and once I upgraded to PHP 7 4 the errors went away   This was on Amazon Linux 2 for me and the command to upgrade was   amazon-linux-extras install php7 4  Other flavors of  nix might have it in their repositories otherwise if you re on a flavor of Linux then Remi might have it for you here  https   rpms remirepo net

[php] PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers

Examples related to php

Examples related to mysql

Examples related to pdo