日期:2014-05-16  浏览次数:20912 次

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: