MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user '=root'@'localhost'
Posted by: Deborah Bauer
Date: June 25, 2018 11:36AM

Yes, Windows 10 Pro



You installed what version of MySQL? Ver8 - the most current

Using the MySQL Windows installer? Yes for both Workbench & SQL

Did it give you any error messages? No


is the MySQL service running, ie is it listed as running in services.msc? Yes, it is running and I have stopped and started it many times with no errors.


I have tried


MySQL -u=root


MySQL -u=root -p


mysqld -defaults-file="full_path_to_my.ini" -skip-grant-tables


Nothing works, I just get the error message given in the subject. If I do not have the -skip-grant-tables in the my.ini the Workbench program will not even open.

I will take out the skip-grant-tables from the my.ini and try again the

mysqld -defaults-file="full_path_to_my.ini" -skip-grant-tables


again tonight as another test but I know I have done that as well.


I apologize, I do not know the terminology for all the commands. I thought the MySQL.exe was the command line program for MySQL, my error. I am new to MySQL and trying to figure this out.

Options: ReplyQuote




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.