Liferay is unable to configure MySQL because of to an authentication error

Issue

• The issue of being unable to load authentication occurs while configuring the MySQL database with Liferay:

  java.sql.SQLException: Unable to load authentication plugin "caching_sha2_password"

Environment

• Liferay DXP 7.4

Resolution

• To overcome this issue, run the MySQL command below:

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

  • Replace 'password' in the above line with the initial password used to connect to MySQL.

 

Additional Information

• MySQL Reference Manual