Is it possible to grant priviliges to a "no-root-user" to start and/stop/restart the mysql server on a suse machine?
The goal is to make it for a developer possible to tune a mysql server/database and track some error down, which occure while an application corresponds with the mysql server. The server is on a SUSE machine.
At the moment the user is in the group
mysql which grants him access to the logfile in
/var/log/mysqld.log. But after tweaking the
my.cnf he was not able to restart the server. So it seams, that he needs more rights then only beeing in the group
Thanks for any suggestions in advance!
Additional question: Are there more priviliges that should be granted to him to garanty his workflow, while working and administrating the mysql server?