The integration of the AD and MySQL?

Hello!
Due to the fact that some resources only support native authentication through Active Directory and others using MySQL, it is necessary somehow to merge the two database into a single. How to do this if your MySQL database has a new user, it is automatically created in AD and Vice versa?! With this you can offer me as the realization of just Windows and Windows-Linux or Linux only! Please tell me how to do it, without ignore and demagogy!
April 4th 20 at 00:47
2 answers
April 4th 20 at 00:49
As it did for one company, you can take the idea as a basis.
Was a form for the administrator and mailing address, the service was periodically taken these data and registered users in AD. Accordingly, these users appeared on the SharePoint portal.

In principle, MS is a turnkey solution for authentication in the corporate network. You may want to consider
https://docs.microsoft.com/en-us/azure/active-dire...

Another question you need one way or round trip?
@makenna.Seng,
Was a form for the administrator and mailing address, the service was periodically taken these data and registered users in AD. Accordingly, these users appeared on the SharePoint portal.
And how to implement it then?
Another question you need one way or round trip?
The idea is - when a user registers on the website, then they have access to and right of the player and his account appears in AD, RADIUS, LDAP, and MySQL (some services support native LDAP authorization, others have hostility with MySQL). Thus if he buys the maximum Donat "the Maximum possibilities+" that he'll get the full RDP, VNC, SSH, FTP, and Webконсольный access to a stack of servers on your account. All automated! How is it possible to implement?! While admin's management accounts, for convenience, we put in a AD group policy, and RADIUS! - Charley_Aufderhar commented on April 4th 20 at 00:52
@Charley_Aufderhar,

If spike simply by running the command
https://docs.microsoft.com/en-us/powershell/module...

And write TK to implement for you - makenna.Seng commented on April 4th 20 at 00:55
@makenna.Seng,
If spike simply by running the command
How to make the script automatically runs when you create a new MySQL user and all data were transferred to him?
And write TK to implement for you
Already had the issue with TK, but it was removed. I once lay, but the amended version! - Charley_Aufderhar commented on April 4th 20 at 00:58
@Charley_Aufderhar, there are many Methods, but it is better to know where they come from data and not make assumptions without having the overall picture. I will say that it is good to make a trigger to execute an external script, however still need to see your DBMS actually supports it.

And write my contacts are in profile. - makenna.Seng commented on April 4th 20 at 01:01
April 4th 20 at 00:51
Usually for things the Federation is set up, this is a separate issue in IT, where you configure the Federation server, and optionally configure the infrastructure for your needs. In one answer only, and not to explain, but for MS it's ADFS, in the world of Linux is a Shibboleth IDP, there are other commercial systems like OKTA.
Setting times, will get quite flexible and scalable system, which will take over the updating of data in various systems.
@araceli_Grady,
Usually for things the Federation is set up, this is a separate topic in IT
You can read more?
In one answer only, and not to explain, but for MS it's ADFS, in the world of Linux is a Shibboleth IDP, there are other commercial systems like OKTA.
And are there any courses, guides, instructions principle of operation and configuring Federation servers and integration with Apache2, vsFTPd and OpenSSH?!
Setting times, will get quite flexible and scalable system, which will take over the updating of data in various systems.
Well, that's just how it's done?! - Charley_Aufderhar commented on April 4th 20 at 00:54
@Charley_Aufderhar, are you kidding? You asked a question, I gave you a comment-the answer is, the direction in which humanity is stuffed cones - began to develop. I gave you the key words "Identity Provider", "Federation Services", "Relaying party", "ADFS", "OKTA", "Shibboleth IDP". Now you are armed and know which search engine to start your journey of the Jedi in the Federation... - araceli_Grady commented on April 4th 20 at 00:57

Find more questions by tags MySQLSQLActive DirectoryWindows Server