remotley connect to mysql db with php?

Question

i'v built a huge media player with more than 250gigs of music and still growing( it's legal ).

so i need "unlimited" disk space and "unlimited" mysql concurrent connections, and i can get that with dedicated server but it's to much money for me.

so after i stayed on the line with HostGator sales for hour + they gave me this offer..

"you could have an Shared Hosting account with the databases, and just remotely access them from the VPS, but that would be out of scope for us to really help set it up"

so the offer they came back with was that i buy VPS package and Shared Hosting Package.

the VPS package have no "limit" on mysql connections. > the site will be on this account.

the Shared Hosting will have no limit on "Disk Space". > the files and the mysql server will be on this account.

so how can i remotely connect to the mysql db with php ?

Can u guys help me?

ldg · Accepted Answer · 2011-06-10 03:31:45Z

1

Why don't you put the PHP files and MySql on the VPS and just the music files on the Shared Hosting account? You could access the database from the Shared Hosting if they allow remote access to the MySql port. It doesn't really make sense if they said the VPS had unlimited MySql connections if they didn't mean for you to put the db there.

edited Jun 10, 2011 at 3:31

answered Jun 10, 2011 at 3:26

ldg

9,4523 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pinokyo Over a year ago

so the db suppose to be on the VPS as well as the site?

ldg Over a year ago

based on your replies in bold, that would be my assumption, yes.

esqew · Accepted Answer · 2011-06-10 03:27:35Z

1

$connect = mysql_connect($server_addr, $username, $password);

Where $server_addr is the remote IP address or domain name of the SQL server, $username is the SQL username and $password is the password for the specified username. Most hosting packages (especially those running on cPanel) require you to specify remote addresses which can connect to the server with your account.

answered Jun 10, 2011 at 3:27

esqew

45k28 gold badges139 silver badges179 bronze badges

Comments

bumperbox · Accepted Answer · 2011-06-10 03:26:48Z

0

if they offer ssh access, you could create a tunnel over ssh for the mysql port. other options are a vpn (virtual private network) between the computers

also if the are both hosted by the same company, they might be behind the same firewall then there is the possibility you can connect directly to the other box

eg host = ipaddress of server with database on it

answered Jun 10, 2011 at 3:26

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

3 Comments

Pinokyo Over a year ago

it's the same company Hostgator. so i just need to ask them if both computers are behind the same firewall?

bumperbox Over a year ago

just try it and see if it works mysql_connect('ip address of remote machine', 'mysql_user', 'mysql_password');

ldg Over a year ago

You'll also need to check which port as most large hosts like that run mysql on many ports in addition to the default, 3306. It's also a question of whether the VPS and shared host are in the same data center, something which could change in the future. Still seems like a better idea to put the db on the VPS where ostensibly you will have more control

Collectives™ on Stack Overflow

remotley connect to mysql db with php?

3 Answers 3

2 Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related