phpMyAdmin configuration file (Classic)

Source: Internet
Author: User
Tags php and mysql php error php error reporting set cookie
    1. $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username
    2. fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username
Copy Code

D. Authentication methods $cfg [' Servers '] [$i] [' auth_type '] = ' cookies '; There are four modes to choose from, Cookie,http,http,config config means that input phpmyadmin access URL can be entered directly, no need to enter the user name and password, is not safe, is not recommended to use. When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows: PHP installation mode is Apache, HTTP and cookies can be used, PHP installation mode is CGI, you can use cookies

E. Phrase password (blowfish_secret) settings $cfg [' blowfish_secret '] = '; If the authentication method is set to a cookie, you will need to set the phrase password to set why the password, it is up to you to decide, but you can not leave it blank, or you will be prompted incorrectly when you log on phpMyAdmin phpMyAdmin successfully installed.

Description: This document describes only the basic configuration of installing phpMyAdmin, and detailed instructions on each configuration parameter in the config.default.php file can be

The following are the installation methods for the phpMyAdmin tool.

First, download 1, first to the official site Download phpMyAdmin installation package: http://www.phpmyadmin.net/(Installation contains various languages all-languages) 2, and then unzip to the Web can access the directory, if it is virtual space, It can be decompressed and uploaded to the Web directory via the FTP tool, and you can modify the name of the file after decompression (you can customize the directory name).

Second, configuration 3, open the/libraries/config.default.php file (the old version is the root directory of the config.inc.php file), with WordPad (do not use Notepad, which is UTF8 encoding) for editing, follow the instructions to configure. 4, find $cfg [' Pmaabsoluteuri ']= '; Modify the URL of the phpmyadmin that you will upload to space such as: $cfg [' pmaabsoluteuri '] = ' http://website domain name/phpmyadmin/'; 5. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; Usually with the default, there are exceptions, you can not modify 6, find $cfg [' Servers '] [$i] [' auth_type '] = ' config '; Debug in your own machine with config, if the space on the network with a cookie. There are four modes to choose from: The Cookie,http,http,config①config method is to enter the phpMyAdmin access URL directly into the, no need to enter the user name and password, is not safe, is not recommended to use. ② set cookie,http,http mode, login phpMyAdmin require data user name and password to authenticate. The following: PHP installation mode for Apache, you can use the HTTP and cookie;php installation mode for CGI, you can use cookies. 7. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User name 8, find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (only needed blank) 9, find $cfg [' Servers '] [$i] [' only_db '] = '; You have only one data set, set as your database name, if you want to build a server, it is recommended to leave blank 10, find $cfg [' defaultlang '] = ' zh '; Here is the choice of language, zh for Simplified Chinese 11, find $cfg[' blowfish_secret '] = "; If the authentication method is set to a cookie, you will need to set the phrase password, set why the password, by your own discretion, this can not be left blank, otherwise you will be prompted as shown when logging in PhpMyAdmin. 12, set up after the save, can now upload to the network space, browse http://website domain name/phpmyadmin/test it. (Enter the user name and password for the database to do so)

