I'm writing a script which weekly updates the users who have access to a database (all users from a specific group in our AD).

In my script I have to authenticate me as an user with the privileges to create users and to grant them privileges.

I dislike using the root user (and his plaintext password!) in a script, so I hope to create a dummyuser with as little as possible privileges, I want to reduce the security risk.

Is there a possible way and will it be secure? Which privileges will this dummyuser need?

  • Please add the script you are using/writing. Feb 8, 2016 at 13:12

1 Answer 1


create a user with grant option privilege.

GRANT [whatever privilege to that normal user] TO 'normal_user'@'ipaddress' WITH GRANT OPTION IDENTIFIED BY 'password'; FLUSH PRIVILEGES;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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