Articles

Solved how to open tcp port 3306 in windows 7 professional

February 29, 2012 at 04:45:18
Specs: Windows 7, 2 GB

plz. help my due to TCP/IP port setting i m fail to install mysql

See More: how to open tcp port 3306 in windows 7 professional

Report •


#1
February 29, 2012 at 04:51:45

You don't give many details, like error messages for example. You do not need to "open" a port to install MySQL; it will open the port when it runs. If you wish to access the database server from another computer then you may need to change firewall rules to allow access.

Tell us what happens when you try to install and/or run mysql, including precise error messages.


Report •

#2
April 16, 2012 at 12:07:58

I'm also trying to open TCP port 3306 because I tried to install MySQL 5.5 (Windows 2007 Home Premium 64-bit OS) and got the following error message:

"
The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.
"


Report •

#3
April 16, 2012 at 13:02:56
✔ Best Answer

I've just tried to open the port 3306 following these steps:

1. Open Control Panel from the Start menu.
2. Select Windows Firewall.
3. Select Advanced settings in the left column of the Windows Firewall window.
4. Select Inbound Rules in the left column of the Windows Firewall with Advanced Security window.
5. Select New Rule in the right column.
6. Select Port in the New Inbound Rule Wizard and then click Next.
7. Select which protocol this rule will apply to (TCP or UDP), select Specific local ports, type a port number (80), port numbers (80,81), or a range of port numbers (5000-5010) and then click Next.
8. Select Allow the connection and then click Next.
9. Select when this rule applies (check all of them for the port to always stay open) and then click Next.
10. Give this rule a name and then click Finish to add the new rule.

Then, I clicked [Retry], but the error persisted...


Report •

Related Solutions

#4
July 12, 2012 at 04:15:40

very simple solution that if you are installing MySQL first time then do not rite old password and just fill new password then click on next and execute it will work

Report •

#5
October 12, 2012 at 00:09:51

I Know this problem .. I solved it by removing client&server MySQL then tried to install the server firstly >> the client secondly . its works ;)

Report •

#6
November 28, 2012 at 02:35:03

can u help me how to rwsolve this

The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.


Report •

#7
November 28, 2012 at 02:35:48

can u help me how to resolve this

Report •


Ask Question