changing mysql root password « Welcome to my World

changing mysql root password

November 7, 2006

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. .

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.
Log in to 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???
Log in to Reply
3. mmg007 | December 21, 2006 at 3:26 am

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

You must be logged in to post a comment.