Skip to content

feat(mysql): Support the caching_sha2_password auth for newer MySQL servers

Daniel Jagszent requested to merge d--j/ispconfig3:mysql_sha2 into develop

Introduces new column database_password_sha2 for web_database_user that gets filled with a pre-generated caching_sha2_password hash. It is a copy of the database_password column.

The server then decides what password hash to use – on MariaDB and MySQL < 8.0 the database_password hash gets used on MySQL servers >= 8.0 the database_password_sha2 hash gets used.

Fixes #6702 (closed)
Fixes #6695 (closed)

Edited by Daniel Jagszent

Merge request reports