Connect to external server by using phpMyAdmin

php phpmyadmin database-connection remote-server
Neveen picture Neveen · Nov 12, 2009 · Viewed 112.5k times · Source

I have phpMyAdmin installed on my local machine. How can I make it connect to an external server?

Answer

DisgruntledGoat picture DisgruntledGoat · Nov 12, 2009

In the config file, change the "host" variable to point to the external server. The config file is called config.inc.php and it will be in the main phpMyAdmin folder. There should be a line like this:

$cfg['Servers'][$i]['host'] = 'localhost';

Just change localhost to your server's IP address.

Note: you may have to configure the external server to allow remote connections, but I've done this several times on shared hosting so it should be fine.

Related questions

Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More
I can't access http://localhost/phpmyadmin/

Problem: I can't access localhost/phpmyadmin/ before I can access localhost/phpmyadmin/ but today when I'm trying to access this page I got weird page also I can access localhost/xampp/ without any problem Question: How can I solve this …

Read More