Using LDAP (AD) for MySQL authentication

mysql authentication active-directory ldap
snicker picture snicker · Aug 25, 2009 · Viewed 48.8k times · Source

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?

EDIT:

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?

Answer

longneck picture longneck · Aug 25, 2009

this is possible with mysql proxy. there's a few things you need to know to make this work:

  • mysql proxy can execute shell commands
  • mysql proxy can intercept and rewrite authentication

these two pages will help you get started:

Related questions

MySQL root access from all hosts

I've installed MySQL server on a remote Ubuntu machine. The root user is defined in the mysql.user table this way: mysql> SELECT host, user, password FROM user WHERE user = 'root'; +------------------+------+-------------------------------------------+ | host | user | password | +------------------+------+…

Read More
Cannot connect to MySQL 4.1+ using old authentication

I'm trying to connect to a mySQL database at http://bluesql.net, but when I try to connect, it gives this error: Connect Error (2000) mysqlnd cannot connect to MySQL 4.1+ using old authentication I've looked into this, and it has to …

Read More
MySQL Check if username and password matches in Database

I have a form which has a textbox with the name attribute username and another one with the name attribute password. I also have a database with columns called user and pass. When my users signed up it added the …

Read More