| 1 |
brianr |
1.1 |
<?php |
| 2 |
|
|
/** |
| 3 |
|
|
* phpMyAdmin configuration file, you can use it as base for the manual |
| 4 |
|
|
* configuration. For easier setup you can use "setup/". |
| 5 |
|
|
* |
| 6 |
|
|
* All directives are explained in Documentation.html and on phpMyAdmin |
| 7 |
|
|
* wiki <http://wiki.phpmyadmin.net>. |
| 8 |
|
|
*/ |
| 9 |
|
|
|
| 10 |
|
|
/* |
| 11 |
|
|
* This is needed for cookie based authentication to encrypt password in |
| 12 |
|
|
* cookie |
| 13 |
|
|
*/ |
| 14 |
|
|
$cfg['blowfish_secret'] = 'MUSTBECHANGEDONINSTALL'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ |
| 15 |
|
|
|
| 16 |
|
|
/** |
| 17 |
|
|
* Server(s) configuration |
| 18 |
|
|
*/ |
| 19 |
|
|
$i = 0; |
| 20 |
|
|
|
| 21 |
|
|
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use |
| 22 |
|
|
// $cfg['Servers'][0]. You can disable a server config entry by setting host |
| 23 |
|
|
// to ''. If you want more than one server, just copy following section |
| 24 |
|
|
// (including $i incrementation) serveral times. There is no need to define |
| 25 |
|
|
// full server array, just define values you need to change. |
| 26 |
|
|
$i++; |
| 27 |
|
|
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address |
| 28 |
|
|
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port |
| 29 |
|
|
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket |
| 30 |
|
|
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') |
| 31 |
|
|
$cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli') |
| 32 |
|
|
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection |
| 33 |
|
|
// (requires PHP >= 4.3.0) |
| 34 |
|
|
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings |
| 35 |
|
|
// (this user must have read-only |
| 36 |
|
|
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" |
| 37 |
|
|
// and "mysql/db" tables). |
| 38 |
|
|
// The controluser is also |
| 39 |
|
|
// used for all relational |
| 40 |
|
|
// features (pmadb) |
| 41 |
|
|
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)? |
| 42 |
|
|
$cfg['Servers'][$i]['user'] = ''; // MySQL user |
| 43 |
|
|
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed |
| 44 |
|
|
// with 'config' auth_type) |
| 45 |
|
|
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only |
| 46 |
|
|
// this db is displayed in left frame |
| 47 |
|
|
// It may also be an array of db-names, where sorting order is relevant. |
| 48 |
|
|
$cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings |
| 49 |
|
|
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname |
| 50 |
|
|
|
| 51 |
|
|
$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features |
| 52 |
|
|
// (see scripts/create_tables.sql) |
| 53 |
|
|
// - leave blank for no support |
| 54 |
|
|
// DEFAULT: 'phpmyadmin' |
| 55 |
|
|
$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table |
| 56 |
|
|
// - leave blank for no bookmark support |
| 57 |
|
|
// DEFAULT: 'pma_bookmark' |
| 58 |
|
|
$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) |
| 59 |
|
|
// - leave blank for no relation-links support |
| 60 |
|
|
// DEFAULT: 'pma_relation' |
| 61 |
|
|
$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields |
| 62 |
|
|
// - leave blank for no display fields support |
| 63 |
|
|
// DEFAULT: 'pma_table_info' |
| 64 |
|
|
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema |
| 65 |
|
|
// - leave blank for no PDF schema support |
| 66 |
|
|
// DEFAULT: 'pma_table_coords' |
| 67 |
|
|
$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf |
| 68 |
|
|
// - leave blank if you don't want to use this |
| 69 |
|
|
// DEFAULT: 'pma_pdf_pages' |
| 70 |
|
|
$cfg['Servers'][$i]['column_info'] = ''; // table to store column information |
| 71 |
|
|
// - leave blank for no column comments/mime types |
| 72 |
|
|
// DEFAULT: 'pma_column_info' |
| 73 |
|
|
$cfg['Servers'][$i]['history'] = ''; // table to store SQL history |
| 74 |
|
|
// - leave blank for no SQL query history |
| 75 |
|
|
// DEFAULT: 'pma_history' |
| 76 |
|
|
$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables |
| 77 |
|
|
// are up to date. This prevents compatibility |
| 78 |
|
|
// checks and thereby increases performance. |
| 79 |
|
|
$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login |
| 80 |
|
|
$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use |
| 81 |
|
|
= ''; |
| 82 |
|
|
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults |
| 83 |
|
|
= array(); |
| 84 |
|
|
$cfg['Servers'][$i]['AllowNoPassword'] // Allow logins without a password. Do not change the FALSE |
| 85 |
|
|
= FALSE; // default unless you're running a passwordless MySQL server |
| 86 |
|
|
$cfg['Servers'][$i]['designer_coords'] // Leave blank (default) for no Designer support, otherwise |
| 87 |
|
|
= ''; // set to suggested 'pma_designer_coords' if really needed |
| 88 |
|
|
$cfg['Servers'][$i]['bs_garbage_threshold'] // Blobstreaming: Recommented default value from upstream |
| 89 |
|
|
= 50; // DEFAULT: '50' |
| 90 |
|
|
$cfg['Servers'][$i]['bs_repository_threshold'] // Blobstreaming: Recommented default value from upstream |
| 91 |
|
|
= '32M'; // DEFAULT: '32M' |
| 92 |
|
|
$cfg['Servers'][$i]['bs_temp_blob_timeout'] // Blobstreaming: Recommented default value from upstream |
| 93 |
|
|
= 600; // DEFAULT: '600' |
| 94 |
|
|
$cfg['Servers'][$i]['bs_temp_log_threshold'] // Blobstreaming: Recommented default value from upstream |
| 95 |
|
|
= '32M'; // DEFAULT: '32M' |
| 96 |
|
|
/* |
| 97 |
|
|
* End of servers configuration |
| 98 |
|
|
*/ |
| 99 |
|
|
|
| 100 |
|
|
/* |
| 101 |
|
|
* Directories for saving/loading files from server |
| 102 |
|
|
*/ |
| 103 |
|
|
$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload'; |
| 104 |
|
|
$cfg['SaveDir'] = '/var/lib/phpMyAdmin/save'; |
| 105 |
|
|
|
| 106 |
|
|
/* |
| 107 |
|
|
* Disable the default warning that is displayed on the DB Details Structure |
| 108 |
|
|
* page if any of the required Tables for the relation features is not found |
| 109 |
|
|
*/ |
| 110 |
|
|
$cfg['PmaNoRelation_DisableWarning'] = TRUE; |
| 111 |
|
|
?> |
Parent Directory
| 
Revision Log
| 
Revision Graph
