Codeigniter3-The server requested authentication method unknown to the client caching sha2 password
Channel:
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=ZMCXI--1Kdk
0How to solve error on Codeigniter 3:
A PHP Error was encountered
Serverity: Warning
Message: mysqli::real_connect(): The server requested authentication method unknown to the client caching_sha2_password
Filename: mysqli/mysqli_driver.php
Solution:
Change mysql user authentication to mysql_native_password
ALTER USER 'myuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abcd';