[求助]mysql忘记密码，使用--skip-grant-tables启动后依然提示需要密码

Question

sles10_64:/usr/local/services/mysql-5.0.26/bin # ps aux | grep mysqld
root     14784  0.0  0.0   7980  1496 pts/3    S    11:30   0:00 /bin/sh /usr/local/services/mysql-5.0.26/bin/mysqld_safe --skip-grant-tables
mysql    14821  0.2  4.1 1373056 150964 pts/3  Sl   11:30   0:01 /usr/local/services/mysql-5.0.26/libexec/mysqld --basedir=/usr/local/services/mysql-5.0.26 --datadir=/usr/local/services/mysql-5.0.26/var --user=mysql --pid-file=/usr/local/services/mysql-5.0.26/var/sles10_64_.pid --skip-external-locking --port=3306 --socket=/usr/local/services/mysql-5.0.26/var/mysql.sock
root     16489  0.0  0.0   2744   612 pts/3    S+   11:41   0:00 grep mysqld
sles10_64:/usr/local/services/mysql-5.0.26/bin # mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
sles10_64:/usr/local/services/mysql-5.0.26/bin # 以前都是这种方法直接搞定，网上也是如是攻略。这次不知道那一步没做好

Answer 1

mysql    14821  0.2  4.1 1373056 150964 pts/3  Sl   11:30   0:01 /usr/local/services/mysql-5.0.26/libexec/mysqld --basedir=/usr/local/services/mysql-5.0.26 --datadir=/usr/local/services/mysql-5.0.26/var --user=mysql --pid-file=/usr/local/services/mysql-5.0.26/var/sles10_64_.pid --skip-external-locking --port=3306 --socket=/usr/local/services/mysql-5.0.26/var/mysql.sock你的这个中并没有  --skip-grant-tables 啊，你需要把原来的先停下来。

Answer 2

结贴了，我也不清楚问什么这个命令启动的没这个参数。停是确定停了。
后来是修改了my.cnf 里面加上了这个参数，重启mysql，修改回了密码再去掉就ok了