changing mysql root password

mysqladmin -u root password yournew password

#changing root password

login as root to mysql

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

Entry filed under: MySQL.

3 Comments Add your own

1. Ituloy AngSulong | November 9, 2006 at 5:31 am

Malimit ko ring malimutan yang command na yan. Advantage of keeping blogs, repository ng iba’t ibang ginagawa na nalilimutan minsan.
Reply
2. Dim | November 15, 2006 at 2:40 pm

I cant see root user at MySQL Administrator.
When i try to add a new user i see this message:

Could not Fetch Usernames
Access denied for ‘root’@%’ to database ‘mysql’

any suggestions???
Reply
3. mmg007 | December 21, 2006 at 3:26 am

maybe… u didn’t set your root password yet?
Reply