PHP PDO DB connection error

[beloware]

Got error 'PHP message: PHP Warning: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]

Newer version mysql not supported sha2 passwords.
It can not connect to db.

[abakedapplepie]

not sure if we already covered this in discord or not, but ill leave it here for others:

if you have updated to mysql 8, you have to update php-mysqlnd. mysql 8 has introduced caching_sha2_password and most mysql drivers do not recognize the method.

as far as i know there's nothing i can do about this from a code standpoint

[gbballpack]

A possible workaround from a user standpoint would be to make a user that explicitly uses the mysql_native_password.

i.e., CREATE USER username@localhost identified with mysql_native_password by 'password';

https://stackoverflow.com/questions/49083573/php-7-2-2-mysql-8-0-pdo-gives-authentication-method-unknown-to-the-client-ca/50094517#50094517