Re: Locked myself out of the mysql database!

[f f]

hi,

1. i have same problem.

SPEC :
winxp sp2 + recent security bug patch.
mysql 4.1.9.

the docs :
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

just doesnt't worked.

<snip>
At the DOS command prompt, execute this command: 
C:\> C:\mysql\bin\mysqld-nt --skip-grant-tables
</snip>

mysql\bin is on my PATH. 
so i use mysqld-nt --skip-grant-tables.

it stops automatically.

i go to mmc and to services panel. and open mysql41
services properties. in commands there is :
mysqld-nt --default-files="path_to_ini_\mysql.ini"
MYSQL41

so i try

mysqld-nt --default-files="path_to_ini_\mysql.ini"
--skip-grant-tables(without any service name).

it runs. however when i execute 
mysqladmin -u root flush-privileges password "newpwd"

mysql complains that it can't find any entry on user
table.

any idea ?

thanks.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com