Solved

ASP.NET Windows 7 Cannot Connect to MySQL Database

Posted on 2010-11-20
4
857 Views
Last Modified: 2012-05-10
I have been tryig to connect to a MySQL database using tools and code since I upgraded my computer to Windows 7 and started using AVG Anti Virus Software and have not been successful at doing so.

The error is:
"2003 - Can't connect to MySQL server on 'server name' (10060)"
or
"2003 - Can't connect to MySQL server on 'server name' (10061)"

Please advise.
0
Comment
Question by:Howard Bash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 34182078
Hi!!

This is not the case with Windows 7 or any OS.. it causes due to couple of reasons and primarily because of firewall; which in turn preventing mysql from reaching any outside requests...

- Make sure MySQL is up and running
- Make sure the port isn't blocked for outside world - from remore box telnet to mysql host on defined port and confirm if it is acknowledging requests..
- Add MySQL Server port to the exception list of firewall

0
 
LVL 1

Author Comment

by:Howard Bash
ID: 34182136
MySQL is running on a remote server.  The database is for a WordPress Blog and the blog is running so I know that the database is up.

As far as a blocked port I am running AVG and it has a firewall and not running Microsoft's Firewall as a result.  I have tried turning off the AVG firewall and it had no positive affect.
0
 
LVL 1

Accepted Solution

by:
Howard Bash earned 0 total points
ID: 34239086
Turns out that when the database was created there is an option to allow remote access.  If the database is created with that enabled then problem solved.
0
 
LVL 1

Author Closing Comment

by:Howard Bash
ID: 34328502
The solution was to configure the database correctly.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question