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

2009年12月21日 由 月影鹏鹏 留言 »

$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 ‘password’ WITH GRANT OPTION;
mysql> flush privileges;

七中的就是上面找到的password

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

广告位

留言