I’m facing difficulties when trying to connect to my local MySQL database. I’ve set it up and started the service through the Windows services interface, but I’m unable to connect without facing errors.
While using MySQL Workbench, I enter localhost as the hostname and root as my username, yet I keep encountering access denied messages. The same thing occurs when I attempt to connect via the command line with mysql.exe -u root -p; even after entering the correct password, I receive an access denied error.
I attempted to run with --skip-grant-tables, but I ended up with a keyring migration error instead. Moreover, when trying to execute mysqld, it gives me a keyring migration failure as well.
Additionally, I specified the path to the configuration file:
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"
Unfortunately, that results in a permission error regarding binlog.index.
I even reinstalled MySQL, but after the reinstall, I still see the keyring migration error and now the service won’t start at all. Has anyone else experienced similar issues with MySQL authentication and keyring migration?