Changing MySQL user passwords

[WALoeIII]

How do I change the password for the root user on MySQL? I know how to change it for other people and users I add, but I'd like to change the root password on my devlopment machine.

[cupid]

Hmm.. how are you doing it? What errors are you receiving?

shell> mysql -dUSERNAME -p mysql
mysql> update user set password=password('password_here') where user='root';

That should work.. Remember to reload mysql after performing this.

[freakysid]

Or use the mysqladmin program:

mysqladmin -u root -p password NEWPASSWORD

Next you will be prompted for the OLD password. Enter it - and you should be done.

[WALoeIII]

Well thats all and good, it works, but I forgot to mention that I can't get to the command prompt, I'm trying to change it on my local computer, with apache/php/mysql installed on my windows 2000. I tried to telnet into localhost but I was denied a conection, how do I get in to change this?

[prequel]

open an MSDOS window and do it from there