Why WebhostingBuzz doesn't support mySQL remote connection?

[omko]

Please, I want to ask, why WHB doesn't support remote connection to our mySQL servers, because it's really important for me to manage and connect to my databases at my HOST

please , I want help or good answer
thanx

[Dennis A.]

The main reason why remote MySQL connections aren't supported is security. MySQL is relatively easy to break, for example by some sort of DDoS attack (and this will cause tremendous server load which will effectively lead to all services downtime). MySQL is quite vulnerable to some other kinds of attacks. And - with MySQL connections over TCP/IP you won't be able to use data encryption in a way it normally should be used. That's why managing your data from the server itself via UNIX local socket is preferred (IMHO MySQL connections over TCP/IP are acceptable only between my hosts inside the private network which is completely controlled by me).

[jhsands]

Maybe it's just me... but isn't the answer to his problem called SSH tunneling ???

[simplesft]

Isn't that why you can set up firewalls and mysql to only allow specific hostnames. You set the hostnames in cPanel that are allowed. This set its for MySQL only but a script could easily take that list and create firewall rules which only allow people from those hosts...

That would then make it possible for legitimate users to acces it from their home/office, etc. and it would protect against DDOS since the port would be stealth for every other host.

[Saf M]

Isn't that why you can set up firewalls and mysql to only allow specific hostnames. You set the hostnames in cPanel that are allowed. This set its for MySQL only but a script could easily take that list and create firewall rules which only allow people from those hosts...

That would then make it possible for legitimate users to acces it from their home/office, etc. and it would protect against DDOS since the port would be stealth for every other host.

I respect your correspondence to this particular area of possible recognition but DO tell me how you WOULD tend to deal with something like that when you have got more than 150 different user names on the same web server?

[Ancyent]

ok I am a newbie but ... this ideea would really be something I am trieng to do the exact same thing . The dev for this script would be a new thing for host business.

[omniuni]

You should be able to do this via SSH. If you get it enabled, you can access the server by command line. Some programs, in particular the KDE programs on Linux can operate over SSH by a protocol called FISH. You may be able to use this once SSH is enabled.

[Ancyent]

you see in my case I need it for a counter strike server so i need a direct connection only for 1 IP ...

[razorfish]

So I see now on my cpanel a feature about "remote mysql database access". Is this feature enabled now?
Can I setup a wordpress on another server and connect to a database on my whb hosting package??

[carlobee]

The main reason why remote MySQL connections aren't supported is security. MySQL is relatively easy to break, for example by some sort of DDoS attack (and this will cause tremendous server load which will effectively lead to all services downtime). MySQL is quite vulnerable to some other kinds of attacks. And - with MySQL connections over TCP/IP you won't be able to use data encryption in a way it normally should be used. That's why managing your data from the server itself via UNIX local socket is preferred (IMHO MySQL connections over TCP/IP are acceptable only between my hosts inside the private network which is completely controlled by me).

i guess i'd still have to agree with this one.

[Twiztid]

MySQL used remotely , could be compromised and they are just looking out for the customers on the server as far as security and just keeping the server up one malicious code in the MySQL could cause a whole server outage, just my two cents.

Ed