Access denied; you need the SUPER privilege for this operation (no replies)

Submitted by programmer on Sun, 03/09/2008 - 01:14.

This is driving me insane, I do not know where else to look-- I have googled my heart out.

I made some adjustments per the advise of the mysql enterprise monitor (trial) about not allowing my root account "any" host access. Once I removed "any" host access, the system dependent on this database started screaming: "Access denied; you need the SUPER privilege for this operation" nearly every time it tried to do an insert/update (with dupe key) query.

I tried remotely and locally to grant all privileges to root and the default account people connect into with no success. Each time I run a GRANT on any user from any other user it tells me access is denied, but if I say show privileges it shows that the root has all privileges on all databases.

In short, how can I reset my root account's privileges?

Thank you as much as possible in advance,

-Steve

Post your Answer

  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.
  • Links to specified hosts will have a rel="nofollow" added to them.

More information about formatting options