MySQL 8.0 and Softaculous

[chrismfz]

On a fresh install with MysQL 8.0 everything seems to work OK.
I can create db users, log in to phpMyAdmin and so on.

But when I installed Softaculous it couldn't (as a user) create db users and got an error message.

Solved when I entered in my.cnf:
default-authentication-plugin=mysql_native_password

But does this affect anything else with directadmin ?
Should I change
mysql_detect_correct_methods=1 or
mysql_use_new_user_methods=1 to 0?


Anything else I should worry about / miss / take a look at when using MySQL 8.0 ?

 

[smtalk]

mysql_detect_correct_methods=1 is enough. Regarding softaculous - please make sure your version of PHP is 7.3 or higher, lower ones have no support for caching_sha2_password authentication method (used by default with MySQL 8.0).