[GLLUG] phpMyAdmin Remote DB logon
kens at kensnet.org
Mon Feb 1 00:08:12 UTC 2016
Hi All, I'd like to pick the brains of anyone with some depth on
phpMyAdmin here. I'd like to use it to connect to a db on a server on my
LAN from my laptop.
The normal mysql commands log on and work correctly to the remote db.
I'd just like to see the better presented output that phpmyadmin can do.
I've added this to config.inc.php
/* Server: servername  */
$cfg['Servers'][$i]['verbose'] = 'servername';
$cfg['Servers'][$i]['host'] = 'numericalipaddress';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
I get error 2003 Cannot Login to the mysql server
Using wireshark I don't see any trace of communication to the server
when I try a logon using phpmyadmin. Yet wireshark does show the traffic
if I use normal mysql commands.
So I've missed something that tells phpMyAdmin that the server is not
Before I go tracing through the php code to see what I've missed could
someone who has done this before share any insight please.
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
More information about the GLLUG