#1  
Old 13th August 2007, 04:40
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default multiple databases

Hello everyone,

I need a little bit of help. I am trying to set up more than one site on my server and I am trying to set up phpmyadmin on each site but with different databases. I installed phpmyadmin into a new directory for the second site but now it shows all of the first sites databases. How can i fix this?

Here is a print out of my config.inc.php file:

<?php /** * Please, do not edit this file. The configuration file for Debian system * is located at /etc/phpmyadmin directory. */ // Load secret generated on postinst include('/etc/phpmyadmin/blowfish_secret.inc.php'); // Load autoconf local config include('config/config.inc.php'); // Load user's local config include('/etc/phpmyadmin/config.inc.php'); // Set the default server if there is no defined if (!isset($cfg['Servers'])) { $cfg['Servers'][1]['host'] = 'localhost'; } // Set the default values for $cfg['Servers'] entries for ($i=1; (!empty($cfg['Servers'][$i]['host']) || (isset($cfg['Servers'][$i]['connect_type']) && $cfg['Servers'][$i]['connect_type'] == 'socket')); $i++) { if (!isset($cfg['Servers'][$i]['host'])) { $cfg['Servers'][$i]['host'] = ''; } if (!isset($cfg['Servers'][$i]['port'])) { $cfg['Servers'][$i]['port'] = ''; } if (!isset($cfg['Servers'][$i]['socket'])) { $cfg['Servers'][$i]['socket'] = ''; } if (!isset($cfg['Servers'][$i]['connect_type'])) { $cfg['Servers'][$i]['connect_type'] = 'tcp'; } if (!isset($cfg['Servers'][$i]['extension'])) { $cfg['Servers'][$i]['extension'] = 'mysql'; } if (!isset($cfg['Servers'][$i]['compress'])) { $cfg['Servers'][$i]['compress'] = FALSE; } if (!isset($cfg['Servers'][$i]['controluser'])) { $cfg['Servers'][$i]['controluser'] = ''; } if (!isset($cfg['Servers'][$i]['controlpass'])) { $cfg['Servers'][$i]['controlpass'] = ''; } if (!isset($cfg['Servers'][$i]['auth_type'])) { $cfg['Servers'][$i]['auth_type'] = 'cookie'; } if (!isset($cfg['Servers'][$i]['user'])) { $cfg['Servers'][$i]['user'] = 'root'; } if (!isset($cfg['Servers'][$i]['password'])) { $cfg['Servers'][$i]['password'] = ''; } if (!isset($cfg['Servers'][$i]['only_db'])) { $cfg['Servers'][$i]['only_db'] = ''; } if (!isset($cfg['Servers'][$i]['verbose'])) { $cfg['Servers'][$i]['verbose'] = ''; } if (!isset($cfg['Servers'][$i]['pmadb'])) { $cfg['Servers'][$i]['pmadb'] = ''; } if (!isset($cfg['Servers'][$i]['bookmarktable'])) { $cfg['Servers'][$i]['bookmarktable'] = ''; } if (!isset($cfg['Servers'][$i]['relation'])) { $cfg['Servers'][$i]['relation'] = ''; } if (!isset($cfg['Servers'][$i]['table_info'])) { $cfg['Servers'][$i]['table_info'] = ''; } if (!isset($cfg['Servers'][$i]['table_coords'])) { $cfg['Servers'][$i]['table_coords'] = ''; } if (!isset($cfg['Servers'][$i]['pdf_pages'])) { $cfg['Servers'][$i]['pdf_pages'] = ''; } if (!isset($cfg['Servers'][$i]['column_info'])) { $cfg['Servers'][$i]['column_info'] = ''; } if (!isset($cfg['Servers'][$i]['history'])) { $cfg['Servers'][$i]['history'] = ''; } if (!isset($cfg['Servers'][$i]['verbose_check'])) { $cfg['Servers'][$i]['verbose_check'] = TRUE; } if (!isset($cfg['Servers'][$i]['AllowRoot'])) { $cfg['Servers'][$i]['AllowRoot'] = TRUE; } if (!isset($cfg['Servers'][$i]['AllowDeny'])) { $cfg['Servers'][$i]['AllowDeny'] = array ('order' => '', 'rules' => array()); } } ?>
Reply With Quote
Sponsored Links
  #2  
Old 13th August 2007, 09:28
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,774
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
 
Default

Hi,

the permissions have nothing to do with phpmyadmin. The permissions are stored in the database. It is not nescessary and not recommended to install a phpmyadmin fo every site.

Just use the username and password of a database that you created for this site in ISPConfig to login to phpmyadmin and you will only see the database of the site.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPconfig to host multiple domains in one IP with multiple DynDns addresses agelospanagiotakis Installation/Configuration 23 2nd April 2008 11:10
BUG counting reseller's databases Davide Installation/Configuration 4 11th August 2006 08:45
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 04:19
site - databases trueshanti Installation/Configuration 20 26th May 2006 01:28
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45


All times are GMT +2. The time now is 10:34.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.