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:
