Last active
April 20, 2021 16:04
-
-
Save punit5658/cb5326f321f3b7d4a85c9b71eccc78a9 to your computer and use it in GitHub Desktop.
How to access remote MySql using local phpmyadmin
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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