database users are always created with mysql_native_password authentication
Summary
Whenever database users are created, the authentication plugin used is always mysql_native_password, which is deprecated. Current versions of mysql8+ constantly warn when this deprecated type of authentication is used, filling the mysql error log.
Steps to reproduce
- Set the default authentication plugin to caching_sha2_password, for example during the installation of mysql-server
- Complete installation of ispconfig
- Create a database user
- Check the user's authentication plugin
Correct behaviour
authentication plugin should respect the configured default, such as caching_sha2_password
Environment
Server OS + version: Debian 12 ISPConfig version: 3.2.11p2 Software version of the related software: Apache/2.4.59 (Debian), mysql Ver 8.0.36 for Linux on x86_64 (MySQL Community Server - GPL)
References
https://forum.howtoforge.com/threads/creation-of-database-users-default-authentication-plugin.92266/