Bug #81959 mysqlfailover looking for non-existent user.password column in mysql 5.7
Submitted: 21 Jun 2016 19:32 Modified: 21 Jul 2016 23:10
Reporter: Aaron Lager Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Utilities Severity:S2 (Serious)
Version:1.6.1 OS:Ubuntu
Assigned to: CPU Architecture:Any
Tags: mysqlfailover, password, utilities

[21 Jun 2016 19:32] Aaron Lager
Trying to use mysqlfailover 1.6.1 with mysql server 5.7.12, no matter what combination of parameters I've tried, and permissions settings in the server, I keep getting:
# Checking privileges.
ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'

Looking at this post here: http://datacharmer.blogspot.com/2015/07/mysql-57-no-more-password-column.html
It would appear that the utilities need to be updated to match the server.

How to repeat:
1) install mysql server 5.7.12
2) install mysql utilites 1.6
3) $mysqlfailover --master=root:myrootpassword@localhost --discover-slaves-login=root

Suggested fix:
change utility to be server version aware, so that it knows if it should use the user.'password' column or the user.'authentication_string' column
[21 Jun 2016 23:10] MySQL Verification Team
Duplicate/related to https://bugs.mysql.com/bug.php?id=81326.
[22 Jul 2016 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".