Forum Moderators: coopster

Message Too Old, No Replies

phpMyAdmin multiple databases

configuring config.ini.php for multiple db's

         

twist

11:28 pm on Oct 4, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I would have thought this would be a common question but I am having no luck it seems searching for it. My new webhost gives me 5 databases for my website, my old host only had 1. I read somewhere how to setup your config.ini.php file in phpMyAdmin for multiple databases. I tried it and got the drop down menu but also recieved errors.

The article I read said to just make a copy of this,

$cfg['Servers'][$i]['host'] = 'host.com';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'user';
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['only_db'] = 'name';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';
$cfg['Servers'][$i]['bookmarktable'] = '';
$cfg['Servers'][$i]['relation'] = '';
$cfg['Servers'][$i]['table_info'] = '';
$cfg['Servers'][$i]['table_coords'] = '';
$cfg['Servers'][$i]['pdf_pages'] = '';
$cfg['Servers'][$i]['column_info'] = '';
$cfg['Servers'][$i]['history'] = '';
$cfg['Servers'][$i]['verbose_check'] = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();

and put it below the first one using different information. It isn't working correctly though. Any help would be appreciated.

Timotheos

5:25 pm on Oct 5, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



What you're talking about here is setting up phpMyAdmin for multiple servers (not multiple databases). You shouldn't have to do anything to the config file to see more then one database. I'd set it back to the default and tell us what sort of errors you are getting.

twist

6:37 pm on Oct 5, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thanks, I got it.