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? JP 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:[EMAIL PROTECTED]] >Sent: Wednesday, February 06, 2002 2:52 PM >To: [EMAIL PROTECTED] >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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >--------------------------------------------------------------------- >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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php