MaxScale won't work on MySQL 5.7 due to missing password column in mysql.user table

While MySQL 5.7 is not GA (and therefore officially released yet) it is expected to come out in the next couple of months. The current release is marked as rc "release candidate" which seems to indicate this.

One of the changes in MySQL 5.7 are grant privileges and related to that are changes to the mysql.user table. The password column has been removed and "replaced" by the authentication_string column.

Given the MaxScale code currently explicitly looks at the password column any attempt to do this on a MySQL 5.7 server is going to fail.

This JIRA ticket is really to record this issue so it can be dealt with in due course and before 5.7 goes GA when this will affect users of MaxScale.

This improvement request is to adjust MaxScale so it will work with MySQL 5.7.