ERROR 1044 (42000): Access denied for ‘root’ With All Privileges

by

First, Identify the user you are logged in as:

 select user();
 select current_user();

The result for the first command is what you attempted to login as, the second is what you actually connected as. Confirm that you are logged in as root@localhost in mysql.

Grant_priv to root@localhost. Here is how you can check. 

mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
+-----------+------------------+-------------------------------------------+------------+------------+
| host      | user             | password                                  | Grant_priv | Super_priv |
+-----------+------------------+-------------------------------------------+------------+------------+
| localhost | root             | ***************************************** | N          | Y          |
| localhost | debian-sys-maint | ***************************************** | Y          | Y          |
| localhost | staging          | ***************************************** | N          | N          |
+-----------+------------------+-------------------------------------------+------------+------------+

You can see that the Grant_priv is set to N for root@localhost. This needs to be Y. Below is how to fixed this:

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User="root";
FLUSH PRIVILEGES;
GRANT ALL ON *.* TO 'root'@'localhost';

I logged back in, it was fine.

More Related Contents:

  1. MySQL root password change
  2. NOT LIKE not working with SHOW [duplicate]
  3. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  4. MySQL – Rows to Columns
  5. ROW_NUMBER() in MySQL
  6. How to define a custom ORDER BY order in mySQL
  7. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  8. How to get the number of days of difference between two dates on MySQL?
  9. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  10. conditional join in mysql
  11. How to grant all privileges to root user in MySQL 8.0
  12. MySQL Group by SUM
  13. TRIGGERs that cause INSERTs to fail? Possible?
  14. Mysql query to dynamically convert rows to columns on the basis of two columns
  15. Search for all occurrences of a string in a mysql database [duplicate]
  16. MySQL Aggregate Functions without GROUP BY clause
  17. Count days between two dates, excluding weekends (MySQL only)
  18. MySQL: How do I join same table multiple times?
  19. Difference in minutes from two time fields in MySQL
  20. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  21. Fixing “Lock wait timeout exceeded; try restarting transaction” for a ‘stuck” Mysql table?
  22. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  23. Amazon EC2, mysql aborting start because InnoDB: mmap (x bytes) failed; errno 12
  24. When to use MyISAM and InnoDB? [duplicate]
  25. MySQL my.ini location
  26. Access mysql remote database from command line
  27. the MySQL service on local computer started and then stopped
  28. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  29. Storing images in MySQL [closed]
  30. Would it help to add index to BIGINT column in MySQL?

Leave a Comment