MySQL Forums
Forum List  »  Install & Repo

Re: Reset MySQL root password
Posted by: Barry Galbraith
Date: April 01, 2012 05:19PM

Follow all the steps in http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html exactly.

Read all the user comments down below the article. There is a comment I wrote on resetting root password for Windows
Quote
Barry said
When resetting root password in Windows, if you start the server with
>mysqld --defaults-file="c:\mysql\my.ini" --init-file=c:\\init.txt
the command will start the server, but not return to a prompt. It will appear to lock up.

Better to use

>start mysqld --defaults-file="c:\mysql\my.ini" --init-file=c:\\init.txt

It opens a new window, starts mysqld, the new window will close, and return to a prompt.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
April 01, 2012 03:58PM
Re: Reset MySQL root password
April 01, 2012 05:19PM
April 01, 2012 09:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.