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

Aditya
asked Nov 11, 2019
1 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

View More
linuxhelp
answered Nov 11, 2019
Your Answer
||||
x
 
100:0