So, I'm trying to find this option and I can't find it in the docs. I need to know if there is a way in MySQL in which every user on the OS is also a User on the dB.

Just to clarify, when using Informix, each user on the OS itself is also capable of running dbacces and ,provided it has enough permissions, select insert and delete from a table. But you never "created" a user in Informix, it's simply part of the OS.

Does MySQL handle that?

  • Something does not happen because you invent stuff, so no, it wont happen. Which can be a good thing. From the security point of view, tying layer 7 users to system users is not the brightest of the ideas. – Rui F Ribeiro Aug 22 '18 at 20:23
  • no, but you could write a script or use Ansible or something to manage local users and database accounts – thrig Aug 22 '18 at 20:35
  • @RuiFRibeiro exactly. I'm trying to implement it to prove q point. I personally think is an awful idea. – Matias Barrios Aug 22 '18 at 20:40
  • It is a concept from the 80s...Nothing prevents you of creating the same users, same password on both sides. – Rui F Ribeiro Aug 22 '18 at 20:42

No, it is not possible. Users in MySQL are stored in the mysql.user table. There is no connection whatsoever between MySQL users and OS users.

However, nothing prevents you from creating a shell script that manages the creation and deletion of users in parallel in the database and the OS.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.