password

[bob lambert]

Help

I have loaded mysql as part of xampp package. I think I did a bad thing, I set my mysql (grant table) user passwords using phpmyadmin. Now I cannot get into mysql and could not reset password.

if I did not set password using mysqladmin, am I in big trouble ?

I think I know what my pw should be but it does not work ! Is that because it did not get encrypted ? Following did not work to reset it :

in 1 console window
mysqld-nt --skip-grant-tables

in another:
mysqladmin -u root flush-privileges password "newpwd"

causes following:
mysqladmin: connect to server at 'localhost' failed
error 'Access denied for user: 'root@localhos' (Using password: YES)'


Thanks
Bob