Unanswered: Cannot shutdown MySql even with SHUTDOWN privilege
I have a user mysql@'%' that has the SHUTDOWN privilege granted. When I try to use mysqladmin shutdown -u mysql I get an error saying access denied. You must have the SHUTDOWN privilege. I've flushed privileges, restarted the server and still cannot get this to work. I have what seems to be the same setup on another computer and it works fine. In both cases I have user mysql@'%' and when using SHOW GRANTS FOR mysql@'%'; I get GRANT SHUTDOWN ON *.* TO mysql@'%'. I cannot figure out why it will not work on the one instance.
On Error Goto Hell
Msgbox("An error occurred, but was sent to Hell. You may continue.")