<?php /*************************/ /* */ /* Sphere "Bleu" */ /* */ /*************************/ $cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ $i = 0; /******************************************/ /* */ /* Serveur : LocalHost pour MySql */ /* */ /******************************************/ $i++; /*---------------------*/ /* Authentication type */ /*---------------------*/ $cfg['Servers'][$i]['auth_type'] = 'http'; /*-------------------*/ /* Server parameters */ /*-------------------*/ $cfg['Servers'][$i]['verbose'] = 'MySql'; $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; /*--------------------------------------------------*/ /* Select mysql if your server does not have mysqli */ /*--------------------------------------------------*/ $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = false; /*-------------------------------------------*/ /* phpMyAdmin configuration storage settings */ /*-------------------------------------------*/ $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|phpmyadmin|ibdata)'; /*--------------------------------------*/ /* User used to manipulate with storage */ /*--------------------------------------*/ $cfg['Servers'][$i]['controlhost'] = ''; $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'root'; /*-----------------------------*/ /* Storage database and tables */ /*-----------------------------*/ $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; $cfg['Servers'][$i]['history'] = 'pma__history'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; $cfg['Servers'][$i]['relation'] = 'pma__relation'; $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['users'] = 'pma__users'; $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; /********************************************/ /* */ /* Serveur : LocalHost pour MariaDB */ /* */ /********************************************/ $i++; /*---------------------*/ /* Authentication type */ /*---------------------*/ $cfg['Servers'][$i]['auth_type'] = 'http'; /*-------------------*/ /* Server parameters */ /*-------------------*/ $cfg['Servers'][$i]['verbose'] = 'MariaDB'; $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['port'] = '3307'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; /*--------------------------------------------------*/ /* Select mysql if your server does not have mysqli */ /*--------------------------------------------------*/ $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = false; /*-------------------------------------------*/ /* phpMyAdmin configuration storage settings */ /*-------------------------------------------*/ $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|phpmyadmin|ibdata)'; /*--------------------------------------*/ /* User used to manipulate with storage */ /*--------------------------------------*/ $cfg['Servers'][$i]['controlhost'] = ''; $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'root'; /*-----------------------------*/ /* Storage database and tables */ /*-----------------------------*/ $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords'; $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; $cfg['Servers'][$i]['history'] = 'pma__history'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; $cfg['Servers'][$i]['relation'] = 'pma__relation'; $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['users'] = 'pma__users'; $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; /*******************************/ /* */ /* Divers hors serveur */ /* */ /*******************************/ /*----------------------------------*/ /* Removes the warning tables pmadb */ /*----------------------------------*/ //$cfg['PmaNoRelation_DisableWarning'] = true; /*----------------------------*/ /* Generic parameters */ /*----------------------------*/ $cfg['AllowUserDropDatabase'] = false; $cfg['ServerDefault'] = 1; $cfg['ShowHint'] = true; $cfg['VersionCheck'] = true; /*--------------------------------------*/ /* Setting the navigation panel */ /*--------------------------------------*/ $cfg['NumRecentTables'] = 0; $cfg['NumFavoriteTables'] = 0; $cfg['NavigationDisplayServers'] = false; /*--------------------*/ /* Main Panel */ /*--------------------*/ $cfg['ShowPhpInfo'] = true; /*----------------*/ /* Langue */ /*----------------*/ $cfg['DefaultLang'] = 'fr'; $cfg['DefaultConnectionCollation'] = 'latin1_general_ci'; /*--------------------------------*/ /* Customizing the design */ /*--------------------------------*/ //$cfg['DefaultDisplay'] = 'vertical'; /*---------------------------------------------------*/ /* Web server upload/save/import directories */ /*---------------------------------------------------*/ $cfg['SaveDir'] = ''; $cfg['UploadDir'] = ''; ?>En premier, j'ai mysql et en second, j'ai mariadb.