Configure phpMyAdmin to connect to another MySql server [closed]
I have installed WAMP server on my laptop and for the sake of simplicity I want to configure phpMyAdmin to connect to a mysql server on another machine so that I can dump the database tables.
If this is possible (and i believe it is), does any1 knows where is phpMyAdmin settings file located?
The location of wamp on my laptop is C:\wamp
. I've noticed in C:\wamp\apps\phpmyadmin3.5.1
but there are a lot of php scripts in there. Which one of this should I modify?
PHPMyAdmin's configuration file is located in the root directory and is called config.inc.php and in order to configure the servers to connect to, you can check this page for more information.
Here's an example how the server configuration should look like:
$i++;
/* First server */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'mysql1.example.net';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$i++;
/* Second server */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'mysql2.example.net';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;