SEO

#1 (**permalink**) 02-28-2008, 07:56 AM

Hi,

I know that most of web hosting companies provide a web bases interface
to MySql to manage databases hosted by them.

Is there any MySql hosting that exposes the actual MySql TCP port 3306
to the Internet, so I can remotely connect to MySql database and
directly work with tables?

Thank you,
Alan

#2 (**permalink**) 02-28-2008, 07:56 AM

gmax2006 wrote:
> Is there any MySql hosting that exposes the actual MySql TCP port 3306
> to the Internet, so I can remotely connect to MySql database and
> directly work with tables?

I wouldn't expect there to be any hosting provider who does this. MySQL
is not a very secure daemon, and it would require careful configuration
and constant monitoring to avoid being hacked, if one exposed 3306 to
the internet. I would expect any hosting provider to use the policy of,
"close all ports except those that are absolutely necessary".

You can use web-based tools. Most hosting providers who provide MySQL,
also provide a web-based administration interface. Most commonly they
choose phpMyAdmin, but there are other options too.

You can also find a hosting provider who gives you shell access.
They're not very common, but there are some hosting services who offer
this. You can then ssh into the server and use command-line mysql
utilities.

Regards,
Bill K.

#3 (**permalink**) 02-28-2008, 07:56 AM

Bill Karwin wrote:
> gmax2006 wrote:
>> Is there any MySql hosting that exposes the actual MySql TCP port 3306
>> to the Internet, so I can remotely connect to MySql database and
>> directly work with tables?
>
> [..]
>
> You can also find a hosting provider who gives you shell access. They're
> not very common, but there are some hosting services who offer this.
> You can then ssh into the server and use command-line mysql utilities.

Or use the ssh tunneling feature to tunnel port 3306 to your own computer.

--
Philipp Tölke
PGP 0x96A1FE7A

#4 (**permalink**) 02-28-2008, 07:56 AM

gmax2006 wrote:
> Hi,
>
> I know that most of web hosting companies provide a web bases interface
> to MySql to manage databases hosted by them.
>
> Is there any MySql hosting that exposes the actual MySql TCP port 3306
> to the Internet, so I can remotely connect to MySql database and
> directly work with tables?
>
> Thank you,
> Alan
>

Yes.
http://www.db4free.net/

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.org/

#5 (**permalink**) 02-28-2008, 07:56 AM

Philipp Tölke wrote:
> Bill Karwin wrote:
>
>>gmax2006 wrote:
>>
>>>Is there any MySql hosting that exposes the actual MySql TCP port 3306
>>>to the Internet, so I can remotely connect to MySql database and
>>>directly work with tables?
>>
>>[..]
>>
>>You can also find a hosting provider who gives you shell access. They're
>>not very common, but there are some hosting services who offer this.
>>You can then ssh into the server and use command-line mysql utilities.
>
>
> Or use the ssh tunneling feature to tunnel port 3306 to your own computer.
>

MySQL would still have to be configured to listen to the port - and most
shared hosts do not allow it. They only allow socket access - and
tunneling can't access the socket.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

#6 (**permalink**) 02-28-2008, 07:56 AM

Giuseppe Maxia wrote:
> gmax2006 wrote:
>
>>Hi,
>>
>>I know that most of web hosting companies provide a web bases interface
>>to MySql to manage databases hosted by them.
>>
>>Is there any MySql hosting that exposes the actual MySql TCP port 3306
>>to the Internet, so I can remotely connect to MySql database and
>>directly work with tables?
>>
>>Thank you,
>>Alan
>>
>
>
> Yes.
> http://www.db4free.net/
>
> ciao
> gmax
>

Interesting.

Doesn't look too secure, though. I'd be interested in using them for
development/testing but not production.

Good to know they're around.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

#7 (**permalink**) 02-28-2008, 07:56 AM

Jerry Stuckle wrote:
>> Or use the ssh tunneling feature to tunnel port 3306 to your own
>> computer.
>>
> MySQL would still have to be configured to listen to the port - and most
> shared hosts do not allow it. They only allow socket access - and
> tunneling can't access the socket.

Uh, yes you are right there.

I just knew I used that feature -- but that was on a root-server I had.
There of course I was free to puncture the security all I liked. ;-)

Sorry,
--
Philipp Tölke
PGP 0x96A1FE7A

#8 (**permalink**) 02-28-2008, 07:56 AM

Philipp Tölke wrote:
> Jerry Stuckle wrote:
>
>>>Or use the ssh tunneling feature to tunnel port 3306 to your own
>>>computer.
>>>
>>
>>MySQL would still have to be configured to listen to the port - and most
>>shared hosts do not allow it. They only allow socket access - and
>>tunneling can't access the socket.
>
>
> Uh, yes you are right there.
>
> I just knew I used that feature -- but that was on a root-server I had.
> There of course I was free to puncture the security all I liked. ;-)
>
> Sorry,

Yep, I've got it on my vps's. Normally I keep it turned off - but when
I need it it's an easy change and restart of MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Web/MySql Hosting,