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

[Yanan_Zhao]

Hello,

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.

Yanan

[ctgraham]

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

Import/convert md5 passwords to sha1 in OJS 3.0.2

Recent versions of OJS 2 and 3 use the password_compat library rather than md5 and sha1. Passwords will automatically be updated to a modern hash rather than the old md5 and sha1 hashes as they are used (or as new ones are created). The encryption option in config.inc.php is only relevant for legacy password hashes which haven’t been upgraded yet (because the user hasn’t logged in).

[Yanan_Zhao]

@ctgraham

ecent versions of OJS 2 and 3 use the password_compat library rather than md5 and sha1. Passwords will automatically be updated to a modern hash rather than the old md5 and sha1 hashes as they are used (or as new ones are created). The encryption option in config.inc.php is only relevant for legacy password hashes which haven’t been upgraded yet (because the user hasn’t logged in).

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