Solved

Cannot remotely administer MySQL installed on Windows 7

Posted on 2010-11-18
2
605 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
[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
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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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…

717 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