[To Resellers] Can you connect to a mysql database remotely

[BlackStorm]

Hey,
Im just wanting to know if many resellers can connect to a remote database (Which IS on the server their reseller account is on)
IE. Make a connection from your local computer, to the server your reseller account is on.

The reason Im asking is I have seen a few people say before they cant do this and I wanted to know if anyone here has that problem..

 

[jdshells]

I don't see why not, I do this all the time with other websites I run. All you got to do is add your hostmask to the access list and that should be it.

 

[imported_HadleyHost]

No it has to be local for me

 

[FatalSw1tch]

We don't allow it unless it is from another server in the cluster. Which is already setup for them. It is a scruity risk not having it as local or in the secure cluster setting.

 

[turnkey]

John,

If you are using cPanel, cPanel has the configuration available for you to allow remote connections to the DB. I think all you have to do is add a wildcard "*" as the remote host and then you should be able to connect via the server IP instead of localhost. I did this about 6 months ago or so but it has been a while...

 

[RobAPI]

Can using the wildcard for mysql remote access cause any security problems?
Are you still using that now Robert?

I thought that using the wildcard COULD be a security problem with anyone able to access mysql (Even if they need the password) but of course I could be wrong.

 

[monaghan]

They need the MySQL username & password to make a connection, I don't see it as a huge risk.

 

[dacsoft]

We open up the firewall if a customer has a need to connect remotely. The biggest problem I see is that some people forget to assign a secure password to SQL Root.