topic Re: Adding a second database? in Archive

Adding a second database?

jimbly2 — Mon, 14 Sep 2009 10:19:48 GMT

Hi - I have created a database using DB manager and it appears in phpMyAdmin and works fine. I now want to create a second database - again created in DB manager fine, but won't appear in phpMyAdmin?

I wondered if you had to have a separate user for each database, so tried that, but then can't get second user to show in phpMyAdmin??

Re: Adding a second database?

jimbly2 — Mon, 14 Sep 2009 17:38:21 GMT

bump

Re: Adding a second database?

dave — Mon, 14 Sep 2009 17:42:29 GMT

You need to make sure both databases are under the same user first. Then you need to edit the phpmyadmin configuration string... I will get back to you on that.

Re: Adding a second database?

dave — Thu, 17 Sep 2009 15:33:25 GMT

OK, the following will only work if both databases are created under the same user, so please make sure they are. Also it is a good idea to make a backup copy of the file before you edit it.

If you've not already done so, install phpmyadmin and select any of the databases belonging to that user.

Once installed, you need to edit the file /private/phpmyadmin/config.inc.php

Find the line that looks like:

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

change it to:

$cfg['Servers'][$i]['only_db'] = array('dbname\_yourdomaini\_com', 'dbname2\_yourdomain\_com');

Substitute the obvious parts for your actual database names

Message Edited by dave on 14-09-2009 07:43 PM

Message Edited by dave on 17-09-2009 04:33 PM

Re: Adding a second database?

jimbly2 — Mon, 14 Sep 2009 21:08:36 GMT

Cool - thanks Dave - will give it a go tomorrow 🙂

Re: Adding a second database?

jimbly2 — Thu, 17 Sep 2009 10:36:18 GMT

Didn't work 😞

Re: Adding a second database?

dave — Thu, 17 Sep 2009 11:25:08 GMT

You will need to open a new browser window before it displays both databases.

If that doesn't work you have possibly got the syntax slightly wrong. Please can you post the full line that I mentioned and I will check the syntax.

Message Edited by dave on 17-09-2009 12:25 PM

Re: Adding a second database?

jimbly2 — Thu, 17 Sep 2009 15:06:21 GMT

Hi Dave,

ok - the line i have is:

$cfg['Servers'][$i]['only_db'] = array('corpevents\_corporate-events\_co\_uk', 'corp_members\_corporate-events\_co\_uk') ;

..thanks,

jim

Re: Adding a second database?

dave — Thu, 17 Sep 2009 15:32:52 GMT

try:

$cfg['Servers'][$i]['only_db'] = array('corpevents\_corporate-events\_co\_uk', 'corp\_members\_corporate-events\_co\_uk');

Re: Adding a second database?

Danny_Wobble — Thu, 16 Oct 2014 14:13:38 GMT

Hi Dave,

I'm having exactly the same issue as jimbly2. I need to make the changes to the config.php file you mention.

My problem is that I can't access the file in Dreamweave or Filezilla in order to edit the file. I also can't get to the file through the BT Advanced File manager either.

Could you please help me to find a way to edit that file? Also strangley in Filezilla the phpmyadmin directory turns up as a black icon instand of the standard folder/directory icon. Any dea why this might be?

The black icon seems to be a result of why I can't get into the phpmyadmin directory to view the config.inc.php file.

Many thanks,

Daniel.

Re: Adding a second database?

Danny_Wobble — Thu, 16 Oct 2014 14:16:13 GMT

Bump to my above message as I can see that "Dave" no longer works for BT and so not sure if anyone will see my message.

Thanks.

Daniel.