Any way to disable charset-handshake and change default server charset in Managed MySQL?
Too many old products can’t connect to new MySQL8.
All recommendations or rewrite old product, or change MySQL server settings like this:
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [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
But how to do it in Managed MySQL?
Also “SET GLOBAL” way currently not available.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.