PHP - connect to another database

I'm new to PHP and I have the code/database working with WAMP on my local machine. I have a phpMyAdmin and my database is there...

Now, there's another phpMyAdmin that I have the URL for and our off-shore developers use that. I want to connect to a database on that phpMyAdmin. I tried below and it didnt work

1. I have the URL to that phpMySQL:
2. I put it in the code here
$dbhost = '';
$dbuser = 'something';
$dbpass = 'something1';
$dbname = 'bdstaging';

Can I even connect to a phpMyadminthat's not local??
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
IP address is fine for the host.  You do need the correct login info for it.  Unless it has been setup intentionally, there is no reason to think the remote database will have the same login as the local one.
RaithZConnect With a Mentor Commented:
Are you trying to connect to someone else's phpmyadmin or have your php code connect to a database on another machine?

If its the later, then you will need them to give you the host to connect to, and put that in the code. You wouldn't connect to phpmyadmin with your php code, you would connect directly to the database.
John EastonConnect With a Mentor DirectorCommented:
To the best of my knowledge a local install of phpMyAdmin can connect to any mySQL server.  However, many hosting company's block the ports that would be required to connect.  It makes the database more secure!

However, if you unblock the ports or whitelist your IP address then it should be possible to manage a remote mySQL install using a local phpMyAdmin install.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Yes what JEaston said is correct, and to add to it, the db host wouldn't be the URL of the phpmyadmin, but the host name of the machine hosting the databases which may just be The port would probably need to be opened for you on the remote end (the off shore system).
Dave BaldwinFixer of ProblemsCommented:
To connect to another database server in phpMyAdmin, You have to duplicate the section in the '' file that starts with $i++; and put in the info for the new host.  Don't include any of the 'pma' lines because they will only work on the local database.  Then the next time you start up phpMyAdmin, there will be a dropdown added to the login where you can select which database you want to connect to.  But... this will only work if you have a valid remote login to that database.  There is no 'generic' connection to a MySQL installation.
CamilliaAuthor Commented:
thanks, guys. Let me read
CamilliaAuthor Commented:
>>it should be possible to manage a remote mySQL install using a local phpMyAdmin install. .

I can be on VPN and I have the server's IP address. I should put the IP address as the host name?

>>put in the info for the new host (From DaveBaldwin)...
 if I do this...i just put in the IP address, name of the remote database, etc?
CamilliaAuthor Commented:
yes, i have the login/pwd to the database as well. I'll try it.
Jagadishwor DulalConnect With a Mentor Braces MediaCommented:
I think you connect to mysql database not a phpmyadmin?? Can you access phpmyadmin in browser using
CamilliaAuthor Commented:
Yes, i want to connect to mySQl and yes, I can access 

So, I'm going to try the IP address of the server with mySQL's userid/pwd and see if i can connect thru code.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.