Aha, this revealed the .pid: /usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/data/John-Mistlers- Computer.local.pid
Now, this brings up a new question. Is there a "sudo find" command I can use to locate the proper .pid on any given computer? I am hard coding this into an application that will reset the root password to whatever the user enters. How can this be done if I don't know the location of the .pid file ahead of time on their system? Thanks, John P.S. Is the host name in my example "local" or "John-Mistlers-Computer.local"? on 5/22/04 12:01 PM, Hassan Schroeder at [EMAIL PROTECTED] wrote: > John Mistler wrote: > >> I'm having trouble getting this line to work. I have tried: >> >> kill `cat /usr/local/mysql/bin/mysql/data/localhost.pid` >> -> Not a directory >> kill `cat /usr/local/mysql/data/localhost.pid` >> -> Permission denied >> >> I'm not sure if I have the wrong hostname, or if the command is more flawed >> than that. > > Could be both; to start with, though, it should be pretty easy to > confirm exactly where *.pid is, eh? If you're sure that the base > directory is '/usr/local/', run > > sudo find /usr/local -type f -name '*.pid' -print > > and see what turns up. > > Note: On my Powerbook, mysql data files (including .err, .pid) are > located at /sw/var/mysql -- and I think they were installed there > by default, because I'd never have chosen that :-) > > And the file name on my system is the actual hostname'.pid', *not* > just 'localhost.pid', in case that reference is literal... > > HTH! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]