PhpMyAdmin (Einträge in der Config-Datei)

edit | delete

Autor: Ralf v.d.Mark

eingetragen: Dienstag, 08. Oktober 2013 um 09:11 Uhr (41/2013 Kalenderwoche)

geändert: Dienstag, 08. Oktober 2013 um 09:11 Uhr (41/2013 Kalenderwoche)

Keywords: config mysql server datenbank adminstration

Kategorien: Apache, DB: MySQL, PHP, DB: MariaDB,

Text:

PhpMyAdmin (aktuelle stabile Version: 4.0.8)


Einstellungen für die Datei
...\phpMyAdmin\config.inc.php


Über dem jeweiligen Block kann man einen Eintrag einstellen, der als Option in der Selectbox dargestellt wird.
$cfg['Servers'][$i]['verbose'] = '[Prod] TBuch-BMELV';


Viele Weitere Einstellungen habe ich beispielhaft im Quellcode gemacht.

Quellcode:   

<?php

/*
 * Servers configuration; Start des Zaehlers
 */
$i = 0;


/*
 * Original: First server, hier Localhost
 */
$i++;
/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['verbose'] = '[localhost] rooti';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '**********'; 
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;//false

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '**********';

/*  phpMyAdmin configuration storage settings. */
/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
/* Contrib / Swekey authentication */
//$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';


$i++; /** DEV-Chef => alle DEV-DBs! */
$cfg['Servers'][$i]['verbose'] = 'DEV-Chef - alle DEV-DBs!';//Anzeige in Selectbox
$cfg['Servers'][$i]['user'] = 'dev_developer';
$cfg['Servers'][$i]['password'] = '**********'; 
$cfg['Servers'][$i]['host'] = 'mydev.zadi.de';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowRoot'] = 1;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;

/* End of servers configuration */

/*
 * phpMyAdmin configuration storage settings.
 *
 * Am Ende der Config-Datei kannst du mit folgenden 
 *    Variablen noch so einiges einstellen.
 */

$cfg['ShowPhpInfo'] = true;
$cfg['ShowDbStructureLastUpdate'] = true;
$cfg['HideStructureActions'] = true;
$cfg['ShowAll'] = true;
$cfg['MaxRows'] = 111;
$cfg['ShowDisplayDirection'] = true;
$cfg['RepeatCells'] = 150;
$cfg['InsertRows'] = 3;
$cfg['blowfish_secret'] = '5245521292a995.18498955';
$cfg['DefaultLang'] = 'de';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['AllowUserDropDatabase'] = true;
$cfg['AllowArbitraryServer'] = true;
$cfg['LoginCookieDeleteAll'] = false;
$cfg['UserprefsDeveloperTab'] = true;
$cfg['Error_Handler']['display'] = true;
$cfg['DBG']['sql'] = true;
$cfg['MaxDbList'] = 111;
$cfg['NumRecentTables'] = 11;
$cfg['ServerDefault'] = 1;
$cfg['MaxCharactersInDisplayedSQL'] = 2222;
$cfg['NavigationLogoLinkWindow'] = '_blank';
$cfg['SuhosinDisableWarning'] = true;
$cfg['McryptDisableWarning'] = true;
$cfg['SaveCellsAtOnce'] = true;
$cfg['InitialSlidersState'] = 'open';
$cfg['TitleTable'] = '@VSERVER@ / @DATABASE@ / @TABLE@ | Ralfs @PHPMYADMIN@ auf @HTTP_HOST@';
$cfg['TitleDatabase'] = '@VSERVER@ / @DATABASE@ | Ralfs @PHPMYADMIN@ auf @HTTP_HOST@';
$cfg['TitleServer'] = '@VSERVER@  | Ralfs @PHPMYADMIN@ auf @HTTP_HOST@';
$cfg['TitleDefault'] = 'Ralfs @PHPMYADMIN@ auf @HTTP_HOST@';
$cfg['SkipLockedTables'] = true;
$cfg['LoginCookieDeleteAll'] = false; 
?>