MySQL密码修改

MySQL用户密码修改
mysql> alter user root@‘localhost‘ identified by ‘123‘;
mysql> flush privileges;

mysql> set password for root@‘localhost‘ = password("123");
mysql> flush privileges;

mysql> update user set password=password("123") where user="root" and host="localhost";
mysql> flush privileges;


[root@mysql-db01 ~]# mysqladmin -uroot -p123456 password 123