Authentication plugin ‘caching_sha2_password’ cannot be loaded

by

you can change the encryption of the password like this.

ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

More Related Contents:

  1. Error Code: 2013. Lost connection to MySQL server during query
  2. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  3. Create a new database with MySQL Workbench
  4. Throw an error preventing a table update in a MySQL trigger
  5. Do different databases use different name quote?
  6. MySQL error code: 1175 during UPDATE in MySQL Workbench
  7. Binary Data in MySQL [closed]
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. Auto Generate Database Diagram MySQL [closed]
  12. How to connect mysql workbench to running mysql inside docker?
  13. View’s SELECT contains a subquery in the FROM clause
  14. MySQL : Multiple row as comma separated single row
  15. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  16. Case statement in MySQL
  17. SQL Order By Count
  18. Export a MySQL Database to SQLite Database
  19. What resources exist for Database performance-tuning? [closed]
  20. How to find out the MySQL root password
  21. How to display open transactions in MySQL
  22. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  23. MySQL query, MAX() + GROUP BY
  24. Easiest way to copy a table from one database to another?
  25. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  26. remove all numeric characters from column mysql
  27. How to Get True Size of MySQL Database?
  28. MySQL: Computed Column
  29. mySQL query to search all tables within a database for a string?
  30. How do I make a MySQL database run completely in memory?

Leave a Comment