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.
Hmm.. how are you doing it? What errors are you receiving?
That should work.. Remember to reload mysql after performing this.Code:shell> mysql -dUSERNAME -p mysql mysql> update user set password=password('password_here') where user='root';
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?
open an MSDOS window and do it from there