asked on

How to reset MySQL 5.1 password on Window Operating system?

Hi,
I am trying to reset MySQL 5.1 password using same method shown here http://downloads.mysql.com/docs/mysql-windows-excerpt-5.1-en.pdf\

but when i type
C:\>C:Program Files\MySQL\MySQL Server 5.1\bin\mysqld --init-file=C:\mysql-init.txt
on the command line, it gives me n error:

'C:Program' is not recognized as an internal or external command, operable program or batch file..

What am i doing wrong? Can i reset the password by reinstalling MySQL?

irf44z

Enclose the path&command within double quotes:

C:\>"C:Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --init-file=C:\mysql-init.txt

in DOS, if a folder contains spaces, you need to enclose the whole path in double quotes.

I hope you've verified that MYSQL is installed in C:Program Files\MySQL\MySQL Server 5.1 in your computer.

spamster

and you probably need a slash "\" between C: and Program

"C:\program files\MySQL\MySQL Server 5.1\bin\mysqld"

James_2424

ASKER

Hi,

thanks for helping..

I have tried both of the methods but was unsuccessful. I am attaching an image maybe this will help a bit.

mysqlErrorHelp.JPG

James_2424

ASKER

tried this method too since I used a wizard to install mysql
mysqlErrorHelp2..JPG

irf44z

Thanks, spamster, I somehow missed the \ out.

James, your first attempt is wrong, since it should be double quotes - " not single quote - '.

Your second syntax looks correct. Looks like the exe doesn't exist in the directory path.

Can you please navigate to the directory - C:\Program Files\MySQL\MySQL Server 5.1 via Windows Explorer and verify whether the file - mysld.exe is present there?

James_2424

ASKER

thanks,

I tried it with double quote too but didn't execute.

It seems to me the file is there. Please see attachment. It is mysqld.exe right?
mysqlErrorHelp3..JPG

irf44z

James, you missed the 'q' in mysqld >> You were trying to execute "mysld", which doesn't exist

It should be

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld"

Open in new window

James_2424

ASKER

Thanks irf44z,

Sorry it was a mistyped.
What i did was stopped mySQL from control panel then I tried typing everything exactly and now the command line window frozed.

Below is the image

Is there another way to set up mySQL? like uninstalling and reinstalling it? or does the password get stored in some catch even after i uninstall mySQL?
mysqlErrorHelp4..JPG

ASKER CERTIFIED SOLUTION

irf44z

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James_2424

ASKER

thanks it worked :D

James_2424

ASKER

thanks irf44z..

mschneikert

Just come across this issue myself today. Very similar to James issue except I'm getting a weird error see attached. However it doesn't seem to reset my password.

This is the link I sent.

My mysql-init.txt file looks like this

UPDATE mysql.user SET Password='boguspassword' WHERE User='root';
FLUSH PRIVILEGES;

Any ideas?
MySQL-Error.JPG