Re: Reset MySQL root password

[Barry Galbraith]

>1) UPDATE mysql.user SET Password=PASSWORD('newpd') WHERE User='root';
FLUSH PRIVILEGES;


Eh!?
How did you do that if you can't login?

>C:\mysql\bin>mysql -u -passord -p

You've made a mess with the commandline arguments.

Try
C:\mysql\bin>mysql -uroot -p

Good luck,
Barry.