phpmyadmin怎么配置

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

创新互联建站专业为企业提供海原网站建设、海原做网站、海原网站设计、海原网站制作等企业网站建设、网页设计与制作、海原企业网站模板建站服务，十载海原做网站经验，不只是建网站，更提供有价值的思路和整体网络服务。

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

点击(此处)折叠或打开

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.  */

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. }

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. }

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. }

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++;

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. }

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;

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;

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;

104.     /* Advance to next server for rest of config */

105.     $i++;

106. }

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;

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 */

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';

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;

172. /*

173.  * End of servers configuration

174.  */

176. /*

177.  * Directories for saving/loading files from server

178.  */

179. $cfg['UploadDir'] = '';

180. $cfg['SaveDir'] = '';

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怎么配置”有了一定的了解，如果想了解更多相关知识，欢迎关注创新互联行业资讯频道，感谢各位的阅读！