1

We have a team of developers who need to access the mysql production server, but they should not have access to the password. I am looking for a mechanism where they can copy the password into the clipboard and paste the password during mysql access. How to achieve this?

3
  • 4
    Could you not create separate accounts for them with access to what they need? That way you can delete their account/remove permissions when their need for access is over?
    – Ryan
    Feb 4, 2013 at 18:36
  • 2
    Yeah, this is what multiple accounts are for in the first place...besides, if you're letting them in you're letting them in, it doesn't matter if they KNOW the password if they can still get in...I don't need the keys to your house if you leave the door unlocked...
    – Shinrai
    Feb 4, 2013 at 18:41
  • 1
    Once it's in their clipboard, they could paste it anywhere they wanted, so your proposed method ultimately wouldn't prevent them from seeing the password.
    – techturtle
    Feb 4, 2013 at 19:30

1 Answer 1

4

Rather than trying to find an unlikely method for sharing a password without sharing the password, create separate user accounts for each person who needs access, giving each his/her own password. Instructions to create and administer MySQL users are available on the MySQL website.

In this way, each person who needs access would have their own account, and this account could be deleted, or privileges removed, when access is no longer needed. This has the added benefit of allowing account-based auditing, so that if something gets screwed up, you can trace it back to the user who made the change.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .