Restart mysql within php browser, permissions issue?

Question

I would like to create a button on my website that restarts mysql (I realize this is really bad news). I am using ec2 which has really strict user permissions.

This is my php code, but it's not restarting the session.

<?php
if(isset($_POST['mysql'])){
    exec("sudo /etc/init.d/mysqld restart");
}
?>

<form method="POST" action="">
<input type="submit" value="mysql" name="mysql">
</form>

This is my suders file ...

Cmnd_Alias RESTART_MYSQL  = /etc/init.d/mysqld restart
mysql ALL =NOPASSWD: RESTART_MYSQL

This doesn't work either...

Cmnd_Alias RESTART_MYSQL  = /etc/init.d/mysqld restart
apache ALL =NOPASSWD: RESTART_MYSQL

Your sudoers file specifies that the `mysql` user has permissions to restart the command. Your PHP script will not be running as the `mysql` user. — Michael Mior, May 14 '12 at 18:04
what is your real pronlem? may you can just cut connections by "KILL"? — Moshe L, May 14 '12 at 18:10
look at http://stackoverflow.com/questions/3173201/sudo-in-php-exec — Sbls, Jan 03 '14 at 19:18

score 1 · Answer 1 · answered Jan 03 '14 at 18:52

1

When you run sudo, you need to enter your password. SO, you can't use sudo in a script.

answered Jan 03 '14 at 18:52

Marjeta

1,111
10
26

Restart mysql within php browser, permissions issue?

1 Answers1

Linked