peterbz Posted April 20, 2008 Share Posted April 20, 2008 I was wondering how you can connect to a MySQL database on another server if you have the username and password What I want to do is to retrieve data from a table from a MySQL database on another server and update the data to another server. I was just wondering if this is possible. Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/ Share on other sites More sharing options...
dptr1988 Posted April 20, 2008 Share Posted April 20, 2008 Yes, you can specify the a different hostname in the '$server' argument in mysql_connect, connect to that server, get your data and then make another connection to your other server and insert/update the data. http://us.php.net/mysql_connect Or if you have access to the command line on a computer that has MySQL installed, you could do that using some of the mysql tools ( eg, mysql, mysqldump, etc ). Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522021 Share on other sites More sharing options...
peterbz Posted April 20, 2008 Author Share Posted April 20, 2008 What would the host name be if I were trying to connect to for example a site like http://vision-blog.info Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522073 Share on other sites More sharing options...
dptr1988 Posted April 20, 2008 Share Posted April 20, 2008 You would have to contact the hosting company or webmaster to figure that out. Most hosting companies do NOT allow the MySQL server to be remotly accessed and if they do, there is now way of guessing which hostname the server runs at. Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522079 Share on other sites More sharing options...
monkeypaw201 Posted April 20, 2008 Share Posted April 20, 2008 So, in my experience, it should run just entering "vision-blog.info" as the host, be sure though to have your host provider you are accessing white-list the IP address of your website Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522124 Share on other sites More sharing options...
peterbz Posted April 20, 2008 Author Share Posted April 20, 2008 Will I be able to find the host name if I have access to phpMyAdmin for my MySQL server Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522152 Share on other sites More sharing options...
monkeypaw201 Posted April 20, 2008 Share Posted April 20, 2008 Yes, at the top you should see something like this: Server: localhost:3306 - Database: database_name - Table: users The "Server" is the server you use Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522245 Share on other sites More sharing options...
dptr1988 Posted April 20, 2008 Share Posted April 20, 2008 But the server is 'localhost'. You need to find a public hostname for that server. It's hard to get. You might have to really bother you webhosting company to get it. With the web hosting companies I've worked with, they have never given out their public SQL server hostname with out you having to ask for it. Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522250 Share on other sites More sharing options...
monkeypaw201 Posted April 20, 2008 Share Posted April 20, 2008 dptr; wouldn't just using the server IP work? or whatever the address is in the address bar..? Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522270 Share on other sites More sharing options...
dptr1988 Posted April 20, 2008 Share Posted April 20, 2008 Yes, an IP address will work or anything that will give you an IP address. If the server admin has allowed remote access to the DB server, he probably didn't put it on the same hostname as the webserver ( the address you see in your address bar ) or at least i"ve never seen it done this way. But it's worth a try! Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522283 Share on other sites More sharing options...
monkeypaw201 Posted April 20, 2008 Share Posted April 20, 2008 : I have, i actually run it that way Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522289 Share on other sites More sharing options...
dptr1988 Posted April 20, 2008 Share Posted April 20, 2008 Me too, but I don't see that way very often. Link to comment https://forums.phpfreaks.com/topic/102002-connect-to-mysql-on-another-server/#findComment-522296 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.