Detailed configuration of phpMyAdmin

phpMyAdmin is a very useful database management interface, especially for beginners who are unfamiliar with database operations commands. Which phpMyAdmin also has a lot of configuration items, we will explain the phpMyAdmin configuration file today, we hope to help you.

The phpMyAdmin configuration file config.inc.php content as follows, adding relevant comments where it needs to be set.

Here's how to install the tool:
1. First to download onlinephpMyAdmin, and then extracted to the Web directory can be accessed (if it is virtual space, can be extracted via FTP and so upload to the web directory), of course, you can modify the name of the file after decompression.
2. Configure config file
Open the config.default.php file under libraries, locate the following, and then follow the instructions to configure it:
A. Access to the Web site
Reference:
$cfg [' pmaabsoluteuri '] = '; Fill in phpMyAdmin's access URL here
B.mysql Host Information
Reference:
$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address
Fill in the IP address of localhost or MySQL server, and if MySQL and the phpMyAdmin are on the same server, press the default localhost
$cfg [' Servers '] [$i] [' port '] = '; MySQL Port-leave blank for default port
MySQL port, if it is the default 3306, leave it blank
c.mysql user name and password
Reference:
$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username
fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username
D. Authentication methods
Reference:
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
There are four different modes to choose from, Cookie,http,http,config
The Config method is to enter the phpMyAdmin access URL 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, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
E. Setting of the phrase password (blowfish_secret)
Reference:
$cfg [' blowfish_secret '] = ';
If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin
OK, so far, you have successfully installed the phpMyAdmin, simple, quickly login experience it
Description
This document describes only the basic configuration for installing phpMyAdmin, and detailed instructions on each configuration parameter in the config.default.php file can be
PhpMyAdmin is a MySQL database management tool, after the installation of the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, is very suitable for database Operations Command unfamiliar Database manager, the following details the installation method of the tool.
First, download
1, first to the site Download phpMyAdmin installation package: HTTP://WWW.PHP.CN/XIAZAI/GONGJU/97 (Installation contains various languages all-languages)
2, re-extract to the Web can access the directory, if it is virtual space, can be extracted through the FTP tool upload to the Web directory, and you can modify the extracted file name (you can customize the directory name).
Second, the 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 the 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.
Here are four modes to choose from: Cookie,http,http,config
①config mode is to enter the phpMyAdmin access URL directly to enter, 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 left blank)
9. Find $cfg [' Servers '] [$i] [' only_db '] = '; You only have one data set up, set as your database name, if you want to build a server, then suggest leave blank
10, find $cfg [' defaultlang '] = ' zh '; Here is the language of choice, en stands for Simplified Chinese meaning
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. (You can enter the user name and password for the database)

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 '; statement.
② If you find $cfg[' Servers ' [$i] [' extension ']= ' MySQL ', continue to find the following sentence $cfg[' Servers ' [$i] [' extension ']= '

<?php/* $Id: config.inc.php,v 1.204.2.1 2003/10/10 14:24:24 Nijel Exp $ *///vim:expandtab sw=4 ts=4 sts=4:/*** PhpMyA DMin Configuration file** All directives is explained in documentation.html*//*** sets the PHP error reporting-please D    o The change of this line!*/if (!isset ($old _error_reporting)) {error_reporting (E_all); @ini_set (' display_errors ', ' 1 ');} /*** Your phpMyAdmin url** Complete the variable below with the full URL ie* http://www.your_web.net/path_to_your_phpMy admin_directory/** It must contain characters that is valid for a URL, and the path is* case sensitive on some WEB server s, for example unix-based servers.** in more cases you can leave this variable empty, as the correct value* would be detect Ed automatically. However, we recommend that's do* test to see this auto-detection code works in your system. A good* test is to browse a table, then edit a row and save it. There would be* an error message if PhpMyAdmin cannot auto-detect the correct value.**If The Auto-detection code does work properly, you can set to TRUE the* $cfg [' pmaabsoluteuri_disablewarning '] variable bel ow.*/$cfg [' pmaabsoluteuri '] = ';-----Set your phpMyAdmin URL here, such as: http://localhost/phpmyadmin//*** Disable the default Warning about $cfg [' Pmaabsoluteuri '] not being set* you should use this if and only if the Pmaabsoluteuri auto-detection* Works perfectly.*/$cfg [' pmaabsoluteuri_disablewarning '] = false;/*** Disable The default warning that's displayed on the DB Details Structure page if* any of the required Tables for the relationfeatures could isn't be found*/$cfg [' Pmanorelation_ Disablewarning '] = false;/*** the ' cookie ' Auth_type uses blowfish algorithm to encrypt the password. if* at least one server configuration uses ' Cookies ' auth_type, enter here A * passphrase that'll be used by Blowfish. $cfg [' blowfish_secret '] = ';-----The root password is set,/*** Server (s) configuration*/$i = 0;//the $cfg [' Servers '] array starts WI th $cfg [' Servers '][1]. Do not use $cfg [' Servers '][0].You can disable a server config entry by setting host to '. $i + +; $cfg [' Servers '] [$i] [' host '] = ' localhost ';          mysql hostname or IP address----Here you can set the remote MySQL server IP addresses $cfg[' Servers ' [$i] [' port '] = ';          MySQL Port-leave blank for default port-----default to 3306$cfg[' Servers ' [$i] [' socket '] = ';       Path to the Socket-leave blank for default socket$cfg[' Servers ' [$i] [' connect_type '] = ' TCP ';       How to connect to MySQL server (' tcp ' or ' socket ')-----the way to connect MySQL servers $cfg[' Servers ' [$i] [' compress '] = FALSE; Use compressed protocol for the MySQL Connection//(Requires PHP          >= 4.3.0)-----Whether to use the compression protocol, the PHP version must >= 4.3.0$cfg[' Servers ' [$i] [' controluser '] = '; MySQL control user Settings//(This user must has read-only$cfg[' S          Ervers ' [$i] [' controlpass '] = ';                          Access to the "Mysql/user"                          and "mysql/db" tables)-----MySQL control user settings, the user only has full access to user and DB tables under the MySQL database $cfg[' Servers ' [$i] [' Auth_    Type '] = ' config '; 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.      $cfg [' Servers '] [$i] [' user '] = ' root ';          MySQL user-----mysql connect users $cfg[' Servers ' [$i] [' password '] = '; 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 the $          cfg[' Servers ' [$i] [' only_db '] = ';                                                    If set to a db-name, only//This db is displayed At left frame//It may also is an Array/Of Db-names-----If the name of a database is set here, then the left side of the login frame will only show this database $cfg[' Server          S ' [$i] [' verbose '] = '; VerbosE name for this host-leave blank to show the hostname$cfg[' Servers ' [$i] [' pmadb '] = '; Database used for Relation, Bookmark and PDF Features//(see Script                                                    S/CREATE_TABLES.SQL)//-leave blank for no support          DEFAULT: ' phpMyAdmin ' $cfg [' Servers '] [$i] [' bookmarktable '] = ';                                                    Bookmark Table//-leave blank for no bookmark support          DEFAULT: ' Pma_bookmark ' $cfg [' Servers '] [$i] [' relation '] = '; Table to describe the relation between links (see DOC)//-Leav e blank for no relation-links support//DEFAULT: ' Pma_relation ' $CF        g[' Servers ' [$i] [' table_info '] = ';  Table to describe the display fields//-leave blank for no dis Play fields Support//DEFAULT: ' Pma_table_info ' $cfg [' Servers '] [$i]          [' table_coords '] = '; Table to describe the tables position for the PDF schema//-Leav e blank for no PDF schema support//DEFAULT: ' Pma_table_coords ' $CF          g[' Servers ' [$i] [' pdf_pages '] = '; Table to describe pages of relationpdf//-Leave blank if you don ' t want to use this//DEFAULT: ' pma_pdf_pages ' $cfg [' Servers '] [$i] [          ' column_info '] = '; Table to store column information//-leave blank for no column C               Omments/mime types                                     DEFAULT: ' Pma_column_info ' $cfg [' Servers '] [$i] [' history '] = '; table to store SQL history//-leave blank for no SQL query hist  Ory//DEFAULT: ' pma_history ' $cfg [' Servers '] [$i] [' verbose_check '] =        TRUE; Set to FALSE If you know this your pma_* tables//is up to date. This prevents compatibility//checks and thereby increases performance                                     . $cfg [' Servers '] [$i] [' Allowdeny '] [' order ']//Host authentication order, leave blank to no use  = "; $cfg [' Servers '] [$i] [' Allowdeny '] [' rules ']//Host authentication rules, leave blank for Defaults = Array (), $i + +, $cfg [' Servers '] [$i] [' host '] = '; $cfg [' Servers '][$  i][' Port ']          = '; $cfg [' Servers '] [$i] [' socket '] = '; $cfg [' Servers '] [$i] [' connect_type '] = ' TCP '; $cfg [' Servers '] [ $i [' compress '] = FALSE, $cfg [' Servers '] [$i] [' controluser '] = '; $cfg [' Servers '] [$i] [' controlpass '] = '; $cf g[' Servers ' [$i] [' auth_type '] = ' config ', $cfg [' Servers '] [$i] [' user '] = ' root '; $cfg [' Servers '] [$i] ' Passwo Rd '] = '; $cfg [' Servers '] [$i] [' only_db '] = '; $cfg [' Servers '] [$i] [' verbose '] = '; $cfg [' Servers '][$ i][' pmadb '] = '; ' phpMyAdmin '-see scripts/create_tables.sql$cfg[' Servers ' [$i] [' bookmarktable '] = '; ' Pma_bookmark ' $cfg [' Servers '] [$i] [' relation '] = '; ' Pma_relation ' $cfg [' Servers '] [$i] [' table_info '] = '; ' Pma_table_info ' $cfg [' Servers '] [$i] [' table_coords '] = '; ' Pma_table_coords ' $cfg [' Servers '] [$i] [' pdf_pages '] = '; ' Pma_pdf_pages ' $cfg [' Servers '] [$i] [' column_info '] = '; ' Pma_column_info ' $cfg [' Servers '] [$i] [' history '] = '; ' Pma_hiStory ' $cfg [' Servers '] [$i] [' verbose_check '] = TRUE; $cfg [' Servers '] [$i] [' Allowdeny '] [' order '] = '; $cfg [' Servers '] [$i] [' Allowdeny '] [' rules '] = Array (); $i + +; $cfg [' Server S ' [$i] [' host '] = '; $cfg [' Servers '] [$i] [' port '] = '; $cfg [' Servers '] [$i] [' socket '] = '; $c fg[' Servers ' [$i] [' connect_type '] = ' TCP ', $cfg [' Servers '] [$i] [' compress '] = FALSE; $cfg [' Servers '] [$i] [' Controlus Er '] = '; $cfg [' Servers '] [$i] [' controlpass '] = '; $cfg [' Servers '] [$i] [' auth_type '] = ' config '; $cfg [' Servers ' [$i] [' user '] = ' root '; $cfg [' Servers '] [$i] [' password '] = '; $cfg [' Servers '] [$i] [' only_db '] = '; $cfg [' Servers '] [$i] [' verbose '] = '; $cfg [' Servers '] [$i] [' pmadb '] = '; ' phpMyAdmin '-see scripts/create_tables.sql$cfg[' Servers ' [$i] [' bookmarktable '] = '; ' Pma_bookmark ' $cfg [' Servers '] [$i] [' relation '] = '; ' Pma_relation ' $cfg [' SeRVers ' [$i] [' table_info '] = '; ' Pma_table_info ' $cfg [' Servers '] [$i] [' table_coords '] = '; ' Pma_table_coords ' $cfg [' Servers '] [$i] [' pdf_pages '] = '; ' Pma_pdf_pages ' $cfg [' Servers '] [$i] [' column_info '] = '; ' Pma_column_info ' $cfg [' Servers '] [$i] [' history '] = ';                                       ' Pma_history ' $cfg [' Servers '] [$i] [' verbose_check '] = TRUE; $cfg [' Servers '] [$i] [' Allowdeny '] [' order '] = '; $cfg [' Servers '] [$i] [' Allowdeny '] [' rules '] = array ();/If y OU has more than than one server configured, you can set $cfg [' Serverdefault ']//to any one of the them to AutoConnect to that Ser ver when PhpMyAdmin was started,//or set it to 0 to being given a list of servers without logging in//If you had only one s Erver configured, $cfg [' Serverdefault '] *must* be//set to that server.              [color]=red]-----Whether to show all MySQL server $cfg[' serverdefault '] = 1; Default server (0 = no default server) $cfg [' server '] = '; Unset ($cfg [' Servers '][0])/*** other core phpMyAdmin settings*/$cfg [' obgzip '] = ' auto '; Use GZIP output buffering if possible (true| False| ' Auto ')-----If necessary, use gzip output buffer $cfg[' persistentconnections ' = FALSE;    Use the persistent connections to MySQL database-----whether a MySQL persistent connection is used, i.e. pconnect$cfg[' exectimelimit '] = 300; Maximum execution time in seconds (0 for No limit)-----maximum script execution times in seconds $cfg[' skiplockedtables '] = FALSE; Mark used tables, make possible to show//locked tables (since MySQL 3.23.30)   $cfg [' showsql '] = TRUE; Show SQL queries as run-----display SQL query Statement $cfg[' allowuserdropdatabase ' = FALSE when running a query;   Show a ' drop database ' link to normal users-----whether to display the "delete databases" connection to the normal user $cfg[' Confirm ' = TRUE;   Confirm ' drop table ' & ' drop database '-----Whether a confirmation prompt appears before deleting the datasheet/library $cfg[' logincookierecall ' = TRUE; Recall previous login in Cookie auth. Mode or not-----whether to retract the previous cookie authentication mode Cookie$cfg[' usedbsearch ') = TRUE; Whether to enable the "Database Search" feature//or not$cfg[' IGNOREMULTISUBM Iterrors '] = FALSE; If set to True, PMA continues computing multiple-statement queries//even if   One of the queries failed$cfg[' verbosemultisubmit '] = TRUE; If set to True, PMA would show the affected rows of each statement on//Multip Le-statement queries. See the read_dump.php file for hardcoded//defaults in how many queries a Statem ENT may contain! $cfg [' allowarbitraryserver '] = FALSE; Allow login to any user entered server in cookie based auth

Related recommendations:

SQL parsing using Sql-parser in phpMyAdmin

phpMyAdmin Usage Tutorials

MySQL Visual management tool phpMyAdmin Learning