| 168 |
- |
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'] = 'ST4K68duJBWUsdoPHCdNu1WSYZL8Z8Oi'; /* 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 |
?>
|