Can not connect to new database in mysql 8

alipour66m

Verified User
Joined
Feb 22, 2013
Messages
69
after update directadmin
I can not connect to new database! ( database creates but password not work)
old database are working...
 
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.
 
Back
Top