Re: Unable to install v8.0.16 - password problem

[Robert Bryce]

Hi Jon,
Thanks for replying.

I just tried the suggestion at section "B.4.3.2.1 Resetting the Root Password: Windows Systems", but I received errors as below....

C:\>cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --init-file=C:\\mysql-init.txt
2019-07-10T15:35:40.319038Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 5060
2019-07-10T15:35:40.329049Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\DESKTOP-M5RT383.lower-test
2019-07-10T15:35:40.329400Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\DESKTOP-M5RT383.lower-test
2019-07-10T15:35:40.330680Z 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)
2019-07-10T15:35:40.358765Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-07-10T15:35:40.359378Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.

Simply running 'mysqld' from the same location produces a similar response.

The second suggestion at this para is to use the 'defaults file'. I located 'my.ini' and ran this script but it just hangs without producing any output. See below.....

Microsoft Windows [Version 10.0.17134.829]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\Bob>cd c:\

c:\>cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file=C:\\mysql-init.txt


Perhaps there is a simpler solution? Windows must be holding onto the initial root password somewhere which is not being cleaned during the uninstall - perhaps a registry key?