I am able to successfully login and query a remote database with my command line using the following:
mysql --user=username --password stagingdb -h 10.0.0.2
However, when I try to do the same thing with phpMyAdmin I keep getting the error:
#1045 Cannot log in to the MySQL server
I have a config.inc.php that was generated by the wizard looking like this:
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.5.2 setup script
* Date: Mon, 23 Jul 2012 21:00:08 +1000
*/
/* Servers configuration */
$i = 0;
/* Server: migration [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'staging';
$cfg['Servers'][$i]['host'] = '10.0.0.2';
$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'] = '';
/* End of servers configuration */
$cfg['blowfish_secret'] = '500d2cccc6b664.98154413';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
What am I doing wrong?
