@sthopd opened this Issue on November 23rd 2018

Hello,
I have updated the live-site to v3.6.0 and still get the same error when I ‘Setup a Website’.
Error:
Cannot connect to the database:
Server sent charset unknown to the client. Please, report to the developers

How do I solve the problem of “Server sent charset unknown to the client.”?!
I have newly installed the Matomo analytics site on my Production server.
On my production server, I get an error when creating the first site-to-be-analyzed by Matomo.
Error:
“SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers”
I see that within many PHP-code pages of Matomo, the character set for database handling is set -hard coded- to UTF8 !
Please developer, change this -hard coded- setting into a flexible variable that every webmaster can maintain in the config-file (…\config\config.ini.php).
or change the -hard coded- content to the a modern character set variant, such as: utf8mb4 .
Any help would be appreciated.
Friendly regards,
Simon
Environment:
Matomo 3.5.1
MySQL 8.0.12 (different port)
PHP 7.2.7
IIS 10 webserver on Windows 10 pro OS

Have a look at: https://bugs.php.net/bug.php?id=74461 .
and: MySQL Bugs: #85946: MySQL 8.0.1 breaks php compatibilty .
Where should I change the CharSet setting: in Matomo? in MySQL? in PHP?

20181001 matomo live - set up first website

20180927 mysql8012 character set in live site

@tsteur commented on November 23rd 2018 Member

see https://github.com/matomo-org/matomo/issues/9785

if possible change it to utf8

@sthopd commented on November 23rd 2018

Hello Thomas,

Thank you for your advice.
I set the Collation for the Matomo database in MySQL 8.0.13 to utf8_bin (there is no collation utf8) but the error message does not go away.
(PHP: version 5.6.31)

Friendly regards,
Simon

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10


From: Thomas Steur <notifications@github.com>
Sent: Friday, November 23, 2018 6:51:57 PM
To: matomo-org/matomo
Cc: sthopd; Author
Subject: Re: [matomo-org/matomo] MySQL 8.0.1 error “Server sent charset unknown to the client.” (#13756)

see #9785https://github.com/matomo-org/matomo/issues/9785

if possible change it to utf8


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com/matomo-org/matomo/issues/13756#issuecomment-441295026, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AZYydl6pwAn60S33pIt-DyKYwbdhrua9ks5uyDW9gaJpZM4YwpPd.

@MarceloNascimento commented on April 15th 2019

I am with the same erro here, but i'm using mysql_connect, i belivie that are some thing into xamp, wamp, apache.

@narendra-pal-singh commented on August 13th 2019

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.

Good Luck!

@zubair86 commented on February 9th 2021

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.

Good Luck!

Could you please share commands with which we can reinstall and use different Authentication Method?

Thanks!

Powered by GitHub Issue Mirror