MySQL Forums
Forum List  »  General

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Filipe Silva
Date: March 25, 2021 11:59AM

The error message "Access denied for user 'root'@'localhost' (using password: NO)" tells me that you are trying to connect to local a MySQL server, with user "root" without providing a password. Something like:

$ mysql --user=root --host=localhost

But, as you said before, you can connect to this server if you provide a password, right?

If so, then connect again and run: "SELECT user, host FROM mysql.user;" and paste here the results.

I'd recommend reading this: https://dev.mysql.com/doc/refman/8.0/en/access-control.html

Additionally you can test if you have remote access to MySQL by opening a telnet terminal to its host and port. Just run "telnet [MYSQL_HOST_IP] 3306" (replace the destination IP address accordingly) on the client machine and you should get a terminal successfully connected to MySQL.

Options: ReplyQuote




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.