debian下mysqlserver的一个问题的解决

$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 ' 9eED1oBiSBNbHWgR' WITH GRANT OPTION;
mysql> flush priviledges;

七中’’的就是上面找到的password

然后
$sudo /etc/init.d/mysql restart