Message: mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]Message: mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

 Error:  Message: mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]Message: mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysql 8

Solutions: You may require to reset the root password with mysql_native_password, this problem probably comes with MySQL 8. 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ireT@321';

Share on Google Plus

About Penguin Technology

I am a passionate cloud and DevOps professional specializing in Linux and open-source solutions. Through this blog, I share my knowledge and experience with the community, offering tips and insights on cloud technologies and DevOps practices.