MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found

by

I had the following solution:
change my.ini in a [mysqld] section like this:

#default_authentication_plugin=caching_sha2_password  (comment line!)
default_authentication_plugin=mysql_native_password   (new line)

Connect to your MySQL under root in a command line client
and execute:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx';

Where xxx is your current password.

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. How to connect mysql workbench to running mysql inside docker?
  11. MySQL Workbench: How to keep the connection alive
  12. How do I retrieve my MySQL username and password?
  13. MySQL error 1022 when creating table
  14. Is there a naming convention for MySQL?
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL Errno 150
  17. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  18. error code 1292 incorrect date value mysql
  19. Order by FIELD in MYSQL
  20. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  21. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  22. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  23. mySQL query to search all tables within a database for a string?
  24. Create a new database with MySQL Workbench
  25. Errno 121, duplicate key on write or update?
  26. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  27. MySQL error 2006: mysql server has gone away
  28. Select values that meet different conditions on different rows?
  29. How to speed up sql queries ? Indexes?
  30. How do I add two count(*) results together on two different tables?

Leave a Comment