RE: having trouble killing mysqld to restart and change root - JP Audette - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRE: having trouble killing mysqld to ...

From	Sent On	Attachments
JP Audette	06 Feb 2002 13:42
JP Audette	06 Feb 2002 13:58
Victoria Reznichenko	07 Feb 2002 05:07
Victoria Reznichenko	07 Feb 2002 05:07

Subject:	RE: having trouble killing mysqld to restart and change root
From:	JP Audette (jp...@listfish.com)
Date:	02/06/2002 01:58:27 PM
List:	com.mysql.lists.mysql

Amendment to that last post....

I don't think the daemon is starting properly, because I can't run a mysqladmin version - I just get a hung cursor.

Does anyone know if there's something that would be stopping mysqld from loading with the --skip-grant-tables option? When I do a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to.

Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables & option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql

Anyone know why I can't get the monitor started?

At 03:20 PM 2/6/2002 -0600, you wrote:

If you need to, use the "kill -9 <pid>

-9 is a definite kill and it will work

-----Original Message----- From: JP Audette [mailto:jp...@listfish.com] Sent: Wednesday, February 06, 2002 2:52 PM To: mys...@lists.mysql.com Subject: having trouble killing mysqld to restart and change root password

Howdy,

I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command...

kill 'cat /var/lib/mysql/mysqld.pid'

...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes...

643 ? S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ? S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ? S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ? S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid -

I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option.

Can someone help me understand which of the pid's is the actual one, and how I can kill it?

Thanks, JP

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-Gary.Every=ingr...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jp=list...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-cyon=best...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php