请使用以下两种方法之一
其一:
mysql> SET PASSWORD FOR
-> ‘’some_user’’@’’some_host’’ =OLD_PASSWORD(‘’newpwd’’);
其二:
mysql> UPDATE mysql.user SET Password =OLD_PASSWORD(‘’newpwd’’)
-> WHERE Host = ‘’some_host’’ AND User =’’some_user’’;
mysql> FLUSH PRIVILEGES;