Unable to reset MySQL root password and no service running in the background
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>
Subject
Views
Written By
Posted
Unable to reset MySQL root password and no service running in the background
1862
August 26, 2021 09:02AM
710
August 26, 2021 09:16AM
460
August 26, 2021 09:33AM
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.