'How do I configure IntelliJ IDEA to use clear-text password authentication for a MySQL data source?

I've tried a few different ways of defining my MySQL database connection in IntelliJ, but can't seem to connect.

Requirements:

  • Uses an SSH proxy server
  • Needs the password sent in clear text.

My understanding is that the MySQL driver should have a built in plugin for this, called mysql_clear_password, and that I should be able to enable it on the Advanced tab of the database configuration by declaring its classname (com.mysql.jdbc.authentication.MysqlClearPasswordPlugin) and/or setting the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN variable to 1, Y or y.

I can't seem to get it to work. Can someone provide guidance on the correct way to do this in the IDE?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source