修改MySQL中一個用戶的密碼

#在控制台上輸入
bash$ mysql -u root MySQL
#用MySQL客戶程序
MySQL＞ UPDATE user SET password=PASSWORD("new passWord") WHERE user='hunte';
MySQL＞ FLUSH PRIVILEGES;
MySQL＞ QUIT
＜＜＜

＞＞＞
#在控制台上輸入
bash$ mysql -u root MySQL
MySQL＞ SET PASSWORD FOR hunte=PASSWORD('new passWord');
MySQL＞ QUIT
＜＜＜

＞＞＞
#直接在控制台上輸入
bash$ MySQLadmin -u root "old password" "new passWord"