Home > Developer > PHP

PHPMyadmin configuration file (Classic)

Source: Internet
Author: User
Tags php error reporting
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
PHPMyadmin configuration file (Classic)

  2. $ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name
  3. Fg ['servers'] [$ I] ['password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql User name

D. authentication method $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; there are four modes available here: cookie, http, HTTP, in config mode, you can directly access the phpmyadmin access url without entering the user name and password. it is insecure and is not recommended. When this option is set to cookie, http or HTTP, you need to use the data username and password for verification to log on to phpmyadmin. for details, refer to the following: PHP installation mode is Apache, and http and cookie can be used; the PHP installation mode is CGI and cookie can be used.

E. set the phrase password (blowfish_secret) $ cfg ['blowfish _ secret '] = ''; if the authentication method is set to cookie, you need to set the phrase password and set the password, it is up to you to decide, but you cannot leave it blank. Otherwise, you will be prompted when you log on to phpmyadmin that the error is successfully installed.

Note: This document only describes the basic configuration for installing phpmyadmin. for details about the configuration parameters in the config. default. php file, you can

The following describes how to install phpMyAdmin.

1, download 1, first to the official site to download phpMyAdmin installation package: http://www.phpmyadmin.net/(installation contains all-languages) 2, and then decompress the web can access the Directory, if the virtual space, you can decompress the package and upload it to the web Directory using the ftp tool. you can also modify the name of the extracted File (you can customize the directory name ).

2. configure 3. open/libraries/config. default. php file (the old version is config in the root directory. inc. php file), use a Wordpad (do not use notepad, this is UTF8 encoding) for editing, follow the instructions to configure. 4. search for $ cfg ['pmaabsoluteuri '] = ''; // modify the phpMyAdmin URL that will be uploaded to the space, for example, $ cfg ['pmaabsoluteuri'] = 'http: // website domain name/phpmyadmin/'; 5. search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // The default value is usually used, there are also exceptions. you do not need to modify 6. search for $ cfg ['servers'] [$ I] ['auth _ type'] = 'config '; // debug config in your own machine; if the network space uses cookies. there are four modes to choose from: cookie, http, HTTP, config ① config: you can directly access the phpMyAdmin access url without entering the user name and password, which is insecure, it is not recommended. ② Set the cookie, http, and HTTP methods. to log on to phpMyAdmin, you need the data username and password for verification. Specifically, the PHP installation mode is Apache, and http and cookie can be used. The PHP installation mode is CGI and cookie can be used. 7. find $ cfg ['servers'] [$ I] ['user'] = 'root '; // MySQL username 8. find $ cfg ['servers'] [$ I] ['password'] = ''; // MySQL password (leave only needed blank) 9. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // you can set only one data, set your database name. if you want to set up a server, we recommend that you leave 10 blank and search for $ cfg ['defaultlang '] = 'zh'; // select a language, zh stands for simplified Chinese 11, search for $ cfg ['blowfish _ secret'] = ''; // if the authentication method is set to cookie, you need to set the phrase password and the password, it is up to you to decide. you cannot leave it blank. Otherwise, the error shown in is prompted when you log on to phpMyAdmin. 12. Save the settings. now you can upload the file to the network space. View http: // website domain name/phpmyadmin/and test it. (Enter the database user name and password)

If the following error occurs during installation: "phpMyAdmin-error: mysqli extension is missing. Check the PHP configuration ." Error. Solution: ① Go to \ libraries \ config in The phpmyadmin folder. default. find the $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; statement in the PHP file. ② If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is found, continue to find the following $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; and remove the comment. ③ If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is not found, put the $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; statement, change to $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; statement. (That is, make sure that the "mysql" value takes effect)

  3. /* $ Id: config. inc. php, v 1.204.2.1 2003/10/10 14:24:24 nijel Exp $ */

  4. // Vim: expandtab sw = 4 ts = 4 sts = 4:

  5. /**

  6. * PhpMyAdmin Configuration File
  7. *
  8. * All directives are explained in Documentation.html
  9. */

  10. /**

  11. * Sets the php error reporting-Please do not change this line!
  12. */
  13. If (! Isset ($ old_error_reporting )){
  14. Error_reporting (E_ALL );
  15. @ Ini_set ('display _ errors ', '1 ');
  16. }

  17. /**

  18. * Your phpMyAdmin url
  19. *
  20. * Complete the variable below with the full url ie
  21. * Http://www.your _ web.net/path_to_your_phpMyAdmin_directory/
  22. *
  23. * It must contain characters that are valid for a URL, and the path is
  24. * Case sensitive on some Web servers, for example Unix-based servers.
  25. *
  26. * In most cases you can leave this variable empty, as the correct value
  27. * Will be detected automatically. However, we recommend that you do
  28. * Test to see that the auto-detection code works in your system. A good
  29. * Test is to browse a table, then edit a row and save it. There will be
  30. * An error message if phpMyAdmin cannot auto-detect the correct value.
  31. *
  32. * If the auto-detection code does work properly, you can set to TRUE
  33. * $ Cfg ['pmaabsoluteuri _ DisableWarning '] variable below.
  34. */
  35. $ Cfg ['pmaabsoluteuri '] = ''; ----- set the URL of your phpmyadmin, for example, http: // localhost/phpmyadmin/

  36. /**

  37. * Disable the default warning about $ cfg ['pmaabsoluteuri '] not being set
  38. * You shoshould use this if and ONLY if the PmaAbsoluteUri auto-detection
  39. * Works perfectly.
  40. */
  41. $ Cfg ['pmaabsoluteuri _ DisableWarning '] = FALSE;

  42. /**

  43. * Disable the default warning that is displayed on the DB Details Structure page if
  44. * Any of the required Tables for the relationfeatures cocould not be found
  45. */
  46. $ Cfg ['pmanorelation _ DisableWarning '] = FALSE;

  47. /**

  48. * The 'cooker' auth_type uses blowfish algorithm to encrypt the password. If
  49. * At least one server configuration uses 'cooker' auth_type, enter here
  50. * Passphrase that will be used by blowfish.
  51. $ Cfg ['blowfish _ secret'] = ''; ----- enter the root password.

  52. /**

  53. * Server (s) configuration
  54. */
  55. $ I = 0;
  56. // The $ cfg ['servers'] array starts with $ cfg ['servers'] [1]. Do not use $ cfg ['servers'] [0].
  57. // You can disable a server config entry by setting host ''.
  58. $ I ++;
  59. $ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address ---- you can set the IP address of the remote MySQL server.

  60. $ Cfg ['servers'] [$ I] ['port'] = ''; // MySQL port-leave blank for default port ----- 3306 by default

  61. $ Cfg ['servers'] [$ I] ['sockets '] = ''; // Path to the socket-leave blank for default socket

  62. $ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp '; // How to connect to MySQL server ('tcp' or 'socket ') ----- connection to the MySQL server

  63. $ Cfg ['servers'] [$ I] ['companys'] = FALSE; // Use compressed protocol for the MySQL connection

  64. // (Requires PHP> = 4.3.0) ----- whether to use the compression protocol. The PHP version must be greater than or equal to 4.3.0.

  65. $ Cfg ['servers'] [$ I] ['controluser'] = ''; // MySQL control user settings

  66. // (This user must have read-only
  67. $ Cfg ['servers'] [$ I] ['controlpass'] = ''; // access to the" mysql/user"
  68. // And "mysql/db" tables) ----- MySQL controls user settings. this user only has full permissions on the user and db tables in the mysql database.

  69. $ Cfg ['servers'] [$ I] ['auth _ type'] = 'config ';

  70. // Authentication method (config, http or cookie based )? ----- If the PHP installation mode is Apache, http and cookie can be used. if the PHP installation mode is CGI, cookie can be used. the default value is config, which is insecure and is not recommended.

  71. $ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user ----- connect to a user in MySQL

  72. $ Cfg ['servers'] [$ I] ['password'] = '';

  73. // MySQL password (only needed with 'config' auth_type) ----- MySQL connection password. we recommend that you set the root password with phpmyadmin after installing PHP and MySQL, and then enter it here

  74. $ Cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only

  75. // This db is displayed
  76. // At left frame
  77. // It may also be an array
  78. // Of db-names ----- if the name of a database is set here, only the database is displayed on the left of the framework after logging on.

  79. $ Cfg ['servers'] [$ I] ['verbos'] = ''; // verbose name for this host-leave blank to show the hostname

  80. $ Cfg ['servers'] [$ I] ['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features

  81. // (See scripts/create_tables. SQL)
  82. //-Leave blank for no support
  83. // DEFAULT: 'phpmyadmin'
  84. $ Cfg ['servers'] [$ I] ['bookmarktable'] = ''; // Bookmark table
  85. //-Leave blank for no bookmark support
  86. // DEFAULT: 'PMA _ bookmark'
  87. $ Cfg ['servers'] [$ I] ['relation'] = ''; // table to describe the relation between links (see doc)
  88. //-Leave blank for no relation-links support
  89. // DEFAULT: 'PMA _ relation'
  90. $ Cfg ['servers'] [$ I] ['Table _ info'] = ''; // table to describe the display fields
  91. //-Leave blank for no display fields support
  92. // DEFAULT: 'PMA _ table_info'
  93. $ Cfg ['servers'] [$ I] ['Table _ coords '] = ''; // table to describe the tables position for the PDF schema
  94. //-Leave blank for no PDF schema support
  95. // DEFAULT: 'PMA _ table_coords'
  96. $ Cfg ['servers'] [$ I] ['PDF _ page'] = ''; // table to describe pages of relationpdf
  97. //-Leave blank if you don't want to use this
  98. // DEFAULT: 'PMA _ pai_pages'
  99. $ Cfg ['servers'] [$ I] ['column _ info'] = ''; // table to store column information
  100. //-Leave blank for no column comments/mime types
  101. // DEFAULT: 'PMA _ column_info'
  102. $ Cfg ['servers'] [$ I] ['History '] = ''; // table to store SQL history
  103. //-Leave blank for no SQL query history
  104. // DEFAULT: 'PMA _ history'
  105. $ Cfg ['servers'] [$ I] ['verbose _ check'] = TRUE; // set to FALSE if you know that your pma _ * tables
  106. // Are up to date. This prevents compatibility
  107. // Checks and thereby increases performance.
  108. $ Cfg ['servers'] [$ I] ['lowdeny'] ['order'] // Host authentication order, leave blank to not use
  109. = '';
  110. $ Cfg ['servers'] [$ I] ['lowdeny'] ['rules'] // Host authentication rules, leave blank for ULTS
  111. = Array ();

  112. $ I ++;

  113. $ Cfg ['servers'] [$ I] ['host'] = '';
  114. $ Cfg ['servers'] [$ I] ['port'] = '';
  115. $ Cfg ['servers'] [$ I] ['sockets '] = '';
  116. $ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp ';
  117. $ Cfg ['servers'] [$ I] ['compus'] = FALSE;
  118. $ Cfg ['servers'] [$ I] ['controluser'] = '';
  119. $ Cfg ['servers'] [$ I] ['controlpass'] = '';
  120. $ Cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
  121. $ Cfg ['servers'] [$ I] ['user'] = 'root ';
  122. $ Cfg ['servers'] [$ I] ['password'] = '';
  123. $ Cfg ['servers'] [$ I] ['only _ db'] = '';
  124. $ Cfg ['servers'] [$ I] ['verbose '] = '';
  125. $ Cfg ['servers'] [$ I] ['pmadb'] = ''; // 'phpmyadmin'-see scripts/create_tables. SQL
  126. $ Cfg ['servers'] [$ I] ['bookmarktable'] = ''; // 'PMA _ bookmark'
  127. $ Cfg ['servers'] [$ I] ['relation'] = ''; // 'PMA _ relation'
  128. $ Cfg ['servers'] [$ I] ['Table _ info'] = ''; // 'PMA _ table_info'
  129. $ Cfg ['servers'] [$ I] ['Table _ coords '] = ''; // 'PMA _ table_coords'
  130. $ Cfg ['servers'] [$ I] ['PDF _ page'] = ''; // 'PMA _ Ma _pages'
  131. $ Cfg ['servers'] [$ I] ['column _ info'] = ''; // 'PMA _ column_info'
  132. $ Cfg ['servers'] [$ I] ['History '] = ''; // 'PMA _ history'
  133. $ Cfg ['servers'] [$ I] ['verbose _ check'] = TRUE;
  134. $ Cfg ['servers'] [$ I] ['lowdeny'] ['order']
  135. = '';
  136. $ Cfg ['servers'] [$ I] ['lowdeny'] ['rules']
  137. = Array ();

  138. $ I ++;

  139. $ Cfg ['servers'] [$ I] ['host'] = '';
  140. $ Cfg ['servers'] [$ I] ['port'] = '';
  141. $ Cfg ['servers'] [$ I] ['sockets '] = '';
  142. $ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp ';
  143. $ Cfg ['servers'] [$ I] ['compus'] = FALSE;
  144. $ Cfg ['servers'] [$ I] ['controluser'] = '';
  145. $ Cfg ['servers'] [$ I] ['controlpass'] = '';
  146. $ Cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
  147. $ Cfg ['servers'] [$ I] ['user'] = 'root ';
  148. $ Cfg ['servers'] [$ I] ['password'] = '';
  149. $ Cfg ['servers'] [$ I] ['only _ db'] = '';
  150. $ Cfg ['servers'] [$ I] ['verbose '] = '';
  151. $ Cfg ['servers'] [$ I] ['pmadb'] = ''; // 'phpmyadmin'-see scripts/create_tables. SQL
  152. $ Cfg ['servers'] [$ I] ['bookmarktable'] = ''; // 'PMA _ bookmark'
  153. $ Cfg ['servers'] [$ I] ['relation'] = ''; // 'PMA _ relation'
  154. $ Cfg ['servers'] [$ I] ['Table _ info'] = ''; // 'PMA _ table_info'
  155. $ Cfg ['servers'] [$ I] ['Table _ coords '] = ''; // 'PMA _ table_coords'
  156. $ Cfg ['servers'] [$ I] ['PDF _ page'] = ''; // 'PMA _ Ma _pages'
  157. $ Cfg ['servers'] [$ I] ['column _ info'] = ''; // 'PMA _ column_info'
  158. $ Cfg ['servers'] [$ I] ['History '] = ''; // 'PMA _ history'
  159. $ Cfg ['servers'] [$ I] ['verbose _ check'] = TRUE;
  160. $ Cfg ['servers'] [$ I] ['lowdeny'] ['order']
  161. = '';
  162. $ Cfg ['servers'] [$ I] ['lowdeny'] ['rules']
  163. = Array ();

  164. // If you have more than one server configured, you can set $ cfg ['serverdefault']

  165. // To any one of them to autoconnect to that server when phpMyAdmin is started,
  166. // Or set it to 0 to be given a list of servers without logging in
  167. // If you have only one server configured, $ cfg ['serverdefault'] * MUST * be
  168. // Set to that server. [color] = red] ----- whether to display all MySQL servers
  169. $ Cfg ['serverdefault'] = 1; // Default server (0 = no default server)
  170. $ Cfg ['server'] = '';
  171. Unset ($ cfg ['servers'] [0]);

  172. /**

  173. * Other core phpMyAdmin settings
  174. */
  175. $ Cfg ['obgzip '] = 'auto'; // use GZIP output buffering if possible (TRUE | FALSE | 'auto') ----- whether to use GZIP output buffer if necessary

  176. $ Cfg ['persistentconnections'] = FALSE; // use persistent connections to MySQL database ----- whether to use MySQL persistent connection, that is, pconnect

  177. $ Cfg ['exectimelimmit '] = 300; // maximum execution time in seconds (0 for no limit) ----- maximum script execution time, in seconds

  178. $ Cfg ['skiplockedtables '] = FALSE; // mark used tables, make possible to show

  179. // Locked tables (since MySQL 3.23.30)
  180. $ Cfg ['showsql'] = TRUE; // show SQL queries as run ----- the SQL query statement is displayed when the query is run.

  181. $ Cfg ['allowuserdropdatabase'] = FALSE; // show a 'drop database' link to normal users ----- whether to display "delete database" connection to common users

  182. $ Cfg ['confirm'] = TRUE; // Confirm 'drop table' & 'Drop database' ----- whether a confirmation box is displayed before deleting a data TABLE/DATABASE

  183. $ Cfg ['logincookierecall'] = TRUE; // recall previous login cookie auth. mode or not ----- whether to reclaim the cookie in the previous cookie authentication mode

  184. $ Cfg ['usedbsearch'] = TRUE; // whether to enable the "database search" feature

  185. // Or not
  186. $ Cfg ['ignoremultisubmiterrors '] = FALSE; // if set to true, PMA continues computing multiple-statement queries
  187. // Even if one of the queries failed
  188. $ Cfg ['verbosemultisubmit '] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on
  189. // Multiple-statement queries. See the read_dump.php file for hardcoded
  190. // Defaults on how to handle queries a statement may contain!
  191. $ Cfg ['allowarbitraryserver'] = FALSE; // allow login to any user entered server in cookie based auth

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
configuration file phpmyadmin log file configuration settings file httpd configuration file mysql server configuration file php loaded configuration file joomla configuration file location

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More