æ¹æ³1ï¼ ç¨SET PASSWORDå½ä»¤
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
æ¹æ³2ï¼ç¨mysqladmin
mysqladmin -u root password "newpass"
å¦ærootå·²ç»è®¾ç½®è¿å¯ç ï¼éç¨å¦ä¸æ¹æ³
mysqladmin -u root password oldpass "newpass"
æ¹æ³3ï¼ ç¨UPDATEç´æ¥ç¼è¾user表
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
å¨ä¸¢å¤±rootå¯ç çæ¶åï¼å¯ä»¥è¿æ ·
mysqld_safe --skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
mysql> FLUSH PRIVILEGES;
温馨提示:答案为网友推荐,仅供参考