I am not sure if this is the best place to post this information... but i wanted to help anyone who is struggling with this problem.
I spent way too many hours trying to install and work with MySQL (Windows XP). It was VERY frustrating. The problem was with the root password. For some reason, probably a mistake that I made...
the root password was rejected by MySQL when I tried to build a connection.. or anything else.
I am very new to MySQL so I figured... ok... i'll just mess around, find the place where I can reset the password... and i'll be on-my-way...
Nope... you have to uninstall MySQL the reinstall and reconfigure...
So... I uninstalled MySQL and reinstalled... didn't work!!!!
After MANY hours I sent an eMail to Steve Workings (I was working my way through his excellent 'XBasic for Web' lessons). He responded very quickly... I LOVE this forum!...
Steve pointed me in the right direction & after an hour or so I came up with the following:
1) use Control Panel -> Admin -> Services to stop the MySQL service
2) run the MySQL install program (i'm using version 5.5.16)
3) select 'uninstall' from the first dialog
4) delete the 'MySQL\MySQL Server 5.5' directory from the Program Files... a reboot may be necessary... even then i was forced to drag some of the files to the desktop & delete from there
5) use the windows explorer to delete all MySQL Server directories from \Documents and Settings\AllUsers\Application Data
6) similarly, remove these directories from \Documents and Settings\'USERNAME'\Applicationn Data
7) reboot
8) use Run -> Regedit.exe -> find to find & remove all entries with MySQL BUT !!! NB! be careful to avoid removing any MySQL entries related to Toad or Workbench
9) reboot
10) reinstall MySQL
11) celebrate!
I hope this information helps those of you who may be having similar problems.
David
I spent way too many hours trying to install and work with MySQL (Windows XP). It was VERY frustrating. The problem was with the root password. For some reason, probably a mistake that I made...
the root password was rejected by MySQL when I tried to build a connection.. or anything else.
I am very new to MySQL so I figured... ok... i'll just mess around, find the place where I can reset the password... and i'll be on-my-way...
Nope... you have to uninstall MySQL the reinstall and reconfigure...
So... I uninstalled MySQL and reinstalled... didn't work!!!!
After MANY hours I sent an eMail to Steve Workings (I was working my way through his excellent 'XBasic for Web' lessons). He responded very quickly... I LOVE this forum!...
Steve pointed me in the right direction & after an hour or so I came up with the following:
1) use Control Panel -> Admin -> Services to stop the MySQL service
2) run the MySQL install program (i'm using version 5.5.16)
3) select 'uninstall' from the first dialog
4) delete the 'MySQL\MySQL Server 5.5' directory from the Program Files... a reboot may be necessary... even then i was forced to drag some of the files to the desktop & delete from there
5) use the windows explorer to delete all MySQL Server directories from \Documents and Settings\AllUsers\Application Data
6) similarly, remove these directories from \Documents and Settings\'USERNAME'\Applicationn Data
7) reboot
8) use Run -> Regedit.exe -> find to find & remove all entries with MySQL BUT !!! NB! be careful to avoid removing any MySQL entries related to Toad or Workbench
9) reboot
10) reinstall MySQL
11) celebrate!
I hope this information helps those of you who may be having similar problems.
David
Comment