install mysql 5.6 on CentOS 8?

[SupermanInNY]

Hi All,

Is it possible to install mysql 5.6 on a CentOS 8?
I tried to set it to 5.6, but CB is complaining:


Incorrect mysql value (used to specify MySQL release) set in the options.conf file. Set: 5.6. Available values: 8.0.

So, is it possible to install earlier versions?

Thanks,

-Sup.

 

[smtalk]

It's doable only from the source, manually. Because MySQL has no official 5.6 package for CentOS8. However, it should work just fine with PHP 7.4, if you'd like to use 8.0 Else I'd suggest sticking with MariaDB.

 

[SupermanInNY]

Thanks,
My client reported some encoding issues, from migrating from a 5.6 to 8.0.
I hope he'll resolve these issues

 

[SupermanInNY]

The error my client received was:

Server sent charset unknown to the client. Please, report to the developers

His solution was to add the following to the my.cnf file:

character-set-server=utf8

But, then appeared a different error:

The server requested authentication method unknown to the client

So, his last resolve was to add the following in the my.cnf:

default_authentication_plugin= mysql_native_password


After that, he claimed it resolved his encoding issues.
HTH someone else too.

-Sup.