MySQL Forums
Forum List  »  Install & Repo

MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Austin Wardy
Date: October 29, 2018 03:09AM

Error MySQL ERROR 1045 (28000): Access denied for user When I connected to a remote MySQL, I encountered the MySQL database because of my lack of access to the MySQL database, I first logged in to root MySQL to solve the above error.
PHP code:
MySQL -u root -p
Then I created an austinwardy user in the MySQL database using the following command:
PHP code:
CREATE USER 'austinwardy' @ '%' IDENTIFIED BY 'passport';
Using the following command, you can grant full access to the austinwardy user.
PHP code:
grant all privileges is *. * to 'austinwardy' @ '%' with grant option;
You can then connect to a remote or remote keyless device with a new one. Of course, you can instead open root access to connect to the database, which is not recommended for security reasons.

the source is:

Hope this helps.

Austin Wardy

Options: ReplyQuote

Written By
MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
October 29, 2018 03:09AM

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.