From dbba36e0b84a62573be7422d3d863cfb0a1d6af0 Mon Sep 17 00:00:00 2001 From: harish095 Date: Tue, 17 Mar 2015 08:19:39 +0530 Subject: MySQL 5.7 Syntax for password change Signed-off-by: Harish Kandala Updated the If condition Signed-off-by: Harish Kandala --- user_password.php | 21 ++++++++++++++++----- 1 file changed, 16 insertions(+), 5 deletions(-) (limited to 'user_password.php') diff --git a/user_password.php b/user_password.php index c9313fc500..44dbc37637 100644 --- a/user_password.php +++ b/user_password.php @@ -131,8 +131,13 @@ function PMA_changePassword($password, $message, $change_password_message) global $auth_plugin; $hashing_function = PMA_changePassHashingFunction(); - $sql_query = 'SET password = ' - . (($password == '') ? '\'\'' : $hashing_function . '(\'***\')'); + if (PMA_Util::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION >= 50706) { + $sql_query = 'ALTER USER USER() IDENTIFIED BY ' + . (($password == '') ? '\'\'' : '\'***\''); + } else { + $sql_query = 'SET password = ' + . (($password == '') ? '\'\'' : $hashing_function . '(\'***\')'); + } PMA_changePassUrlParamsAndSubmitQuery( $password, $sql_query, $hashing_function ); @@ -170,9 +175,15 @@ function PMA_changePassUrlParamsAndSubmitQuery( $password, $sql_query, $hashing_function ) { $err_url = 'user_password.php' . PMA_URL_getCommon(); - $local_query = 'SET password = ' . (($password == '') - ? '\'\'' - : $hashing_function . '(\'' . PMA_Util::sqlAddSlashes($password) . '\')'); + if (PMA_Util::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION >= 50706) { + $local_query = 'ALTER USER USER() IDENTIFIED BY ' . (($password == '') + ? '\'\'' + : '\'' . PMA_Util::sqlAddSlashes($password) . '\''); + } else { + $local_query = 'SET password = ' . (($password == '') + ? '\'\'' + : $hashing_function . '(\'' . PMA_Util::sqlAddSlashes($password) . '\')'); + } if (! @$GLOBALS['dbi']->tryQuery($local_query)) { PMA_Util::mysqlDie($GLOBALS['dbi']->getError(), $sql_query, false, $err_url); } -- cgit v1.2.3