Home > Article > Backend Development > Detailed explanation of PHPMyadmin configuration file (configuration)_PHP tutorial
Detailed explanation of PHPMyadmin configuration file (configuration)_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:42:17790browse
It is very suitable for database managers who are not familiar with database operation commands. Let me tell you how to install this tool:
1. First download phpmyadmin online, and then unzip it to an accessible web page directory (if it is a virtual space, you can decompress it and upload it to the web directory through ftp, etc.). Of course, you can modify the name of the decompressed file.
2. Configure the config file
Open the config.default.php file under libraries, find the following items in order, and configure them according to the instructions:
A. Visit the website
Quote:
$cfg['PmaAbsoluteUri'] = '';Fill in the access URL of phpmyadmin here
B.mysql host information
Quote:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
Fill in the IP address of the server where localhost or mysql is located. If mysql and the phpmyadmin are on the same server, Then 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 as Just leave it empty
C.mysql username and password
Quote:
$cfg['Servers'][$i]['user'] = 'root'; // The mysql user name used by MySQL user to access phpmyadmin
fg['Servers'][$i]['password'] = ''; // MySQL password (only neededThe password corresponding to the above mysql user name
D. Authentication method
Quote:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
There are four modes available here Select, cookie, http, HTTP, config
Configuration method is to enter the access URL of phpmyadmin to enter directly without entering the user name and password. It is unsafe and not recommended.
When this item is set to cookie, When using http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:
PHP installation mode is Apache, you can use http and cookies;
PHP installation mode is CGI, you can use cookies
E. Phrase password (blowfish_secret) setting
Quote:
$cfg['blowfish_secret'] = '';
If the authentication method is set to cookie, you need to set the phrase Password, it is up to you to decide what password to set, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin
Ok, so far, you have successfully installed phpmyadmin, it’s easy, log in to experience it
Note:
This document only describes the basic configuration of installing phpmyadmin. Detailed descriptions of each configuration parameter in the config.default.php file can be found
phpMyAdmin is a MySQL database Management tool. After installing this tool, you can directly manage MySQL data through the web form without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands. The installation method of this tool is explained in detail below. .
1. Download
1. First go to the official website to download the phpMyAdmin installation package: http://www.phpmyadmin.net/ (the installation includes all-languages)
2 , and then decompress it to a directory that can be accessed by the web. If it is a virtual space, you can decompress it and upload it to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file (you can customize the directory name).
2. Configuration
3. Open the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory), use WordPad ( Do not use Notepad (this is UTF8 encoding) to edit, just follow the instructions to configure it.
4. Find $cfg['PmaAbsoluteUri']=''; // Change it to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] ='http: // Website domain name /phpmyadmin/';
5. Search $cfg['Servers'][$i]['host'] ='localhost'; // Usually the default is used, but there are exceptions. You don’t need to modify it.
6. Search $cfg['Servers'][$i]['auth_type'] ='config'; // Use config for debugging on your own machine; if you use cookies on the network.
There are four modes here Available options: cookie, http, HTTP, config
① The config method is to enter the access URL of phpMyAdmin to enter directly without entering the user name and password. It is unsafe and not recommended.
② Set cookie, http, HTTP method, log in to phpMyAdmin and need data user name and password for verification.
The details are as follows: PHP installation mode is Apache, you can use http and cookies; PHP installation mode is CGI, you can use cookies.
7. Search for $cfg['Servers'][$i]['user'] = 'root'; // MySQL user name
8. Search for $cfg['Servers'][$i][ 'password'] = ''; // MySQL password (only needed, just leave it blank)
9. Find $cfg['Servers'][$i]['only_db'] = ''; // You If there is only one data, set it to your database name; if you want to set up a server, it is recommended to leave it blank
10. Find $cfg['DefaultLang'] = 'zh'; // Here is the language selection, zh Represents the meaning of Simplified Chinese
11. Search $cfg['blowfish_secret'] =''; // If the authentication method is set to cookie, you need to set a phrase password. What password to set is up to you. You cannot leave it blank here. , otherwise the error shown in the figure below will be prompted when logging in to phpMyAdmin.
12、设置完毕后保存，现在可以上传到网络空间上了，浏览http://网站域名/phpmyadmin/测试一下。（输入数据库的用户名及密码就可以了） 
如果要安装过程中出现：“phpMyAdmin - 错误 缺少 mysqli 扩展。请检查 PHP 配置。”错误。
解决方法如下：
①到phpmyadmin文件夹的\libraries\config.default.php文件中找：$cfg['Servers'][$i]['extension']='mysql';语句。
②如果有找到$cfg['Servers'][$i]['extension']='mysql';这句，就继续查找下面这句$cfg['Servers'][$i]['extension']='mysqli'; 并把其的注释去掉。
③如果没有找到$cfg['Servers'][$i]['extension']='mysql';这句，就把$cfg['Servers'][$i]['extension']='mysqli';语句，改成$cfg['Servers'][$i]['extension']='mysql'; 语句。（即确保 " mysql " 值能生效）
/* $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:
/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
*/
/**
* Sets the php error reporting - Please do not change 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_phpMyAdmin_directory/
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it. There will 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 below.
*/
$cfg['PmaAbsoluteUri'] = '';-----这里设置你的phpmyadmin的URL，如：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 is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish.
$cfg['blowfish_secret'] = '';-----设定好root密码后这里也要填写
/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $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----这里可以设定远程MySQL服务器IP地址
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port-----默认为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')-----连接MySQL服务器的方式
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)-----是否使用压缩协议，PHP版本须>= 4.3.0
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)-----MySQL控制用户设定，该用户只对mysql数据库下的user和db表有完全权限
$cfg['Servers'][$i]['auth_type'] = 'config';
// Authentication method (config, http or cookie based)?-----如果PHP安装模式为Apache，可以使用http和cookie；如果PHP安装模式为CGI，可以使用cookie；默认为config，是不安全的，不推荐。
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user-----MySQL连接用户
$cfg['Servers'][$i]['password'] = '';
// MySQL password (only needed with 'config' auth_type)-----MySQL连接密码，建议在安装好PHP和MySQL后，先用phpmyadmin设定root密码，然后在这里填写
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names-----如果在这里设定一个数据库的名字，那么登陆后框架左边将只显示这个数据库
$cfg['Servers'][$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 scripts/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)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
$cfg['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 comments/mime types
// DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history'] = ''; // table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables
// are up to date. This prevents compatibility
// checks and thereby increases performance.
$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not 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'] = '';
$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();
$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'] = '';
$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 you have more than one server configured, you can set $cfg['ServerDefault']
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfg['ServerDefault'] *MUST* be
// set to that server.[color]=red]-----是否显示所有的MySQL服务器
$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')-----有必要的话是否使用GZIP输出缓冲
$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database-----是否使用MySQL持久连接，即pconnect
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)-----最大脚本执行时间，单位：秒
$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-----运行查询时显示SQL查询语句
$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users-----是否对普通用户显示“删除数据库”连接
$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'-----删除数据表/库前是否出现确认提示框
$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not-----是否收回先前cookie认证模式的cookie
$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature
// or not
$cfg['IgnoreMultiSubmitErrors'] = 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 will show the affected rows of EACH statement on
// multiple-statement queries. See the read_dump.php file for hardcoded
// defaults on how many queries a statement may contain!
$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth