phpmyadmin 的配置 可实现记录即使操作，登陆管理多个DB等

开启记录history的参数是以下这个，当设置为true后就能将用户操作的sql记录在配合pmyadmin的pma_history中
$ cfg [ 'QueryHistoryDB' ]   =   'true' ;   //enable phpmyadmin record user sql

点击(此处)折叠或打开

1. 
   
2. <?php
   
3. /**
   
4.  * Debian local configuration file
   
5.  *
   
6.  * This file overrides the settings made by phpMyAdmin interactive setup
   
7.  * utility.
   
8.  *
   
9.  * For example configuration see
   
10.  * /usr/share/doc/phpmyadmin/examples/config.sample.inc.php
    
11.  * or
    
12.  * /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php
    
13.  *
    
14.  * NOTE: do not add security sensitive data to this file (like passwords)
    
15.  * unless you really know what you're doing. If you do, any user that can
    
16.  * run PHP or CGI on your webserver will be able to read them. If you still
    
17.  * want to do this, make sure to properly secure the access to this file
    
18.  * (also on the filesystem level).
    
19.  */
    
20. 
    
21. if (!function_exists('check_file_access')) {
    
22.     function check_file_access($path)
    
23.     {
    
24.      if (is_readable($path)) {
    
25.         return true;
    
26.      } else {
    
27.         error_log(
    
28.          'phpmyadmin: Failed to load ' . $path
    
29.          . ' Check group www-data has read access and open_basedir restrictions.'
    
30.         );
    
31.         return false;
    
32.      }
    
33.     }
    
34. }
    
35. 
    
36. // Load secret generated on postinst
    
37. if (check_file_access('/var/lib/phpmyadmin/blowfish_secret.inc.php')) {
    
38.     require('/var/lib/phpmyadmin/blowfish_secret.inc.php');
    
39. }
    
40. 
    
41. // Load autoconf local config
    
42. if (check_file_access('/var/lib/phpmyadmin/config.inc.php')) {
    
43.     require('/var/lib/phpmyadmin/config.inc.php');
    
44. }
    
45. 
    
46. /**
    
47.  * Server(s) configuration
    
48.  */
    
49. $i = 0;
    
50. // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
    
51. // You can disable a server config entry by setting host to ''.
    
52. $i++;
    
53. 
    
54. /**
    
55.  * Read configuration from dbconfig-common
    
56.  * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin
    
57.  */
    
58. if (check_file_access('/etc/phpmyadmin/config-db.php')) {
    
59.     require('/etc/phpmyadmin/config-db.php');
    
60. }
    
61. 
    
62. /* Configure according to dbconfig-common if enabled */
    
63. if (!empty($dbname)) {
    
64.     /* Authentication type */
    
65.     $cfg['Servers'][$i]['auth_type'] = 'cookie';
    
66.     /* Server parameters */
    
67.     if (empty($dbserver)) $dbserver = 'localhost';
    
68.     $cfg['Servers'][$i]['host'] = $dbserver;
    
69. 
    
70.     if (!empty($dbport) || $dbserver != 'localhost') {
    
71.         $cfg['Servers'][$i]['connect_type'] = 'tcp';
    
72.         $cfg['Servers'][$i]['port'] = $dbport;
    
73.     }
    
74.     //$cfg['Servers'][$i]['compress'] = false;
    
75.     /* Select mysqli if your server has it */
    
76.     $cfg['Servers'][$i]['extension'] = 'mysqli';
    
77.     /* Optional: User for advanced features */
    
78.     $cfg['Servers'][$i]['controluser'] = $dbuser;
    
79.     $cfg['Servers'][$i]['controlpass'] = $dbpass;
    
80. 
    
81.     $cfg['QueryHistoryDB'] = 'true'; //enable phpmyadmin record user sql
    
82.     //$cfg['QueryHistoryMax'] = '100'; //specify the amount of saved history sql
    
83.     // Allow connection to server name ending with -mysql:
    
84.     $cfg['ArbitraryServerRegexp'] = '@^[^:]\-mysql$@';
    
85.     /* Optional: Advanced phpMyAdmin features */
    
86.     $cfg['Servers'][$i]['pmadb'] = $dbname;
    
87.     $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
    
88.     $cfg['Servers'][$i]['relation'] = 'pma__relation';
    
89.     $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
    
90.     $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
    
91.     $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
    
92.     $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
    
93.     $cfg['Servers'][$i]['history'] = 'pma__history';
    
94.     $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
    
95.     $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
    
96.     $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
    
97.     $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
    
98.     $cfg['Servers'][$i]['recent'] = 'pma__recent';
    
99.     
    
100.     /* Uncomment the following to enable logging in to passwordless accounts,
     
101.      * after taking note of the associated security risks. */
     
102.     // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
     
103. 
     
104.     /* Advance to next server for rest of config */
     
105.     $i++;
     
106. }
     
