Bug #76536 doc needs changes for password column related in 5.7
Submitted: 31 Mar 2015 3:11 Modified: 31 Mar 2015 14:50
Reporter: Ramana Yeruva Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7.7 OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[31 Mar 2015 3:11] Ramana Yeruva
Instructions are mentioned in the below link to reset the root password if it is lost.

However these steps doesn't work from 5.7.6 where password column removed as part of wl6409.

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

should be changed to 

UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass') WHERE User='root';

How to repeat:
review https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html page and change as necessary 

Suggested fix:
as above
[31 Mar 2015 14:50] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Fixed in mysqldoc rev 42389. Closed.
[1 Apr 2015 21:40] Paul DuBois
Further work on this section:

* Use ALTER USER or SET PASSWORD. No direct update of user table with
  UPDATE, and no reference to columns in which the password is stored.
  This means we don't modify *all* root accounts at once. No biggie,
  the important one is root@localhost, and we now tell the user to
  use a different host name to modify the password for a different root
* Parallel revisions for both Windows and Unix, and for the "generic"
* Update "Program Files" to "ProgramData" one pathname (5.5+)
* Eliminate some wording inconsistencies among subsections that have
  crept in over time.