Skip to content

Instantly share code, notes, and snippets.

@punit5658
Last active April 20, 2021 16:04
Show Gist options
  • Save punit5658/cb5326f321f3b7d4a85c9b71eccc78a9 to your computer and use it in GitHub Desktop.
Save punit5658/cb5326f321f3b7d4a85c9b71eccc78a9 to your computer and use it in GitHub Desktop.
How to access remote MySql using local phpmyadmin
Open Location of phpMyAdmin and edit : config.inc.php ( Command : sudo vi config.inc.php )
Add following line to end of the file :
<?php
$i++;
$cfg['Servers'][$i]['host'] = '192.168.1.133';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['TempDir'] = 'tmp';
?>
create directory 'tmp' at same directory if not exist(Command: mkdir tmp )
Allow access permission : 0777 ( Command : chown -R 777 tmp )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment