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()); } } ?>
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.