How to grant super privilege to mysql database table in my website db

Question

How to grant super privilege to my database to set global. How to grant super privilege? I got an error while granting the privilege .

Access Denied for the 'user'@'localhost'

It means the password you trying with was wrong. http://stackoverflow.com/questions/8621649/access-denied-for-user-localhost-to-database — Sulthan Allaudeen, Mar 26 '14 at 07:35
I'd really, really be interested in why you want to do this... — fancyPants, Mar 26 '14 at 08:10

score 0 · Answer 1 · answered Mar 26 '14 at 12:33

0

You should just execute these queries, make sure that MySQL user who executes these queries has GRANT and SUPER privilege:

CREATE USER 'user'@'%' IDENTIFIED BY 'user_pass'; 

GRANT SUPER ON *.* TO 'user'@'%';

answered Mar 26 '14 at 12:33

Mahesh Patil

1 Answers1