How to connect local PhpMyAdmin to remote server

Without any extra explanation lets get to how to connect your local PhpMyAdmin to your remote server.

Step 1:

Create remote access from your panel

Step 2:

- Go to your PhpMyAdmin installation folder (in your local machine) and edit config.inc.php file

- Add following code at the bottom of the file and save it

$i++;
$cfg['Servers'][$i]['host']          = 'WRITE_YOUR_SERVER_IP_HERE';
$cfg['Servers'][$i]['port']          = '3306';
$cfg['Servers'][$i]['socket']        = '';
#$cfg['Servers'][$i]['connect_type']  = 'tcp';
#$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['compress']      = FALSE;
#$cfg['Servers'][$i]['auth_type']     = 'config';
#$cfg['Servers'][$i]['user']          = '';
#$cfg['Servers'][$i]['password']      = '';

Step 3:

Open PhpMyAdmin in your browser and now you have new option in login page Server choice

Step 4:

Login with your database username and password.

Step 5:

Enjoy updating your database locally :)