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-man...