Having “PHPMyAdmin” setup is most useful when working with a large number of the more sophisticated, MySQL driven, web applications out there, however, setting it up is not always as easy as it should be… Having been through a LOT of tooing & froing with “Fasthosts“, my (now previous) web host, I include below the swiftest way to overcome what initially may seem like insurmountable problems!
Firstly, ignore all setup processes / guides and simply upload phpmyadmin & create a blank “config.inc.php” file and paste the following into it and upload into phpmyadmin’s root directory;
***********************************************
<?php
$i=0;
$i++;
$cfg[‘blowfish_secret’]=’RandomAlphaNumericStringHere’; // For use in cookie authentication
$cfg[‘Servers’][$i][‘host’]=’FHDBServerIPAddress’; // Your database server’s IP address
$cfg[‘Servers’][$i][‘auth_type’]=’cookie’; // Authentication method – config, http or cookie
$cfg[‘Servers’][$i][‘user’]=’FHDBUsername’; // Your FH database username
$cfg[‘Servers’][$i][‘password’]=’FHDBPassword’; // Your FH database user’s password
?>
***********************************************
You don’t need both “database” & “db” variables, but I haven’t tested which is not needed yet! (Let me know if you have time to test it).