I have an old MySQL installation for which I do not have the password. How can I reset the password? My first idea was to completely remove it and reinstall with a new password.
I am using Windows Vista.
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
lg's answer is correct. One additional hint:
You can reset the root PW without reinstalling MySQL. See the documentation:
I too was having the same issue. I uninstalled MySQL, removed the folder (C:\mysql in my case). Open Windows Explorer and goto Tools. Select the "View" tab and under "Hidden files and Folders" choose "Show hidden files and folders".
Now navigate to C:\Documents and Settings\All Users\Application Data. There should be a MySQL folder in there. Delete it and reinstall. Worked fine for me after that.
to re install mysql (caused me alot of trouble and nothing in the postings seemed to help so i tried it hard till i got it right)
restart if u fill like but not mandatory
Reinstall and enjoy!!!!
If you have problems uninstalling MySQLServer 5.5(mysql-5.5.9-win32.msi) in Windows 7, there are 4 easy steps.
Run C:\Program Files\MySQL\MySQL Server 5.5\bin\MySQLInstanceConfig.exe >> NEXT>> REMOVE Instance>> NEXT>> EXECUTE>> FINISH
Run MySQLServer Installer 5.5(mysql-5.5.9-win32.msi) >> NEXT>> REMOVE>> REMOVE>> OK>> FINISH
Delete the folder C:\Program Files\MySQL
Delete the folder C:\ProgramData\MySQL
REINSTALL MySQLServer 5.5(mysql-5.5.9-win32.msi) - With NEW PASSWORD...
hopefully useful..work 100%
This is actually will remove all the MySQL modules installed on your computer. If you want to remove a specific module, can be done this way: 1. same as above 2. Run MySQLServer Installer 5.5(mysql-5.5.9-win32.msi) >> NEXT>> REMOVE >> just remove the specific module ie: MySQL Server. 3. Delete the folder of the module you want to delete ie: C:\Program Files\MySQL\ 4. No need to delete C:\ProgramData\MySQL since it will be overwritten by step 5 5. Reinstall the module using the .msi file.
Hope this helps more ;)
I've tried both unistalling and deleting the whole MySQL folder (plus a search for any file with "mysql" in the name just to be sure), and the root PW reset from the doc, and neither work. When I delete and reinstall the configuration is still there, as the only option in setup is "modify security settings" which requires an existing password, and skipping that I can't log in to my new install. I tried the init-file trick and it just hung for several minutes until I canceled the operation. So, any other ideas?
If you are having problem uninstalling mysql in win 7
step1) Uninstall mysql from control panel >> add remove program
step 2) remove mysql folder from 1) program files 2) c:\programdata
Now try to Install it again.
You will get an option to reconfigure the mysql service while install mysql there will an option to stop and remove the mysql service.
Once you do this...try step 1 and 2 again
Do an installation again
and Voila it will work!!