Improve company productivity with a Business Account.Sign Up

x
?
Solved

Cannot remotely administer MySQL installed on Windows 7

Posted on 2010-11-18
2
Medium Priority
?
619 Views
Last Modified: 2012-06-27
I have Windows 7 Professional on Dell Vostro 230.

I installed MySql Server (mysql-5.1.52-winx64.msi) into MySQL directory. Configured MySQL and imported my app's database using MySQL Workbench.

I would like to remotely manage MySQL but cannot get MySQL Administrator on remote computer to connect.

I keep getting

MySQL Error Number 2003.
Can't connect to MySQL Server on 'host' (1060).
Ping to 'host' is successful.

From remote computer, I tried 'telnet [mysqlHost] 3306' but connection failed.

Research on question has gotten me nowhere.

Anyone have any ideas on how to solve this?
0
Comment
Question by:Proud_Grandpa
2 Comments
 
LVL 1

Accepted Solution

by:
MDEBRUYN-NEQCA earned 2000 total points
ID: 34166240
It sounds like a windows firewall issue.  You can test this by just disabling the windows firewall temporarily and if that resolves the problem just add an exception allowing incoming requests on port 3306.
0
 

Author Comment

by:Proud_Grandpa
ID: 34167647
It turned out to be my antivirus/firewall.

The computer came preinstalled with TrendMicro Antivirus.

I checked the firewall settings but couldn't find anything.

So I uninstalled TrendMicro and installed the 64-bit client installer for Symantec Endpoint Protection, everything cleared up.

Thank you for your help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

586 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