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