Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1825
  • Last Modified:

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?
0
James_2424
Asked:
James_2424
1 Solution
 
irf44zCommented:
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.
0
 
spamsterCommented:
and you probably need a slash "\" between C: and Program

"C:\program files\MySQL\MySQL Server 5.1\bin\mysqld"
0
 
James_2424Author Commented:
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
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
James_2424Author Commented:
tried this method too since I used a wizard to install mysql
mysqlErrorHelp2..JPG
0
 
irf44zCommented:
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?
0
 
James_2424Author Commented:
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
0
 
irf44zCommented:
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

0
 
James_2424Author Commented:
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
0
 
irf44zCommented:
Hi,

What you did is correct. The command window would look frozen but the password has actually got reset to what you specified in the init file (mysql-init.txt).

After you execute this command, go to Task Manager and terminate the process - mysqld.exe. Now, start the MySQL server the way you normally do (Windows Service OR from command prompt - as per your configuration).

If this still didn't reset your password, ensure that the mysqld.exe process is not running in Task Manager before you execute the command to reset the password. [Terminate the process if you find it running in Task Manager]


Yes, you can do a reinstall, but make sure that you delete the directory - C:\Documents and Settings\All Users\Application Data\MySQL right after you uninstall and before you reinstall MySQL again. [You would lose the tables and data. So make sure you have a copy of the create scripts/data]
0
 
James_2424Author Commented:
thanks it worked :D
0
 
James_2424Author Commented:
thanks irf44z..
0
 
mschneikertCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now