Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    145

    Unanswered: Cannot shutdown MySql even with SHUTDOWN privilege

    Hello,
    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.
    GG
    Code:
    On Error Goto Hell
    
    Hell:
        Msgbox("An error occurred, but was sent to Hell. You may continue.")

  2. #2
    Join Date
    Jan 2004
    Posts
    145
    Not sure why but I had to create the user mysql@localhost and everything works. Like I said on my other computer mysql@'%' works fine.
    GG
    Code:
    On Error Goto Hell
    
    Hell:
        Msgbox("An error occurred, but was sent to Hell. You may continue.")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •