Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ASP.NET Windows 7 Cannot Connect to MySQL Database

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
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…
Suggested Courses

885 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