I login to MySQL using phpMyAdmin with root account and it produced this error.
|
1 2 3 |
The server requested authentication method unknown to the client mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client |
Login root via terminal
I was able to login using my root password means something configuration is not correct.
When I googled, I found 2 solutions. I tried the first one but fail. So I documented the one that works with Macbook M1 MacOS Big Sur.
Update root Password via Terminal
|
1 2 3 |
mysql -u root -p mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YouCanUseBackYourPassword'; |
Login Again At Your phpMyAdmin
It should work by now using root and the updated password.