在ubuntu 13.04(centos6.3中只要有root权限)中,安装mysql后,使用命令登录mysql居然报错了,Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'(using password: YSE),这个错误很常见,需要重新重新设置一个密码,方法如下:
1.先关闭mysql并设置密码
#sudo /etc/init.d/mysql stop
#sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#sudo mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('pas') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
2.重启mysql并尝试登录
#sudo /etc/init.d/mysql restart
#sudo mysql -uroot -p
Enter password:
#输入密码,出现下面这个就表示登录正常了
mysql>
1.先关闭mysql并设置密码
#sudo /etc/init.d/mysql stop
#sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#sudo mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('pas') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
2.重启mysql并尝试登录
#sudo /etc/init.d/mysql restart
#sudo mysql -uroot -p
Enter password:
#输入密码,出现下面这个就表示登录正常了
mysql>