How to connect local PhpMyAdmin to remote server

How to connect local PhpMyAdmin to remote server

2,822

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 :)

- Last updated 2 years ago

Be the first to leave a comment.

You must login to leave a comment