Solved

Hosted MySQL Database - Remote Access Issue

Posted on 2012-12-20
3
452 Views
Last Modified: 2012-12-29
I am able to access my database (hosted on DiscountASP.net) remotely using MySQL Workbench.

The webpage hosted on DiscountASP.net also can access the MySQL server and run queries just fine.

When I'm at work (vs. working remotely from home) - I am unable to access the same MySQL database from MySQL Workbench - it says the connection is refused.

This has to be something simple but my brain gave up for today - any ideas?

More Info:

I'm running Windows 7 64-bit at the office - all ports for MySQL & MSSQL are open - I can connect fine to my local MySQL Database & MSSQL Databases - I'm behind a pfsense firewall at the office which I "manage" (I have access & can make changes, but it's something another person setup so I typically don't change much).  I believe it's that dang pfsense but am not sure what (a Rule? a NAT?) to do about that...
0
Comment
Question by:ProdigyOne2k
  • 2
3 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38711440
as you said - it looks like related to your office network security setup: try to set GoToMyPC - and connect to your home PC

http://www.gotomypc.com/remote_access/remote_access
or similar
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38711735
Is your MySQL connection from home set up to use a specific IP address?  If it is, the IP address at the office will not be the same.
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 38711844
in the office the firewall may prevent it - check your network admins \it security
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help With Query That Causes "WARNING: MySQL server has gone away" Error 3 21
Martian Packets Unix 5 30
Update data using formula 22 19
Sql Query 4 0
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now