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!
As documented under Restrictions on Pluggable Authentication:
The term “native authentication” used here refers to authentication against passwords stored in the
Passwordcolumn of the
mysql.usertable.[ 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
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.