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. The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  30. The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  31. Can’t find mysqladmin on Mac OSX 10.6.8
  32. Spring @PropertySources value not overriding
  33. Lombok and Maven
  34. Server Tomcat v9.0 Server at localhost failed to start
  35. Cannot find “Package Explorer” view in Eclipse
  36. JVM Crash – “EXCEPTION_ACCESS_VIOLATION”
  37. what does Dead Code mean under Eclipse IDE Problems Section
  38. Spring boot – Request method ‘POST’ not supported. Tried everything
  39. what does Dead Code mean under Eclipse IDE Problems Section
  40. Eclipse: Java was started but returned error code=13
  41. Unable to create requested service [org.hibernate .engine.jdbc.env.spi.JdbcEnvironment]-MySQL
  42. Server Tomcat v9.0 Server at localhost failed to start
  43. unused import statement for used ones in IntelliJ IDEA
  44. How to change a package name in Eclipse?
  45. what is this ANT build?
  46. Maven: Failed to read artifact descriptor
  47. Eclipse “Error: Could not find or load main class”
  48. Error: Selection does not contain a main type
  49. org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘demoRestController’
  50. Integrate Ant builder into Eclipse: Error “Variable references empty selection”
  51. What exactly is a Maven Snapshot and why do we need it?
  52. Spring Maven clean error – The requested profile “pom.xml” could not be activated because it does not exist
  53. “Could not find Java SE Runtime Environment.” after installing Java
  54. Maven error : Could not find or load main class org.codehaus.plexus.classworlds.launcher.Launcher
  55. Eclipse does not start when I run the exe?
  56. The declared package does not match the expected package “”
  57. eclipse won’t start – no java virtual machine was found
  58. Eclipse Java error: This selection cannot be launched and there are no recent launches
  59. How can I avoid this Ant Build error?
  60. Consider defining a bean of type ‘package’ in your configuration [Spring-Boot]
  61. Access restriction: The type ‘Application’ is not API (restriction on required library rt.jar)
  62. Error: JAVA_HOME is not defined correctly executing maven
  63. Eclipse No tests found using JUnit 5 caused by NoClassDefFoundError for LauncherFactory
  64. 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
  65. Web server failed to start. Port 8080 was already in use. Spring Boot microservice
  66. JAVA_HOME should point to a JDK not a JRE
  67. Eclipse error, “The selection cannot be launched, and there are no recent launches”
  68. Failed to load the JNI shared Library (JDK)
  69. channel 3: open failed: connect failed: Connection refused
  70. Java can’t find file when running through Eclipse
  71. Eclipse java debugging: source not found
  72. java.sql.SQLException: No database selected – why?
  73. No appenders could be found for logger(log4j)?
  74. Syntax error on token(s), misplaced construct(s)
  75. “The public type <> must be defined in its own file” error in Eclipse [duplicate]
  76. Corrupt jar file
  77. Installing WindowBuilder on Eclipse Neon
  78. How to clear console in Java – Eclipse
  79. The import javafx cannot be resolved
  80. How are “mvn clean package” and “mvn clean install” different?
  81. Fatal error compiling: tools.jar not found:
  82. java.lang.VerifyError: Inconsistent stackmap frames at branch target 421
  83. Unreachable code in eclipse
  84. Cannot issue data manipulation statements with executeQuery()
  85. Java project in Eclipse: The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files
  86. How to import a jar in Eclipse
  87. Connection Java – MySQL : Public Key Retrieval is not allowed
  88. Node cannot be resolved to a type
  89. What is the proper annotation since @SpringApplicationConfiguration, @WebIntegration, is deprecated in Spring Boot Framework?
  90. Resource leak: ‘in’ is never closed
  91. Android Emulator: Unfortunately App has stopped
  92. Java console program
  93. implicit super constructor object() is undefined. must explicitly invoke another constructor
  94. Cannot be resolved to a variable error in Eclipse
  95. Using JavaFX in JRE 8, “Access restriction” error
  96. Eclipse Problems View not showing Errors anymore
  97. ‘No JUnit tests found’ in Eclipse
  98. “Cannot be resolved to a type” when attempting to use Scanner
  99. Resolving File paths – ‘File not found’ error in Eclipse
  100. java eclipse red exclamation mark

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)