phpmyadmin - can't see databases

[samk]

Hi,

When I log into my php_myadmin I can only see the one table: phpmy1_domain_com. 

But there are at least two other databases on there, as I have Joomla and phpBB up and running on the website!

Have I not done something to let me view the databases in php_myadmin?  Proof that the database must be there can be seen at www.meridiancanoeclub.com/phpBB3

Thanks,

Sam

[samk]

Just something else I've noticed.  If I try to create another database in the website centre, it says I can only create a maximum of 3 databases.  I've tried creating another user and get the same message.  We can't be limited to 3 databases surely??

[dave · Accepted solution]

You are correct in saying that you are limited to 3 databases.

The phpMyAdmin by default can only be installed for one database at a time, however you can make it show 2 or 3 databases by editing the config file.

Firstly, this will only work if your databases are all set up under the same database user so make sure that this is the case.

Open the file /private/phpmyadmin/config.inc.php

Find the line that looks like the line below and change it as follows:

$cfg['Servers'][$i][only_db] = 'xxxxxx\_yourdomain\_com';

 for 2 databases change it to:

$cfg['Servers'][$i][only_db] = array('xxxxxx\_yourdomain\_com', 'yyyyyy\_yourdomain\_com');

 for 3 databases change it to:

$cfg['Servers'][$i][only_db] = array('xxxxxx\_yourdomain\_com', 'yyyyyy\_yourdomain\_com', 'zzzzzz\_yourdomain\_com');

[samk]

Hi Dave,

Thanks a lot for that, it worked a treat! Any ideas on why we're limited to three databases?  Do most people just use one database and throw all of the tables in the one place?  Seems odd to me but I'm no expert...

[dave]

Not sure why you are limited to three but some hosts limit you to 2 or 1.

It is possible though for things like Joomla, phpBB, mediawiki, etc to all share the one database. Provided you use a different prefix for the tables, they will work fine.

I have even ran 2 phpBB installs from the 1 database with no issues.