MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Michael Sabo
January 05, 2024 10:32AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Barry Galbraith
January 08, 2024 12:51AM


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.