Rate this post

Last Updated on June 4, 2020 by Vikash Ekka

PhpMyAdmin error requested authentication method unknown to the client [caching_sha2_password]
PhpMyAdmin error requested authentication method unknown to the client [caching_sha2_password]


This error comes due to authentication problem. When you  try to login into MySQL by terminal, you  get the success . But when you try to login with PhpMyAdmin this error comes.

To fix this issue you have to do ALTER user in table and provide complex password. Below is the two line of command that you have to enter into MySQL database.

Replace your user and user_password with your own.

mysql> ALTER USER ‘user’@’localhost’ IDENTIFIED WITH   mysql_native_password BY ‘user_password’;

mysql> FLUSH PRIVILEGES;

mysql> exit

If above is not fixed your error/issue then create a new user with grant privileges and login with new credentials.


mysql> create user ‘vetechno’@’localhost’ identified by ‘vetechno@@1234’;

mysql> grant all privileges on . to ‘vetechno’@’localhost’;

mysql> ALTER USER ‘vetechno’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘vetechno@@1234’;

mysql> FLUSH PRIVILEGES;

mysql> exit

 

Conclusion

I hope this tutorial post has helped you to fix the [caching_sha2_password] on Ubuntu 18.04 LTS. Please feel free to ask your queries if you are facing any difficulties when creating new user on mysql.

Also Read:- How to install MySQL 5.5 on Ubuntu 20.04 LTS

Also Read:- Uninstall or Remove MySql 5.7 from Ubuntu 20.04 LTS.

Also Read:- How to install Mysql 5.6 on Ubuntu 18.04 LTS.

By Vikash Ekka

Hi All, My name is Vikash Ekka from India. I’m the founder and tech editor of https://www.vetechno.in. I have completed my Graduation in BCA. I love to write technical articles like Windows, Linux & MAC Tutorials, Tips, Tricks, How To fix, Tutorials About Ethical Hacking & Cyber Security Guide, and Software Review. Currently, I have been working as an IT professional since 2018.

One thought on “PhpMyAdmin error requested authentication method unknown to the client [caching_sha2_password]”

Leave a Reply

Your email address will not be published. Required fields are marked *