Urgent - Password reset in Windows

Hello,

I need to reset the root password for a production database using Mysql
4.1. I tried with the information in the manual (http://dev.mysql.com/
doc/mysql/en/resetting-permissions.html), but when I try to run

mysqld-nt --skip-grant-tables

the server falls and I can't stablish the conection in this way.

Is there any other way to reset the password?
Is ther any way to back up the data in order to reinstall mysql?

Thank you

Andres Marin



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Urgent - Password reset in Windows

On Tuesday, March 08, 2005 18:00, Andres Marin wrote:

> Hello,
>
> I need to reset the root password for a production database using
> Mysql
> 4.1. I tried with the information in the manual (http://dev.mysql.com/
> doc/mysql/en/resetting-permissions.html), but when I try to run
>
> mysqld-nt --skip-grant-tables
>
> the server falls and I can't stablish the conection in this way.

I have had success with the skip-grant-tables in both windows and linux.
I think I have done it once on each. What exactly do you mean when you
say the server falls? It doesn't start at all, or you just can't connect?

> Is there any other way to reset the password?

Yes, but it would require another windows mysql instance running on
different
datadir, or a different machine altogther.

> Is ther any way to back up the data in order to reinstall mysql?

If the tables are all MyISAM tables, you can stop the server, copy
the data directory to another location, uninstall mysql, install mysql,
make sure the server is stopped, copy the data directory back minus the
mysql database, and start the server. You will obviously have to redo
all of your grants.

--
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Urgent - Password reset in Windows

>
>
>Hello,
>
>I need to reset the root password for a production database using
>Mysql
>
>
I had seen some MySQL instaliation on Windows with root's pass writen it
to my.ini in plain text form (MySQL ver. 3.xx). I suggest to try this
first. Maybe this will be quick soliution for you.

--

Best Regards,
Andrej Kudriavcev
CITRUS®

Laisves pr. 60 - 1014, Vilnius
Tel./faks.: +370 5 2305100
Mob. tel.: +370 671 05575
E-mail: andrej@citrus.lt
Web: www.citrus.lt


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Urgent - Password reset in Windows

--=_alternative 00531F5D85256FBF_=
Content-Type: text/plain; charset="US-ASCII"

"Andres Marin" wrote on 03/08/2005 06:59:48
PM:

> Hello,
>
> I need to reset the root password for a production database using Mysql
> 4.1. I tried with the information in the manual (http://dev.mysql.com/
> doc/mysql/en/resetting-permissions.html), but when I try to run
>
> mysqld-nt --skip-grant-tables
>
> the server falls and I can't stablish the conection in this way.
>
> Is there any other way to reset the password?
> Is ther any way to back up the data in order to reinstall mysql?
>
> Thank you
>
> Andres Marin
>
>

You may have to STOP your existing server before you can start it manually
it with --skip-grant-tables (you can use the Services manager to stop it).
Have you checked your *.err log (unless specified elsewhere, it's in your
folder). It may yield a clue why your MySQL server is not
starting.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--=_alternative 00531F5D85256FBF_=--