We have answer of your question!

100% solved queries, no empty question

Question: Does the MySQL Connector/J JDBC driver support the Windows Native Authentication plugin?


0

Advertisement


I'd like to authenticate users connecting to a MySQL database with their Windows credentials rather then maintaining a separate database password for each user account.

The commercial version of MySQL supports this via the Windows Native Authentication plugin... however it is not clear from the documentation if this form of authentication is supported by the Connector/J JDBC driver.

Experiment suggests that the Windows Native Authentication plugin is not supported by Connector/J... can anyone confirm this, or better still demonstrate that it does work!

Question author Jon-iles | Source

Answer


1


Advertisement


As documented under Restrictions on Pluggable Authentication:

The term “native authentication” used here refers to authentication against passwords stored in the Password column of the mysql.user table.

[ deletia ]

General Pluggable Authentication Restrictions

[ deletia ]
  • Connector/J: Clients that use this connector can connect to the server only through accounts that use native authentication.

Note that the documentation goes on to point out that Connector/ODBC can use Windows authentication, so perhaps you can use a JDBC-ODBC bridge?

Answer author Eggyal

Advertisement


Tickanswer.com is providing the only single recommended solution of the question Does the MySQL Connector/J JDBC driver support the Windows Native Authentication plugin? under the categories i.e mysql , jdbc , . Our team of experts filter the best solution for you.

Related Search Queries:

You may also add your answer!