MySQL Forums
Forum List  »  Newbie

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Michael Sabo
Date: January 05, 2024 10:32AM

Hi

I'm currently trying at MySQL and just logging in seems to be a challenge!?

>mysql -u root
If MySQL itself asks for the password, I can log in as desired.

>mysql -u root -p'xyz'
However, if I enter the password directly on the command line, strangely it doesn't work.
|mysql: [Warning] Using a password on the command line interface can be insecure.
|ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Can anyone explain to me??
Thank you!

PS: I'm using the latest version on Windows, but I have the same behavior on Linux.

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
January 05, 2024 10:32AM


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.