Managing multiple databases

[chillifish]

I have managed to create two databases via the database manager. However, when I install phpmyadmin, it only lets me choose one of those databases to manage at install.

Can't create new databases from within phpmyadmin as that feature has been removed, presumably by BT to make sure you don't go over your 3 database limit.

Any ideas?

[chillifish]

Was promised a call back within four hours over four hours ago. I have to say, this hosting is awful, I will be recommending any clients in future don't use it. It's expensive as well.

Good to see the web side of things is as awful as the residential telephone side. Good old BT.

[chillifish]

Woohoo, got my call back in the end! The answer, if anyone needs to know for the future is to create your databases, install phpmyadmin and then contact BT. The will amend the config files to sort it out. I can only assume this is on their developers list of things to fix.

[chillifish · Accepted solution]

Managed to work out how to do it. Login through your ftp to find private/phpmyadmin/config.inc.php

Line 64 the line reads:

$cfg['Servers'][$i]['only_db'] = 'your_database_name';

Where 'your_database_name' is the name of your database.

You need to change the line to:

$cfg['Servers'][$i]['only_db'] = array ('your_database_name_1', 'your_database_name_2');