If the installation process occurs: "PhpMyAdmin-Error missing mysqli extension. Please check your PHP configuration. Error The workaround is as follows: ① to the \libraries\config.default.php file in the phpMyAdmin folder: $cfg [' Servers '] [$i] [' extension ']= ' MySQL '; ② If there is found $cfg[' Servers ' [$i] [' extension ']= ' MySQL ', this sentence continues to find the following sentence $cfg[' Servers ' [$i] [' extension ']= ' mysqli '; and remove the notes. ③ if not found $cfg[' Servers ' [$i] [' extension ']= ' MySQL ', this sentence $cfg[' Servers ' [$i] [' extension ']= ' mysqli '; statement, change to $cfg[' Servers '] [$i] [' extension ']= ' MySQL '; Statement. (that is, ensure that the "MySQL" value is valid)

  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 is explained in documentation.html
  7. */

  8. /**

  9. * Sets the PHP error reporting-please don't 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's valid for a URL, and the path is
  22. * Case sensitive in some WEB servers, for example unix-based servers.
  23. *
  24. * In most cases you can leave this variable empty, as the correct value
  25. * would be detected automatically. However, we recommend that
  26. * Test to see this auto-detection code works in your system. A Good
  27. * Test is to browse a table, then edit a row and save it. There'll 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 the
  31. * $cfg [' pmaabsoluteuri_disablewarning '] variable below.
  32. */
  33. $cfg [' pmaabsoluteuri '] = ';-----Set your phpMyAdmin URL here, such as: http://localhost/phpmyadmin/

  34. /**

  35. * Disable The default warning about $cfg [' Pmaabsoluteuri '] not being set
  36. * Should use if and only if the Pmaabsoluteuri auto-detection
  37. * Works perfectly.
  38. */
  39. $cfg [' pmaabsoluteuri_disablewarning '] = FALSE;

  40. /**

  41. * Disable The default warning that's displayed on the DB Details Structure page if
  42. * Any of the required Tables for the relationfeatures could not be found
  43. */
  44. $cfg [' pmanorelation_disablewarning '] = FALSE;

  45. /**

  46. * the ' cookie ' Auth_type uses blowfish algorithm to encrypt the password. If
  47. * At least one server configuration uses ' Cookies ' auth_type, enter here a
  48. * Passphrase that'll be used by Blowfish.
  49. $cfg [' blowfish_secret '] = ';-----The root password is set.

  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 to '.
  56. $i + +;
  57. $cfg [' Servers '] [$i] [' host '] = ' localhost '; mysql hostname or IP address----Here you can set the remote MySQL server IP addresses

  58. $cfg [' Servers '] [$i] [' port '] = '; MySQL Port-leave blank for default port-----default is 3306

  59. $cfg [' Servers '] [$i] [' socket '] = '; 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 ')-----the way to connect MySQL servers

  61. $cfg [' Servers '] [$i] [' compress '] = FALSE; Use compressed protocol for the MySQL connection

  62. (Requires PHP >= 4.3.0)-----Whether to use compression protocol, PHP version must >= 4.3.0

  63. $cfg [' Servers '] [$i] [' controluser '] = '; MySQL Control user Settings

  64. (This user must has Read-only
  65. $cfg [' Servers '] [$i] [' controlpass '] = '; Access to the "Mysql/user"
  66. and "mysql/db" tables)-----MySQL control user settings, the user only has full access to user and DB tables under the MySQL database

  67. $cfg [' Servers '] [$i] [' auth_type '] = ' config ';

  68. authentication method (config, HTTP or cookie based)?-----if PHP installation mode is Apache, you can use HTTP and cookies, if PHP installation mode is CGI, Cookies can be used; The default is config, which is unsafe and not recommended.

  69. $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user-----mysql connection

  70. $cfg [' Servers '] [$i] [' password '] = ';

  71. MySQL password (only needed with ' config ' auth_type)-----mysql connection password, it is recommended that after installing PHP and MySQL, first use phpMyAdmin to set the root password, and then fill in 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 is an array
  76. of Db-names-----If the name of a database is set here, then the left side of the frame will only show this database

  77. $cfg [' Servers '] [$i] [' verbose '] = '; 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_pages '] = '; Table to describe pages of relationpdf
  95. -Leave blank if you don ' t want
  96. DEFAULT: ' Pma_pdf_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. is up to date. This prevents compatibility
  105. Checks and thereby increases performance.
  106. $cfg [' Servers '] [$i] [' Allowdeny '] [' order ']//Host authentication order, leave blank to no use
  107. = '';
  108. $cfg [' Servers '] [$i] [' Allowdeny '] [' rules ']//Host authentication rules, leave blank for defaults
  109. = Array ();

  110. $i + +;

  111. $cfg [' Servers '] [$i] [' host '] = ';
  112. $cfg [' Servers '] [$i] [' port '] = ';
  113. $cfg [' Servers '] [$i] [' socket '] = ';
  114. $cfg [' Servers '] [$i] [' connect_type '] = ' TCP ';
  115. $cfg [' Servers '] [$i] [' compress '] = 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_pages '] = '; ' Pma_pdf_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] [' Allowdeny '] [' order ']
  133. = '';
  134. $cfg [' Servers '] [$i] [' Allowdeny '] [' rules ']
  135. = Array ();

  136. $i + +;

  137. $cfg [' Servers '] [$i] [' host '] = ';
  138. $cfg [' Servers '] [$i] [' port '] = ';
  139. $cfg [' Servers '] [$i] [' socket '] = ';
  140. $cfg [' Servers '] [$i] [' connect_type '] = ' TCP ';
  141. $cfg [' Servers '] [$i] [' compress '] = 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_pages '] = '; ' Pma_pdf_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] [' Allowdeny '] [' order ']
  159. = '';
  160. $cfg [' Servers '] [$i] [' Allowdeny '] [' rules ']
  161. = Array ();

  162. If you had more than one server configured, you can set $cfg [' Serverdefault ']

  163. To any one of the them to AutoConnect to this server when PhpMyAdmin is started,
  164. or set it to 0 to is given a list of servers without logging in
  165. If you had only one server configured, $cfg the [' Serverdefault '] *must* be
  166. Set to that server. [color]=red]-----Whether to show 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 ')-----If necessary, use the gzip output buffer

  174. $cfg [' persistentconnections '] = FALSE; Use the persistent connections to MySQL database-----If you are using a MySQL persistent connection, that is, pconnect

  175. $cfg [' exectimelimit '] = 300; Maximum execution time in seconds (0 for No limit)-----maximum script execution times 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-----Display SQL query statements when running queries

  179. $cfg [' allowuserdropdatabase '] = FALSE; Show a ' drop database ' link to normal users-----whether to display a "delete databases" connection to a normal user

  180. $cfg [' Confirm '] = TRUE; Confirm ' drop table ' & ' drop database '-----Whether a confirmation prompt appears before deleting the datasheet/library

  181. $cfg [' logincookierecall '] = TRUE; Recall previous login in Cookie auth. Mode or not-----whether to reclaim cookies from 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 would show the affected rows of each statement on
  187. Multiple-statement queries. See the read_dump.php file for hardcoded
  188. Defaults on what many queries a statement may contain!
  189. $cfg [' allowarbitraryserver '] = FALSE; Allow login to any user entered server in cookie based auth

Copy Code
  • 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.