Re: Unable to install v8.0.16 - password problem

[Robert Bryce]

Now made three attempts to get out of this catch 22 - see below in case anyone can assist me. If not I do appear to be a train crash!

ATTEMPT 1
Suggestions from Reference Manual
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysqld --init-file=C:\\mysql-init.txt --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data" --console

Result as below - seemed to be a success? but did not terminate back at dos prompt.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --init-file=C:\\mysql-init.txt --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data" --console
2019-07-10T17:59:35.749845Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 12860
2019-07-10T17:59:39.700014Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-07-10T17:59:39.798523Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL.
2019-07-10T17:59:39.869117Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

ATTEMPT 2
Instructions in 'my.ini' state that it should be installed in the Program folder, and not the default Program Data folder
It also states that to manually start the server, type the below
mysqld --defaults-file="C:\\Program Files\\MySQL\\MySQL Server 8.0\\my.ini"

'my.ini' file was moved from Program Data folder to Program folder.
Result - This command just hangs.....

ATTEMPT 3
Tried a combination of the above.
mysqld --defaults-file="C:\\Program Files\\MySQL\\MySQL Server 8.0\\my.ini" --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data" --init-file="C:\\mysql-init.txt" --console

Result as below - seemed to be a success? but did not terminate back to DOS prompt. No sign of running process or services in Windows...

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\\Program Files\\MySQL\\MySQL Server 8.0\\my.ini" --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data" --init-file="C:\\mysql-init.txt" --console
2019-07-10T18:24:02.809526Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-07-10T18:24:02.816612Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 7156
2019-07-10T18:24:05.051227Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2019-07-10T18:24:05.094836Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2019-07-10T18:24:06.344885Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-07-10T18:24:06.457911Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL.
2019-07-10T18:24:06.509177Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

Terminating the DOS session with CTRL-C resulted in statement that mysql had entered Normal Shutdown and had Shutdown.