خطای 2054 بعد از ارتقاء mysql به نسخه 8

198

SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from `users` where `email` = r@r.r limit 1)

 

پاسخ

 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
BY 'password';