I've just installed a copy of MySQL 5.7 for testing, and I love the fact that it now only creates a single root account, and puts the password into a file called .mysql_secret.
There's just one problem. Where can I find the above mentioned file. On Linux it is apparently found in $HOME, but my test DB is on Windows.
I tried various places including %USERPROFILE% but I just can't find it anywhere!!
Can anyone please tell me where to find this file? As otherwise my testing will be over before it has begun.