MySQL 8.0 and Softaculous

chrismfz

Verified User
Joined
Jul 3, 2019
Messages
19
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

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,340
Location
LT, EU
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).
 
Top