PHPMyadmin configuration file (Classic)

Source: Internet
Author: User
Tags php error reporting
PHPMyadmin configuration file (Classic)

  1. $ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name
  2. 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)

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

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

  3. /**

  4. * PhpMyAdmin Configuration File
  5. *
  6. * All directives are explained in Documentation.html
  7. */

  8. /**

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

  15. /**

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

  34. /**

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

  40. /**

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

  45. /**

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

  50. /**

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  73. // This db is displayed
  74. // At left frame
  75. // It may also be an array
  76. // 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.

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

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

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

  110. $ I ++;

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

  136. $ I ++;

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

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

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

  170. /**

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

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

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

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

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

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

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

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

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

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

Related Article

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.

A Free Trial That Lets You Build Big!

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

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