Can not connect to new database in mysql 8

alipour66m

Verified User
Joined
Feb 22, 2013
Messages
65
after update directadmin
I can not connect to new database! ( database creates but password not work)
old database are working...
 

smtalk

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