Connect to external server by using phpMyAdmin

The below lines of code can be added to the /etc/phpmyadmin/config.inc.php file at the bottom −

$i++;
$cfg['Servers'][$i]['host'] = 'HostName:port'; 
// hostname and port are provided if they are not default values
$cfg['Servers'][$i]['user'] = 'userName'; 
//user name for the remote server
$cfg['Servers'][$i]['password'] = 'Password'; 
//the password
$cfg['Servers'][$i]['auth_type'] = 'config';

It will display “Current Server:” with drop down of both "127.0.0.1" and the one provided with $cfg['Servers'][$i]['host'].

The user can switch between both the servers.

AmitDiwan

Updated on 06-Apr-2020 08:44:04

• Related Questions & Answers
• Using SAP JCO to connect SAP server to JAVA application
• How to connect to SSH using PowerShell?
• How to add auto-increment to column in MySQL database using PhpMyAdmin?
• How to connect to my MongoDB table by command line?
• Using JCo to connect SAP with Android
• How to connect Azure Account using PowerShell?
• How to open External Programs using Tkinter?
• How to connect to Chromium Headless using Selenium?
• Calling external programs using SAP connector
• Python program to Order Tuples using external List
• How to specify Decimal Precision and scale number in MySQL database using PHPMyAdmin?
• How to connect to Derby database using a JDBC program?
• How to connect to HSQLDB database using a JDBC program?
• How to connect to PostgreSQL database using a JDBC program?
• How to force MySQL to connect by TCP instead of a Unix socket?