107. 
     
108. /* Server: XXXXXX.com,1234 [1] */
     
109. $i++;
     
110. $cfg['Servers'][$i]['verbose'] = 'XXXXXX.com,1234';
     
111. $cfg['Servers'][$i]['host'] = 'XXXXXX.com';
     
112. $cfg['Servers'][$i]['port'] = 1234;
     
113. $cfg['Servers'][$i]['socket'] = '';
     
114. $cfg['Servers'][$i]['connect_type'] = 'tcp';
     
115. $cfg['Servers'][$i]['extension'] = 'mysql';
     
116. $cfg['Servers'][$i]['auth_type'] = 'cookie';
     
117. $cfg['Servers'][$i]['user'] = '';
     
118. $cfg['Servers'][$i]['password'] = '';
     
119. $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
     
120. $cfg['Servers'][$i]['controluser'] = 'pma';
     
121. $cfg['Servers'][$i]['controlpass'] = 'pmapassword';
     
122. $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
     
123. $cfg['Servers'][$i]['relation'] = 'pma__relation';
     
124. $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
     
125. $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
     
126. $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
     
127. $cfg['Servers'][$i]['history'] = 'pma__history';
     
128. $cfg['Servers'][$i]['recent'] = 'pma__recent';
     
129. $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
     
130. $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
     
131. $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
     
132. $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
     
133. $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
     
134. $cfg['Servers'][$i]['tracking_version_auto_create'] = true;
     
135. 
     
136. 
     
137. $cfg['QueryHistoryDB'] = 'true'; //enable phpmyadmin record user sql
     
138. //$cfg['QueryHistoryMax'] = '100'; //specify the amount of saved history sql
     
139. /* End of servers configuration */
     
140. 
     
141. 
     
142. /* Authentication type */
     
143. //$cfg['Servers'][$i]['auth_type'] = 'cookie';
     
144. /* Server parameters */
     
145. //$cfg['Servers'][$i]['host'] = 'localhost';
     
146. //$cfg['Servers'][$i]['connect_type'] = 'tcp';
     
147. //$cfg['Servers'][$i]['compress'] = false;
     
148. /* Select mysqli if your server has it */
     
149. //$cfg['Servers'][$i]['extension'] = 'mysql';
     
150. /* Optional: User for advanced features */
     
151. // $cfg['Servers'][$i]['controluser'] = 'pma';
     
152. // $cfg['Servers'][$i]['controlpass'] = 'pmapass';
     
153. 
     
154. /* Storage database and tables */
     
155. // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
     
156. // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
     
157. // $cfg['Servers'][$i]['relation'] = 'pma_relation';
     
158. // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
     
159. // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
     
160. // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
     
161. // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
     
162. // $cfg['Servers'][$i]['history'] = 'pma_history';
     
163. // $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
     
164. // $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
     
165. // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
     
166. // $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
     
167. // $cfg['Servers'][$i]['recent'] = 'pma_recent';
     
168. /* Uncomment the following to enable logging in to passwordless accounts,
     
169.  * after taking note of the associated security risks. */
     
170. // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
     
171. 
     
172. /*
     
173.  * End of servers configuration
     
174.  */
     
175. 
     
176. /*
     
177.  * Directories for saving/loading files from server
     
178.  */
     
179. $cfg['UploadDir'] = '';
     
180. $cfg['SaveDir'] = '';
     
181. 
     
182. /* Support additional configurations */
     
183. foreach (glob('/etc/phpmyadmin/conf.d/*.php') as $filename)
     
184. {
     
185.     include($filename);
     
186. }
     
187. /* Display warning on main page if the MySQL library and server version is diff */
     
188. $cfg['ServerLibraryDifference_DisableWarning'] = 'true';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16131092/viewspace-2133303/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16131092/viewspace-2133303/