How can I restore the MySQL root user’s full privileges?

by

If the GRANT ALL doesn’t work, try:

  1. Stop mysqld and restart it with the --skip-grant-tables option.
  2. Connect to the mysqld server with just: mysql (i.e. no -p option, and username may not be required).

  3. Issue the following commands in the mysql client:

    UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User="root";

    FLUSH PRIVILEGES;

After that, you should be able to run GRANT ALL ON *.* TO 'root'@'localhost'; and have it work.

More Related Contents:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  3. brew install mysql on macOS
  4. How to reset mysql root password?
  5. MySQL – ERROR 1045 – Access denied
  6. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  7. How to start MySQL with –skip-grant-tables?
  8. MySQL grant all privileges to database except one table
  9. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  10. access denied for load data infile in MySQL
  11. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  12. Mysql permission errors with ‘load data’
  13. I can not find my.cnf on my windows computer [duplicate]
  14. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  15. How do I find the MySQL my.cnf location
  16. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  17. MySQL select one column DISTINCT, with corresponding other columns
  18. Difference between two dates in MySQL
  19. How to remove accents in MySQL?
  20. MySQL search and replace some text in a field
  21. Why is MySQL InnoDB insert so slow?
  22. Group mysql query by 15 min intervals
  23. MySQL – force not to use cache for testing speed of query
  24. MySQL FULL JOIN?
  25. Using Count to find the number of occurrences
  26. MYSQL select DISTINCT values in two columns
  27. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  28. How can I achieve initcap functionality in MySQL?
  29. MySQL errorno 121
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment