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 |
?> |