Linux and MySQL integration?

Question

css

Can you please tell me how to make MySQL database users and UNIX users (Ubuntu users) the same (except root), they have the same names and passwords, and so that when creating a new user in ubuntu, he appears in the database?

Answer 1

Everything is working.

Answer 2

In this case, store users in MySQL, and output them to the system via PAM. Bypass the root somehow, and forward the rest to MySQL. I don’t know, however, whether anyone did this, but users from AD are so easily hooked.

Answer 3

Well, that's the logic. Write a bash script that will take username as parameters; password and execute in turn:
Create newUser
Add newUser to mysql
Naturally, under the hood, you need to think about privileges, groups, and so on.
You can also do the 2nd bash by analogy, only to change the password (so that the house of cards does not collapse, as Adamos said )

Answer 4

Look at
https:
//www.percona.com/doc/percona-server/5.7/man ...
I did not use it myself, but I used the LDAP module - for authentication against active directory.

Answer 5

Have you been banned by your google provider?
https://mariadb.com/kb/en/authentication-plugin-un...