AD and MySQL integration?

Question

MySQL

Hello!
Due to the fact that some resources natively support only authentication through Active Directory, while others - through MySQL, you need to somehow combine the two databases into a single one. How to do if a new user appeared in the MySQL database, then it was automatically created in AD and vice versa?! At the same time, you can offer me both the implementation of only Windows, and Windows-Linux, or only Linux! Tell me, please, how to do this, without ignoring and demagogy!

Answer 1

As I did for one company, you can take the idea as a basis.
There was a form for the administrator and a mailing address, the service periodically collected this data and registered users in AD. Accordingly, these users appeared on the SharePoint portal.
In principle, MS has a ready-made solution for authentication in a corporate network. Might be worth considering
https://docs.microsoft.com/en-us/azure/active-dire...
Another question do you need one way or both?

Answer 2

Usually federation is set up for such things, this is a separate topic in IT, where you configure the federation server and further configure the infrastructure for your tasks. It’s impossible to explain everything in one answer, but for MS it’s ADFS, in the Linux world it’s Shibboleth IDP, there are other commercial systems like OKTA.
Having set it up once, you will get a fairly flexible and scalable system - which will take over the actualization of data in various systems.