0

How to access the remote Database Server using phpmyadmin

Hello,I was using heidisql to access the database,but its lagging a lot and its too slow to process the queries,When i ahve searched for the alternative ,I have come across the phpmyadmin.I just want to know the method to access the mysql database server remotely in phpmyadmin

phpMyAdmin Remote desktop Add a comment
Aditya
asked Nov 11 2019

Answer

0

Navigate to the following location where laragon or wamp server has been installed.

Go to the f:/laragon/etc/apps/phpMyAdmin/

open the config.inc.php file

Add the following details at the end of the php file in order to access the remote databse server

$i++;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '192.168.12.12';
$cfg['Servers'][$i]['user'] = 'MTYBUSER';
$cfg['Servers'][$i]['password'] = 'CG)[ACH.C!;-';
$cfg['Servers'][$i]['port'] = '3306';

Open the phpmyadmin and enter the credentials and access the remote server

Add a comment
linuxhelp
asked Nov 11 2019
Post your Answer