Re: move db from mysql 5.6.51 to 8.0.26.
Posted by: Laurent Liegeois
Date: July 14, 2022 01:39AM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.