ROR:Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'

编辑器加载中...Ubuntu8.04刚装了mysql sudo apt-get install mysql 安装成功了,安装最后要求输入了密码,也输入了,OK mysql -uroot -p 输入设置的密码 竟然报错了! ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YSE) 问朋友,他说初始密码是空的,可我命名设置了密码的阿。 密码留空 还是错误! ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 于是重改密码! # /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; mysql> FLUSH PRIVILEGES; mysql> quit # /etc/init.d/mysqld restart # mysql -uroot -p Enter password: mysql> 搞定!
posted @ 2011-11-27 21:37  崔晓东  阅读(573)  评论(0编辑  收藏  举报