- 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"
- Liferay DXP 7.4
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.
Subscriber Exclusive Content
A Liferay Enterprise Subscription provides access to over 1,500 articles that include best practices, troubleshooting, and other valuable solutions. Sign in for full access.Sign In