Can MySQL 8 be configured with the new sha2 for OJS v3?


We have recently upgraded OJS to version 3.1.0 and our IT department is looking at upgrade mysql from 5.6.39 to 8 and use sha32 password authentication. We are currently using sha1.

Does anyone know if MySQL 8 can be configured with the new sha2 password authentication type for OJS 3?

We are on PHP 5.6.35.

Many thanks in advance.


Even if you have the old encryption setting in, it is only being used for legacy passwords where the user is not active.

Thanks for your reply. We have decided to stay with MySQL5.6.