http://blog.163.com/wmkq_cq/blog/static/1695823642011258630270/
//MySQL 5.1.49-3
//Debian 6.0.0
无法停止mysql数据库。报错如下:
#service mysql stop通过MySQL Administrator关闭也不行也不行,提示密码错误。
Stopping MySQL database server: mysqld failed!
启动时也报错:
# service mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
原因应该是我修改了debian-sys-maint密码。
解决方法:
cat /etc/mysql/debian.cnf
得到password(假定是 LsEFGL6fx2Je5AmZ )
然后在MySQL Qery Browser里执行:
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'LsEFGL6fx2Je5AmZ' WITH GRANT OPTION;
原帖 解决Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
---------------------------------------- 1.DONE--------------------------------------------
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql -uroot -p死活登陆不了,网上的方法也看得差不多了,还是没有解决问题。
最后我用debian-sys-maint登陆进去才发现 user里面根本就没有root用户……作为apt-get懒人表示这TM太坑爹了!
解决思路:用debian-sys-maint登陆进去,插一个root用户。
mysql -u debian-sys-maint -p
Password: //这里输入/etc/mysql/debian.cnf的密码
mysql>use mysql;
mysql>INSERT INTO user VALUES('localhost','root',PASSWORD('abc123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected, 5 warnings (0.00 sec)
//这样处理后我用root:abc123还是登陆不了。
//于是再执行下面
mysql>update user set password=PASSWORD("abc123")where user="root";
mysql>flush privileges;
mysql>\q
bye
# mysql -uroot -p
---------------------------------------- 2.DONE--------------------------------------------