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 3 years ago
Be the first to leave a comment.
You must login to leave a comment