debian下mysql server的一个问题的解决

如果出现

$sudo /etc/init.d/mysql start
Starting MySQL database server: mysqld . . ..
Checking for corrupt, not cleanly closed and upgrade needing tables..
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

那么这时候可以去/etc/mysql/debian.cnf,找到里面的password

然后登录到mysql shell:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
mysql> flush priviledges;

七中的就是上面找到的password

然后
$sudo /etc/init.d/mysql restart
看看：）