更改-设置MySQL用户密码

管理给自己设置密码

> mysql -u root

mysql> SET PASSWORD = PASSWORD('123456');

管理员或者有全局权限的用户重设其它用户的密码

方法一

> mysql -u root -p

mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='username';
mysql> FLUSH PRIVILEGES;
mysql> exit

方法二

> mysql -u root -p

mysql> use mysql; 
mysql> SET PASSWORD FOR username=PASSWORD('new password');
mysql> exit

方法三

mysqladmin -u root "old password" "new password"