Bug #76792 Password hard to find after MySQL install using dmg on OS X
Submitted: 22 Apr 2015 14:52 Modified: 4 May 2015 12:26
Reporter: Tom Krouper Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.7.7 OS:MacOS (10.10.3)
Assigned to: CPU Architecture:Any
Tags: mac, password

[22 Apr 2015 14:52] Tom Krouper
Description:
After installing MySQL using the .dmg file for my Mac box, I was unable to find the password for the root user.

During the install process I didn't see any mention of the password being set. I looked in the $HOST.err file, I looked for a ~/.mysql_secret file (which I believe is depreciated) and was unable to find the password anywhere.

Eventually, with some help, I was able to find that the password ended up in the Mac install.log. This was not easy to find and I would guess that most people would give up once they couldn't log in or find a password.

How to repeat:
Run a fresh install using the DMG file.

Suggested fix:
Either move the password into the error log, back into .mysql_secret file or update the documentation with explicit directions on how to retrieve the password. Another idea would be to show the password as part of the install process of the DMG.
[22 Apr 2015 16:51] MySQL Verification Team
Thank you for the bug report. Verified as described.
[4 May 2015 9:10] Daniel Fischer
Posted by developer:
 
Future builds of the MySQL 5.7 installer package for Mac OS X will display the randomly generated password during installation in a dialog window instead of hiding it in the installer log file.

Note: Random passwords are only generated for new installations of MySQL 5.7.
[4 May 2015 12:26] Paul DuBois
Noted in 5.7.8 changelog.

For MySQL install operations on OS X from DMG packages, if a a random 
root account password is generated, it now is displayed in a dialog
box.
[22 Apr 2017 8:49] Zhuoli Shen
I accidentally missed that dialog with a brand new installation, is there any place I can get back that password set for the root?