MySQL修改root密码的三种方法

shell>mysqladmin -u root password new_password;

mysql>SET PASSWORD FOR root=PASSWORD(‘new_password’);

mysql>UPDATE user SET Password=PASSWORD(‘new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;