Yesterday, I was troubleshooting a user at my host who had lost their MySQL passwords. They had two users in question. After thinking the only choice was to login to root phpmyadmin, dump the dbases, and then have them reimport them with a new user assigned, I came upon a solution. I was searching the internet for a way to reset the MySQL passwords, and luckily, MySQL.Com came to the rescue. Here's the trick.

• Login to SSH/Telnet (I used root. If you have some other user that can globally control MySQL, that will work too.
• Type in mysql and press enter (unless you have some other process name for MySQL)
• At this point, you should be in the MySQL management console
• At the "->" indicator, type in UPDATE mysql.user SET Password=PASSWORD('new_password_choice')
• Press enter
• At the next prompt, type WHERE User='username_to_change_password_for';
• DO NOT FORGET THE FINAL SEMI-COLON
• Then type FLUSH PRIVILEGES; (once again, not forgetting the final semi-colon).

You're done! The password should be reset. Hope this helps someone else at some point.

Good to know, thanks for that tidbit WaHoOoO!

you might want to tag a limit 1 on to the end of your user='username' line there.
When editing the mysql.user table, you don't want to hit enter at the wrong time (2am
while you are trying to restore a lost database).
The line would look like

UPDATE mysql.user SET Password=PASSWORD('new_password_choice') WHERE User='username_to_change_password_for' Limit 1;

~James

Wow this is really nice to know! Great bit of info.

ive been wondering this for a long tim, but what exactly is ssh and telnet? i kinda know what telnet is but whats ssh?

Its secure shell client. Have a read here:

http://www.jtan.com/resources/ssh.html

Cheers
Andy

ssh is basiclly shell that is secure, like your at the command line of a remote machine

If your on winBox you can just use DOS. You should also be using the same command to set your root accounts on a new MySQL server. See...

http://dev.mysql.com/doc/mysql/en/de...rivileges.html

Nice Info