File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem in Configuring MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in Configuring MySQL" Watch "Problem in Configuring MySQL" New topic

Problem in Configuring MySQL

Mark Henryson
Ranch Hand

Joined: Jul 11, 2005
Posts: 200
I am using Windows Vista Home Basic with Norton Internet Security 2009.
My Windows firewall has been turned off by norton, as it provides its own firewall.
I have installed mysql and I am trying to configure my mysql 5.1.
While configuring at the last step "Applying Security setting" mysql throws an error saying that to "open the port 3306 TCP and retry".
As my windows firewall has been turned off my norton, I have gone to the norton internet setting and in program control I have seen for mysql the firewall option is already "Auto" with "Allow" option for port 53.
I have added the port 3306 (local port) with TCP. Then I have tried to configure, but still getting the same error message.
I have also added the port to exclude from firewall in windows firewall also. But the result is the same.
Please suggest what needs to be done for it.
Configuring the MySQL in Windows Vista with Norton Internet Security 2009.
Deepak Bala

Joined: Feb 24, 2006
Posts: 6662

Not used mysql myself but I can relate with the firewall problem thing so here goes.

Log off the internet. Bring down the windows and norton firewall and try installing the database. If you are able to then you can confirm that either windows or norton was the culprit. Check your norton logs to check what is going on as well

SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46405
That sounds a good idea, Deepak Bala, but I would suggest as well: turn your router/modem off at the mains until you have finished the whole procedure, and enable your firewalls again before turning the modem/router on.
Mark Henryson
Ranch Hand

Joined: Jul 11, 2005
Posts: 200
I will try this and let you know.
I agree. Here's the link:
subject: Problem in Configuring MySQL
It's not a secret anymore!