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.
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, you can't reply to this topic. It has been closed.
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.