MySQL 8.0.1 error “Server sent charset unknown to the client.” #13756
Milestone
Comments
|
see #9785 if possible change it to utf8 |
|
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 Mail<https://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 #9785<#9785>
if possible change it to utf8
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#13756 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AZYydl6pwAn60S33pIt-DyKYwbdhrua9ks5uyDW9gaJpZM4YwpPd>.
|
|
I am with the same erro here, but i'm using mysql_connect, i belivie that are some thing into xamp, wamp, apache. |
|
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! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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?
The text was updated successfully, but these errors were encountered: