I'm very confused. What prevents anyone from running this without
needing to know the original password:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

where mysql-init.txt:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

This is from the documents.http://dev.mysql.com/doc/refman/5.0/en/
resetting-permissions.html
what am i missing?
I actually tried it and it worked.

Thanks
Mike

On Fri, 21 Dec 2007 17:23:50 -0800 (PST), AMP
<ampeloso@gmail.com> wrote:

>I'm very confused. What prevents anyone from running this without
>needing to know the original password:
>
>C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt
>
> where mysql-init.txt:
>
>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

The only thing people need is a login on that machine.
That's why there are firewalls, login passwords,
restrictions on starting tasks from a webserver, etc.
etc..

>This is from the documents.http://dev.mysql.com/doc/refman/5.0/en/
>resetting-permissions.html
>what am i missing?

You aren't missing anything.
It's something one may sometimes need in the course of
maintaining a database server.

>I actually tried it and it worked.

Perhaps you can Chrisdud911 in the thread 'Resetting
Mysql Command Line root password', Message-ID:
<3ef718eb-0006-404e-9ed7-18b5b21d0f6f@e67g2000hsc.googlegroups.com>



>Thanks
>Mike
--
( Kees
)
c[_] Son, a woman is like a beer. They smell good, they look
good, you'd step over your own mother just to get one!
But you can't stop at one. You wanna drink another
woman! (Homer Simpson) (#457)