You can do something like this for doing a cross version approach: SELECT /*!50706 authentication_string as */ password FROM mysql.user; I wrote about the r

You can do something like this for doing a cross version approach: SELECT /*!50706 authentication_string as */ password FROM mysql.user; I wrote about the rationale to some of the password changes here: http://www.tocker.ca/2014/09/05/proposed-changes-to-user-management-in-mysql-5-7.html http://www.tocker.ca/2014/09/05/proposed-changes-to-user-man...