i have php myAdmin installed on my machine how can make it connect to external server database
Thanks in advance
+2
A:
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.
DisgruntledGoat
2009-11-12 13:09:04
could you please tell me the path of config fileThanks
Neveen
2009-11-12 13:11:53
It's the file called `config.inc.php` in the phpMyAdmin folder.
DisgruntledGoat
2009-11-12 13:13:36
i did the previous solution but it asked me for the password and it doesn't logged i don't know what is the problem ??
Neveen
2009-11-12 13:54:24
It's difficult to say. Are you sure you're using the correct username and password for the external server?
DisgruntledGoat
2009-11-12 18:15:02