Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
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 '13 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 '13 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 '13 at 19:30
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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