MySQL Forums
Forum List  »  Newbie

Re: How do I fix error 1045
Posted by: hamid jon
Date: December 05, 2023 11:14PM

The error 1045 "Access denied for root@localhost (using password yes)" occurs because the root user does not have the GRANT privilege. To fix this, you can grant the GRANT privilege to the root user by executing the following statement:

GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION;

This will grant the root user all privileges on all databases, including the ability to grant privileges to other users.

Options: ReplyQuote


Subject
Written By
Posted
November 01, 2023 07:39AM
November 01, 2023 03:06PM
Re: How do I fix error 1045
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.