ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
Subject:   This should work...
Date:   2003-10-04 21:19:26
From:   anonymous2
Response to: didn't work for me...

First log into mysql, for me it's:

sudo /usr/local/mysql/bin/mysql -p

first you will be asked to enter your admin password, the one you use to install software. next you enter the current mysql root password.
Then to change your password, enter:

SET PASSWORD FOR root@localhost=PASSWORD('new_password');

Where new_password is your new password...