Unable to reset MySQL root password and no service running in the background
Posted by: Anjanesh Lekshminarayanan
Date: August 26, 2021 09:02AM

I had MySQL before but I didn't use it as I switched over to VirtualBox Ubuntu.
Today, I uninstalled MySQL 8 on my Windowsand downloaded the MSI online and tried re-installing it. But at the config level it's asking for the current root password which I don't know.

I don't see a MySQL service in services.msc to stop it.
So I thought its not there but it looks like it is ?

PS C:\Program Files\MySQL\MySQL Server 8.0\bin> .\mysqld.exe --user=root --skip-grant-table
2021-08-26T14:59:42.038272Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.26) starting as process 16284
2021-08-26T14:59:42.040872Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2021-08-26T14:59:42.040995Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2021-08-26T14:59:42.041188Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2021-08-26T14:59:42.042021Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-08-26T14:59:42.042164Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.26) MySQL Community Server - GPL.
PS C:\Program Files\MySQL\MySQL Server 8.0\bin>

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to reset MySQL root password and no service running in the background
1583
August 26, 2021 09:02AM


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.