为Mysql root 账户设置密码

方法一：（已验证）命令行下输入
[code]
mysql -u root


SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
[/code]


方法二：用mysqladmin
[code]
mysqladmin -u root password "newpass"
[/code]


如果root已经设置过密码，采用如下方法
[code]
mysqladmin -u root password oldpass "newpass"
[/code]


方法三： 用UPDATE直接编辑user表
[code]
mysql -u root


use mysql;


UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';


FLUSH PRIVILEGES;
[/code]


在丢失root密码的时候，可以这样


[code]
mysqld_safe --skip-grant-tables &
mysql -u root mysql
UPDATE user SET password=PASSWORD("new password") WHERE user='root';


FLUSH PRIVILEGES;
[/code]