MySQL Forums
Forum List  »  Newbie

Issue in connecting remote MYSQL server to phpmyadmin Error-Wanted to connect my phpmyadmin to second database in different machine entered details in config.inc.php file like this $i++; $cfg['Servers'][$i]['verbose'] = 'Database Server 2'; $cfg['Servers
Posted by: Arunesh Dutta
Date: April 17, 2019 09:28AM

Wanted to connect my phpmyadmin to second database in different machine entered details in config.inc.php file like this

$i++;
$cfg['Servers'][$i]['verbose'] = 'Database Server 2';
$cfg['Servers'][$i]['host'] = 'another mysql system IP address';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

but it's showing "mysqli_real_connect(): (HY000/2002): Connection refused" after entering details, kindly guide

Options: ReplyQuote


Subject
Written By
Posted
Issue in connecting remote MYSQL server to phpmyadmin Error-Wanted to connect my phpmyadmin to second database in different machine entered details in config.inc.php file like this $i++; $cfg['Servers'][$i]['verbose'] = 'Database Server 2'; $cfg['Servers
April 17, 2019 09:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.