SOLVED: Installing MySQL Windows 7 (not responding)
Recently I had to install a WAMP server on my laptop running Windows 7. The downside to Windows, in my opinion, is there is no package management tools such as apt-get or yum, therefore all software has to be installed and maintained manually.
Installing MySQL seemed to be a headache. The installer would stop responding at Instance Configuration Wizard, however the solution to this problem is easy.
You need to punch a hole in Windows firewall for MySQL before you install. Open up TCP ports 3306 for both incoming and outgoing and the installation will complete fully.
If you get stuck with a problem that I did where it installed MySQL without a root password even though you selected one, run:
$ mysqladmin -u root password NEWPASSWORD
Replacing NEWPASSWORD with your password.
If the command above does not work for you, you will need to use a full path to the command which may be in C:\Program Files\MySQL or C:\Program Files (x86)\MySQL or another location depending on where you installed it.
8 Comments
Comment
Thank you for posting this information!
I’ve been encountering the same issue. However, I’ve been unable to run the command successfully.
I’ve opened the Ports on Ingoing and Outgoing, so I’m hoping that I’m just hung up on the command line prompt now.
I’ve tried…
$ mysqladmin -u root password NEWPASSWORD
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqladmin -u root password NEWPASSWORD
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqladmin.exe -u root password NEWPASSWORD
However, when I run the last 2 statements, it returns that ‘C:\Program’ is not recognized as an internal or external command, operable program or batch file.
I’m new to this and I’m not a big tech guy, so forgive me if I’m missing something stupid.
Any help is appreciated. Thanks in advance.
It seems the problem is the use of spaces in the command prompt. Spaces in command lines are used to separate arguments therefore spaces in paths have to be escaped or enclosed in quotes. So by this you can appreciate how dumb it is that Windows will have system folders with spaces in their names. Look at the command below for an example.
“C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqladmin.exe” -u root password NEWPASSWORD
Opening port 3306 (Inbound and Outbound) solved it for me (Windows7 32 bit)
I’m using Win 7 x64 and this solved my problem like a charm, thanks a lot for sharing this information!
Hey, I’m having the same problem but I can’t fix it.
I don’t have windows firewall turned on and I use bullguard. However, I added rules for both.
Had no luck. Tried turning bullguard too and it still said it was being blocked by a firewall.
Is there any a chance that my router could be causing the problem?
This is hurting my brain and I’ve wasted a sunday trying to sort it out
Thanks. This really helped!
I was chasing this around for hours following various advice. If you are having issues, uninstall it. Remove the MySql directory from Program files if that is where you installed it but also remove the directory from Program Data. It was the one in Program Data specifically that was causing me issues.