Well under Linux I re-installed apache which overwrote the directory and deleted the pid of a currently running apache!
My workaround was to do: $ netstat -l -t -p as root user from the command line. This gave me the running daemon processes that were listening to tcp ports, and their associated pid numbers. I was then able to stop the running apache with: $ kill 12345, where 12345 was the process number of the apache. There may be a similar command under windows that will enable you to get the PID of the mysql you want to kill. HTH Keith In theory, theory and practice are the same; In practice they are not. On Mon, 30 Jan 2006, Dan Trainor wrote: > To: sol beach <[EMAIL PROTECTED]>, mysql@lists.mysql.com > From: Dan Trainor <[EMAIL PROTECTED]> > Subject: Re: How to login to MYSQL as "root" without knowing the passward > > sol beach wrote: > > Sounds reasonable, but how do I shutdown down MYSQL so I can restart > > with > > --skip-grant-tables > > option? > > > > On 1/30/06, *Dan Trainor* <[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > sol beach wrote: > > > I've been asked to assist the folks who own the data in the > > database, but > > > folks who used to maintain it are no longer with the > > > company. > > > This installation resides on a Windows 2003 server to which > > > I > > have local > > > admin rights. > > > What is the most painless way to get "root" access to this > > > database? > > > I am more than willing to RTFM, if anyone will point me at > > > which > > FM to read. > > > > > > TIA > > > > > > > Hi - > > > > I've always used the startup option of '--skip-grant-tables'. > > This may > > or may not be the "correct" way to do so, but we'll see what kind > > of > > feedback we get. > > > > I do this, then update the Password field in the mysql.user > > table. > > > > HTH > > -dant > > > > > > Hi - > > Stop the service? Kill the process? That's up to you. > > hth > -dant > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
