?
Solved

ASP.NET Windows 7 Cannot Connect to MySQL Database

Posted on 2010-11-20
4
Medium Priority
?
861 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

719 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