Current latest stable ispconfig with mysql server on Debian 12 apparently creates database users with the mysql_native_password plugin even when the default plugin is set to caching_sha2_password. It seems that it would be useful for ispconfig to create users using the configured default mysql authentication plugin. Going forward the sha2 plugin is of course preferable and mysql_native_password is deprecated. With mysql server a warning is logged to the mysql error log very frequently when the deprecated plugin is used. Much appreciated
You can open a issue for this in our bug tracker: https://git.ispconfig.org/ispconfig/ispconfig3/-/issues