Re: ERROR 1045 (28000): Access denied for user '=root'@'localhost'

[Deborah Bauer]

I was able to get IT at work to give me full access to MySQL directories under Program Files and ProgramData. I had to create a directory called data under


C:\ProgramData\MySQL\MySQL Server 8.0\

for this command to run and give me the error messages I was missing running this command:


mysqld -defaults-file="\C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --skip-grant-tables

These are the error messages I am getting but I have no idea where it needs another data directory of if this is something in the my.ini file that needs to have the comment taken off our updated. Here are the error messages:

2018-06-26T13:54:34.509295Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 7032
2018-06-26T13:54:34.526083Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2018-06-26T13:54:34.527258Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-06-26T13:54:34.528268Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-06-26T13:54:34.529658Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.