方法1:用SET PASSWORD命令
# mysql -u root
# mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
# mysql> flush privileges;
方法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;