Solved

Cannot remotely administer MySQL installed on Windows 7

Posted on 2010-11-18
2
602 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
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.

713 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