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


  • 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.


Additional Information

¿Fue útil este artículo?
Usuarios a los que les pareció útil: 0 de 0