MySQL ODBC Connector - How to login to MYSQL as "root" without knowing the passward

Author

How to login to MYSQL as "root" without knowing the passward

sol beach

2006-01-30, 8:24 pm

------ =_Part_15956_2454694
7.1138671273677
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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

------ =_Part_15956_2454694
7.1138671273677--

Dan Trainor

2006-01-30, 8:24 pm

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/mysql? unsub...sie.nctu.edu.tw

sol beach

2006-01-30, 8:24 pm

------ =_Part_16033_2067548
4.1138672003445
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Sounds reasonable, but how do I shutdown down MYSQL so I can restart with
--skip-grant-tables
option?

On 1/30/06, Dan Trainor <dan@id-confirm.com> wrote:
>
> sol beach wrote:
> but
l[color=darkred]
> read.
>
> 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
>

------ =_Part_16033_2067548
4.1138672003445--

Dan Trainor

2006-01-30, 8:24 pm

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* <dan@id-confirm.com
> <mailto:dan@id-confirm.com>> wrote:
>
> sol beach wrote:
> database, but
> have local
> FM to read.
>
> 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/mysql? unsub...sie.nctu.edu.tw

Rob Gormley

2006-01-30, 8:24 pm

Windows 2003 - try 'net stop mysql' from a commandline.

Rob=20

> -----Original Message-----
> From: sol beach [mailto:sol.beach@gmail.com]=20
> Sent: Tuesday, 31 January 2006 12:47 PM
> To: dan@id-confirm.com
> Cc: mysql@lists.mysql.com
> Subject: Re: How to login to MYSQL as "root" without knowing=20
> the passward
>=20
> Sounds reasonable, but how do I shutdown down MYSQL so I can=20
> restart with --skip-grant-tables option?
>=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sweet, Charles E

2006-01-30, 8:24 pm

sol beach <mailto:sol.beach@gmail.com> 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.=20
>=20
> TIA

http://dev.mysql.com/doc/refman/4.1...ermissions.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Logan, David

2006-01-30, 8:24 pm

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=20
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ****** =20
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia=20
i n v e n t =20
---------------------------------------------------------------

-----Original Message-----
From: sol beach [mailto:sol.beach@gmail.com]=20
Sent: Tuesday, 31 January 2006 12:17 PM
To: dan@id-confirm.com
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 <dan@id-confirm.com> wrote:
>
> sol beach wrote:
database,[color=dark
red]
> but
local[color=darkred]

to[color=darkred]
> read.
>
> 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/mysql? unsub...sie.nctu.edu.tw

mysql@karsites.net

2006-01-31, 7:23 am

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 <sol.beach@gmail.com>, mysql@lists.mysql.com
> From: Dan Trainor <dan@id-confirm.com>
> Subject: Re: How to login to MYSQL as "root" without knowing the passward
>
> sol beach wrote:
>
> 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/mysql? unsub...ites
.net
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links