How to resolve Unable to load authentication plugin ‘caching_sha2_password’ issue

Starting with MySQL 8.0.4, they have changed the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password.

You can run the below command to resolve the issue.

sample username / password => student / pass123

ALTER USER 'student'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass123';

Refer the official page for details: MySQL Reference Manual

Related Posts:

  1. Eclipse/Maven error: “No compiler is provided in this environment”
  2. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  3. Why Maven project is tied to J2SE-1.5 by default?
  4. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  5. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  6. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  7. Cannot change version of project facet Dynamic Web Module to 3.0?
  8. No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK?
  9. “The import org.springframework cannot be resolved.”
  10. “Source folder is not a Java project” error in eclipse
  11. Configure active profile in SpringBoot via Maven
  12. Maven dependency update on commandline
  13. How do I enable index downloads in Eclipse for Maven dependency search?
  14. How to uninstall Eclipse?
  15. Is there a way to convert all comments into javadoc comments? [Eclipse/Java]
  16. “Error occurred during initialization of VM; Could not reserve enough space for object heap” using -Xmx3G
  17. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  18. Failed to write core dump. minidumps are not enabled by default on client version of windows
  19. How to uninstall Eclipse?
  20. Spring Boot – Unable to resolve Whitelabel Error Page
  21. Editor does not contain a main type in Eclipse [duplicate]
  22. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  23. “Error occurred during initialization of VM; Could not reserve enough space for object heap” using -Xmx3G
  24. Editor does not contain a main type in Eclipse [duplicate]
  25. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  26. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  27. How is “mvn clean install” different from “mvn install”?
  28. JRE Missing when installing eclipse
  29. Can’t find mysqladmin on Mac OSX 10.6.8
  30. Spring @PropertySources value not overriding
  31. Lombok and Maven
  32. Server Tomcat v9.0 Server at localhost failed to start
  33. Cannot find “Package Explorer” view in Eclipse
  34. what does Dead Code mean under Eclipse IDE Problems Section
  35. what does Dead Code mean under Eclipse IDE Problems Section
  36. Eclipse: Java was started but returned error code=13
  37. Server Tomcat v9.0 Server at localhost failed to start
  38. How to change a package name in Eclipse?
  39. Maven: Failed to read artifact descriptor
  40. Eclipse “Error: Could not find or load main class”
  41. Error: Selection does not contain a main type
  42. org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘demoRestController’
  43. Integrate Ant builder into Eclipse: Error “Variable references empty selection”
  44. What exactly is a Maven Snapshot and why do we need it?
  45. “Could not find Java SE Runtime Environment.” after installing Java
  46. Maven error : Could not find or load main class org.codehaus.plexus.classworlds.launcher.Launcher
  47. Eclipse does not start when I run the exe?
  48. The declared package does not match the expected package “”
  49. eclipse won’t start – no java virtual machine was found
  50. Access restriction: The type ‘Application’ is not API (restriction on required library rt.jar)
  51. Error: JAVA_HOME is not defined correctly executing maven
  52. Eclipse No tests found using JUnit 5 caused by NoClassDefFoundError for LauncherFactory
  53. Web server failed to start. Port 8080 was already in use. Spring Boot microserviceWeb server failed to start. Port 8080 was already in use. Spring Boot microservice
  54. Web server failed to start. Port 8080 was already in use. Spring Boot microservice
  55. JAVA_HOME should point to a JDK not a JRE
  56. channel 3: open failed: connect failed: Connection refused
  57. Java can’t find file when running through Eclipse
  58. java.sql.SQLException: No database selected – why?
  59. No appenders could be found for logger(log4j)?
  60. Syntax error on token(s), misplaced construct(s)
  61. “The public type <> must be defined in its own file” error in Eclipse [duplicate]
  62. Installing WindowBuilder on Eclipse Neon
  63. How to clear console in Java – Eclipse
  64. The import javafx cannot be resolved
  65. How are “mvn clean package” and “mvn clean install” different?
  66. Fatal error compiling: tools.jar not found:
  67. java.lang.VerifyError: Inconsistent stackmap frames at branch target 421
  68. Unreachable code in eclipse
  69. Cannot issue data manipulation statements with executeQuery()
  70. How to import a jar in Eclipse
  71. Connection Java – MySQL : Public Key Retrieval is not allowed
  72. What is the proper annotation since @SpringApplicationConfiguration, @WebIntegration, is deprecated in Spring Boot Framework?
  73. Resource leak: ‘in’ is never closed
  74. Android Emulator: Unfortunately App has stopped
  75. Java console program
  76. Cannot be resolved to a variable error in Eclipse
  77. Using JavaFX in JRE 8, “Access restriction” error
  78. Eclipse Problems View not showing Errors anymore
  79. “Cannot be resolved to a type” when attempting to use Scanner
  80. Resolving File paths – ‘File not found’ error in Eclipse
  81. java eclipse red exclamation mark
  82. Eclipse is executing the wrong Java file
  83. Maven build Compilation error : Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project Maven
  84. “insufficient memory for the Java Runtime Environment ” message in eclipse
  85. Unknown version of Tomcat was specified in Eclipse
  86. The request was rejected because no multipart boundary was found in springboot
  87. Which Eclipse IDE version to choose?
  88. Eclipse IDE – Error: Build path specifies execution environment Java SE 1.7
  89. How can i fix this equals on primitive type(int)
  90. A JRE or JDK must be available in order to run Eclipse. No JVM was found after searching the following locations
  91. Error :- java runtime environment JRE or java development kit must be available in order to run eclipse
  92. How fix Error:java.util.concurrent.ExecutionException: com.android.ide.common.process.ProcessException:
  93. The import javax.servlet can’t be resolved 
  94. java.lang.IllegalStateException: Failed to introspect Class
  95. Could not transfer artifact org.apache.maven.plugins:maven-surefire-plugin:pom:2.7.1 from/to central (http://repo1.maven.org/maven2)
  96. How to enable the Java keyword assert in Eclipse program-wise?
  97. Why “no projects found to import”?
  98. Error message ‘Cannot be resolved or is not a field’
  99. Spring Boot – Cannot determine embedded database driver class for database type NONE
  100. Eclipse message saying List cannot be resolved to a type

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduseduseduseduedusedueduedus