phpmyadmin怎么配置

小编给大家分享一下phpmyadmin怎么配置，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

开启记录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';

看完了这篇文章，相信你对“phpmyadmin怎么配置”有了一定的了解，如果想了解更多相关知识，欢迎关注亿速云行业资讯频道，感谢各位的阅读！