Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?

by

I also had the same problem with this but on Windows after upgrading to MySQL 5.5 from MySQL 5.1.
I already tried changing, creating, and resetting password mentioned in here, here, here, and here, no clue. I still get the same error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I’m able to connect normally, show all databases, do selects and inserts, create and add users, and but when it comes to GRANT, I’m screwed up. Those access denied error shows up again.

I managed to solve this problem by fixing the privileges by the following command on the MySQL server bin/ directory as mentioned in here:

C:\MySQL Server 5.5\bin> mysql_upgrade

Then, the problem gone away. I hope this solution works on Linux too since usually MySQL provide the same command both on Linux and Windows.

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 can I restore the MySQL root user’s full privileges?
  5. How to reset mysql root password?
  6. MySQL – ERROR 1045 – Access denied
  7. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  8. access denied for load data infile in MySQL
  9. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  10. Mysql permission errors with ‘load data’
  11. How can I output MySQL query results in CSV format?
  12. Change limit for “Mysql Row size too large”
  13. Converting a date in MySQL from string field
  14. Quick easy way to migrate SQLite3 to MySQL? [closed]
  15. Ordering by specific field value first
  16. CHECK constraint in MySQL is not working
  17. How can I view live MySQL queries?
  18. Is it possible to execute a string in MySQL?
  19. Cannot connect to Database server (mysql workbench)
  20. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  21. connecting to mysql server on another PC in LAN
  22. storing money amounts in mysql
  23. MySQL CREATE FUNCTION Syntax
  24. Difference between two table structure
  25. How to store decimal in MySQL?
  26. When to use a left outer join?
  27. MySQL throws Incorrect string value error
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment