Can not connect to new database in mysql 8

[alipour66m]

after update directadmin
I can not connect to new database! ( database creates but password not work)
old database are working...

 

[ditto]

Do you have mysql_use_new_user_methods=1 in directadmin.conf? If so it could be a new bug in DirectAdmin 1.57 relating to that feature added in 1.56.1: https://www.directadmin.com/features.php?id=2314

I would suggest opening av ticket with DirectAdmin support: https://tickets.directadmin.com/

 

[smtalk]

This is completely normal, MySQL 8 uses new authentication method named caching_sha2_password. If you'd like to use the old one (mysql_native_password), please set default-authentication-plugin=mysql_native_password in MySQL configuration. MySQL8 has new default charset as well, so, if you're looking for backwards compatibility, you might want to follow https://forum.directadmin.com/showthread.php?t=57534&p=294202#post294202 too.