MySQL - Authentication plugin Error: Cannot connect to database

Issue

• MySQL is returning error: Authentication plugin ‘mysql_clear_password’ cannot be loaded: plugin not enabled

  • [INFO] Testing connection

  • [ERROR] Connot connect to the database

Solution

• Solve by setting environment variable

  • Unix: export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1

  • Windows: set LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1

• For more information, refer to: MySQL Bugs: #69587: PAM auth: 'mysql_clear_password' cannot be loaded: plugin not enabled