Re: move db from mysql 5.6.51 to 8.0.26.

[Laurent Liegeois]

Thanks a lot for your response.
unfortunately I have to choose the solution 2 that is to say to change the configuration of the server because one does not have the possibility of changing the code or the connectstring (I can only change the server name;-()

I tried to change the configuration several times and I have almost always the same result. The error message is
"Unknown character set index for field '255' received from server." or "Unknown character set index for field '254' received from server."

My current config is /etc/my.cnf.d/mysql-server.cnf with linux alma
[mysqld]
skip-character-set-client-handshake
character-set-client-handshake = 0
collation-server = utf8_unicode_ci
character-set-server = utf8
default_authentication_plugin = mysql_native_password


datadir=/u2/mysql/data
socket=/u2/mysql/data/mysql.sock
log-error=/var/log/mysql/mysqld.log


slow-query-log = 1
slow-query-log-file =/var/log/mysql/slow_query.log
long_query_time = 10
log-queries-not-using-indexes = 1

general_log = 1
general_log_file = /var/log/mysql/general.log


pid-file=/run/mysqld/mysqld.pid

ps : I tried with latin and utf8 and I restarted the service at each time.


Would you have an idea to solve my problem ?

thanks in advance