Re: move db from mysql 5.6.51 to 8.0.26.
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
Subject
Written By
Posted
Re: move db from mysql 5.6.51 to 8.0.26.
July 14, 2022 01:39AM
Sorry, you can't reply to this topic. It has been closed.
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.