My program will have several users, but I only want the "administrator" account to be able to change user's passwords. However, I don't want the "administrator" to have access to everything (ala root). What are the minimum global privileges needed for this account to be able to set/modify user's passwords?
Thanks
--Dave
Privileges question
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Privileges question
Do you mean passwords in the OS, for your database, or your application?
(#10850)
Re: Privileges question
I'm referring to mysql privileges. "CREATE USER" is one thing I granted this account, but was unable to drop a client with just this privilege. I also gave it "GRANT" privileges, but that didn't allow the ability to drop users. I ended up giving a TON of privileges, but it makes me a little nervous to have done so.
Hense, the question about the minimum mysql privileges needed to add/drop users.
--Dave
Hense, the question about the minimum mysql privileges needed to add/drop users.
--Dave