0

I have a site hosted on Rackspace Cloud. It runs Joomla 2.5, some test scripts, and PHPMyAdmin 4.1.6. Joomla runs off a database hosted in Rackspace Cloud. The host is mysql50-[redacted].wc2.dfw1.stabletransit.com I am able to take Joomla's settings and put them in a simple PHP script that runs mysqli_connect and read the database.

However, I am not able to get a PHPMyAdmin installation in a subfolder of the Joomla directory to connect. I PHPMyAdmin's setup and it generated this config file:

$cfg['Servers'][$i]['verbose'] = 'description';
$cfg['Servers'][$i]['host'] = 'mysql50-[redacted].wc2.dfw1.stabletransit.com';
$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]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

No other modification to PHPMyAdmin was done.

It seems to match the settings used by Joomla and the test scripts, but every time I connect, I receive a #2002 Cannot log in to the MySQL server error. This error occurs no matter what username/password I use, hostname I use, or connection method/type I use. What is different about PHPMyAdmin that it fails to connect where Joomla and a simple mysqli_connect succeed?

Michael
  • 125
  • 5

1 Answers1

1

Ensure the generated config file is in your root phpMyAdmin folder so it reads the proper file.

Nathan C
  • 15,059
  • 4
  • 43
  • 62