MySQL Forums
Forum List  »  Newbie

How do I fix error 1045
Posted by: Martin McGlensey
Date: November 01, 2023 07:39AM

How do I fix error 1045 "Access denied for root@localhost (using password yes).

Error ocurrs when I execute the statement GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION;

It appears that root cannot grant privileges to any user. root does not appear to have GRANT privilege.

I'm using MySQL 8 on Linux Mint. I can log in to mysql OK.


Options: ReplyQuote

Written By
How do I fix error 1045
November 01, 2023 07:39AM
November 01, 2023 03:06PM
December 05, 2023 11:14PM
November 03, 2023 07:32AM
November 03, 2023 09:26AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.