> 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?
If you have to forcibly terminate mysql, you might want to
run some integrity checks to make sure nothing's broken. This
-might- be hanging your mysql client.
Shut the server down, run myisamchk /var/lib/mysql/*.MYI
and then restart it and try reconnecting.
NOTE: The actual check command may vary depending on
the MySQL version.
> >If you need to, use the "kill -9 <pid>
> >
> >-9 is a definite kill and it will work
> >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?
--
Michael Bacarella | 545 Eighth Ave #401
| New York, NY 10018
Systems Analysis & Support | [EMAIL PROTECTED]
Managed Services | 212 946-1038
---------------------------------------------------------------------
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
