Remote Mysql Access Via Da Server

[Rich]

I'm trying to allow some remote access of a MySQL database which is on my HostPC server.

My goal is to develop an application to allow my users to be able to access the database remotely.

First question was why couldn't I add a wildcard for the host? Why not be able to add * if I want to allow all hosts to be able to access the database?

In the database, I added the IP of my host. (I'm on a comcast cable modem).

Ignoring the wildcard issue, it appears I can't get to mysql remotely.

Second, I couldn't get it to work at all! I understand that mysql is done via port 3306. It's certainly not my firewall, I even tried shutting this off.

It is possible it's my cable modem company (comcast)? Might they keep me from using port 3306? If so how can I test this?

Or is this issue because of something that HostPC has configured?

Has anyone else ever tried this??

For some tests I installed the MySQL ODBC 3.51 Driver and tried to get that to connect. It wouldn't work at all.

Any help or hints would be appreciated.

[ryan]

I'm thinking we don't allow external connection via the firewall but let me check on that.

[PhilHarnish]

According to the research I did at the DirectAdmin website you add "%" as a host for the MySQL user and it should work. Of course, in order for it to work HostPC needs to open up the port.

I too really could use this right now (came here in search of it, strange that this was the only post about the topic and it started recently).

I talked to Joe who said the user Eugene is the person to talk to:
http://www.hostpc.com/forums/index.php?showuser=20

I'll try to remember and post if anything develops.

[Rich]

Whey you say to add %, is this instead of an * to be used as a wildcard? I see that the DA Panel allowed me to enter a host name of %, but I'm not sure if this is a wild card or what considering that I still can't get access to work.

I'd like to know if HostPC has the firewall disabling the mysql port. I wouldn't want to spend any more time getting my head banged against the firewall.

[Guest]

any updates?

[Cody Craven]

I would really like to know if we can access the mysql databases included with our accounts remotely, and if so which port.

I would like to run a test server for my php projects through my reseller account since I use Zend to develop my projects.

A yes or no answer would be very helpful.

[Nick]

Yes, it can be done in DA by adding % in the host allowed section of MySQL
Can't answer if Joe is doing something to block it .. but the % does work

[Rich]

I haven't checked if this recently changed, but originally if i I used a %, DA would take it, but I still couldn't get access. I thought that there may be a firewall issue.

Can anyone confirm that this is working now? If I get time later I will test it again.

Thanks!

[Rich]

Originally posted by NHFTRich@Feb 10 2006, 07:14 AM
I haven't checked if this recently changed, but originally if i I used a %, DA would take it, but I still couldn't get access. I thought that there may be a firewall issue.

Can anyone confirm that this is working now? If I get time later I will test it again.

Thanks!
Quoted post


I'm getting the same results. Nothing is working. It's as if there is a firewall or something. I even tried turning my firewall off during testing and that didn't help.

[Cody Craven]

It's working for me, although I am using my static ip and not a %.

[Rich]

Originally posted by Cody Craven@Feb 15 2006, 02:06 PM
It's working for me, although I am using my static ip and not a %.
Quoted post


Hmm... I wonder if this has something to do with my ISP then? I tried both my IP address of the day and also the '%', neither worked for me.

[starfighter]

Has anyone gotten this to work lately? I'm trying and for some reason this wont't work. I've followed all of the steps listed here and on the DA forums but i still don't get a connection. Anyone have any ideas?

[admin]

Open a helpdesk ticket - we're activating it by request only

[thevillageinn]

When remote access to mySQL is not in use, I assume, simply remove the wildcard from the allowed hosts...?

I'd figure that to help tighten the security a bit more than just leaving it open to any remote host who can figure out the password.