mysql 登录问题

新项目使用mysql ，在linux上安装之后使用，总是出现 Access denied for user 'root'@'localhost' 的问题，查了一圈，终于找到解决方法，如下：

# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# /etc/init.d/mysql start
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> grant all on *.* to 'root'@'localhost' identified by '123456';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: