Re: Automated root password reset on new install

[Todd Farmer]

This error can be caused by one of two factors:

1. The mysql client is older (than 5.6) and doesn't indicate it can handle expired passwords in the capabilities flags.

2. The newer (5.6 or later) mysql client is being used in batch mode, which explicitly disables capability for expired password unless --connect-expired-password is used.

The solution for the first is to ensure you are using a mysql client from version 5.6 or later; the solution to the second is to include the --connect-expired-password option.

http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/