I am trying to integrate Sphinx in my Java back-end, using the MySQL Connector/J to connect to it. I’ve basically followed the tutorial from the Sphinx Wiki (http://sphinxsearch.com/wiki/doku.php?id=sphinx_jdbc ) but get the following error: JDBC Connection Failure: CLIENT_PLUGIN_AUTH is required on the line:

conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:9306", "", "");

Sphinx version 3.1.1
MySQL version 8.0.11
Connector/J version 8.0.11

Please note that running everything in the command line works fine (i.e., connecting to sphinx using mysql -P9306 and sending SphinxQL commands). Downgrading JDBC connector would not work since I still need to connect to MySQL 8.

Any help/advice would be greatly appreciated.