Tuesday, August 3, 2010

Facing issues in setting up phpMyAdmin

Few days back I was installing phpMyAdmin at my local machine in order to access the MySQL database, I found that when I access the phpMyAdmin URL it does not even ask for the login information i.e. database username and password and just shows the following message :

phpMyAdmin – 2.10.1

  • (Servers) … localhost <input type=”submit” value=”Go” />
  • Language : Afrikaans (iso-8859-1) Afrikaans (utf-8) Shqip – Albanian (iso-8859-1) Shqip – Albanian (utf-8) العربية – Arabic (utf-8) العربية – <input type=”submit” value=”Go” />
  • Theme / Style: Darkblue/orangeOriginal<input type=”submit” value=”Go” />
  • 50% 60% 70% 103% 104% 105% 110% 120% 130% 140% 150% <input type=”submit” value=”Go” />
  • phpMyAdmin documentation
  • phpMyAdmin wiki
  • Official phpMyAdmin Homepage
  • [ChangeLog] [Subversion] [Lists]
Invalid server index: “”

After googling around I found that this problem was occurring due to a undefined variable in the “config.inc.php” file. In order to resolve the situation I wrote the following lines of code inside “config.inc.php” file and now it is working fine.

$i=1;
$cfg['PmaAbsoluteUri'] = ‘http://localhost/phpMyadmin/’;
$cfg['blowfish_secret'] = ‘holla’;
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ‘myrootpassword’;
?&gt;

No comments: