Hi Sol,
I think you can change the startup properties from the services screen.
If you right click on the MySQL service, you can set startup parameters
at the bottom of the first screen. You could set the --skip-grant-tables
there.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: sol beach [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 31 January 2006 12:17 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: How to login to MYSQL as "root" without knowing the
passward
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]> 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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
