DelphiFAQ Home Search:

How to reset the root password on mysql

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

I need to reset the root password of my mysql installation to the original empty password. How can I do that?

Answer:

Use the commandline tool mysqladmin - the trick is to use quotes to specify an empty password:

# go to your mysql installation

cd /usr/local/mysql/bin

# replace XXX with your existing root password
./mysqladmin -uroot -pXXX password ''

Comments:

2007-02-27, 12:01:35
anonymous from Portugal  
Wrong, this won't reset it, it will change it, which is very different.

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: