how to add super privileges to mysql database?

by

You can add super privilege using phpmyadmin:

Go to PHPMYADMIN > privileges > Edit User > Under Administrator tab Click SUPER. > Go

If you want to do it through Console, do like this: 

 mysql> GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';

After executing above code, end it with:

mysql> FLUSH PRIVILEGES;

You should do in on *.* because SUPER is not the privilege that applies just to one database, it’s global.

More Related Contents:

  1. Can we use CONCAT and JOIN together in MySQL? [closed]
  2. MySQL pivot table query with dynamic columns
  3. Finding duplicate values in MySQL
  4. Error installing mysql2: Failed to build gem native extension
  5. How to debug Lock wait timeout exceeded on MySQL?
  6. Retrieving the last record in each group – MySQL
  7. CROSS/OUTER APPLY in MySQL
  8. How to extract two consecutive digits from a text field in MySQL?
  9. Connect By Prior Equivalent for MySQL
  10. MySQL Event Scheduler on a specific time everyday
  11. How do I add a custom CHECK constraint on a MySQL table?
  12. MySql Count cannot show 0 values
  13. How to store uuid as number?
  14. Cannot change column used in a foreign key constraint
  15. How to access a RowDataPacket object
  16. Update row with data from another row in the same table
  17. using (-) dash in mysql table name
  18. MySQL password function
  19. How can I enable MySQL’s slow query log without restarting MySQL?
  20. How to select the most recent set of dated records from a mysql table
  21. MySQL database with unique fields ignored ending spaces
  22. Does MySQL allows to create database with dot?
  23. Selecting multiple columns/fields in MySQL subquery
  24. Set value to NULL in MySQL
  25. How to rearrange MySQL columns?
  26. List of Constraints from MySQL Database
  27. MySQL: Querying for unicode entities
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. How do I extract Month and Year in a MySQL date and compare them?
  30. INSERT INTO fails with node-mysql

Leave a Comment