使用LDAP(AD)为MySQL认证 [英] Using LDAP (AD) for MySQL authentication
问题描述
我试图想出一个计划,允许用户执行授权使用MySQL数据库(很多,实际上)使用LDAP。更具体地,ActiveDirectory的。数据库可能会通过应用程序,而不是web访问。我有什么选择?
I'm trying to come up with a plan to allow users to auth with a MySQL database (many, actually) using LDAP. More specifically, ActiveDirectory. Database will likely be accessed through applications, not web. What are my options?
编辑:
好。似乎没有官方的方式使用LDAP允许在MySQL认证。其他的选择有哪些?我们可以同步LDAP用户和密码到MySQL用户表?
Okay. It seems that there is no "official" way to allow authentication on MySQL using LDAP. What other options exist? Can we synchronize LDAP users and passwords to the MySQL user table?
推荐答案
这是可能的MySQL代理。有你需要知道,使这项工作的几件事情:
this is possible with mysql proxy. there's a few things you need to know to make this work:
- MySQL代理可以执行shell命令
- MySQL代理可以拦截和重写认证
这两个页面将帮助您入门:
these two pages will help you get started:
- 例如运行shell命令: http://forge.mysql.com /tools/tool.php?id=79
- 例如拦截和重写认证: HTTP://jan.kneschke .DE / 2009/6/25 / MySQL的代理,角色
- example of running a shell command: http://forge.mysql.com/tools/tool.php?id=79
- example of intercepting and rewriting authentication: http://jan.kneschke.de/2009/6/25/mysql-proxy-roles
这篇关于使用LDAP(AD)为MySQL认证的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!