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

This Comment will be submitted for moderation and will not be accessible to other users until it has been approved.
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 Comment

  • 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 <% ... %>.