Shulou(Shulou.com)05/31 Report--

This article mainly explains "the detailed introduction of phpmyadmin configuration", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "the detailed introduction of phpmyadmin configuration"!

Phpmyadmin Quick start tutorial

The content of the PHPMyadmin configuration file config.inc.php is as follows, with comments added where you need to set it up.

Here's how to install the tool:

1. Download phpmyadmin

First download phpmyadmin from the Internet, and then extract it to an accessible web directory (if it is a virtual space, you can decompress it and upload it to the web directory via ftp, etc.). Of course, you can modify the name of the file after decompression.

two。 Configure the config file

Open the config.default.php file under libraries, find the following items in turn, and follow the instructions to configure:

a. Visit the web site

1$ cfg ['PmaAbsoluteUri'] =''

Fill in the URL of phpmyadmin, such as: $cfg ['PmaAbsoluteUri'] =' http:// your site / phpmyadmin/'

B.mysql host information

1$ cfg ['Servers'] [$I] [' host'] = 'localhost'; / / MySQL hostname or IP address

Enter the ip address of the server where the localhost or mysql resides. If the mysql and the phpmyadmin are on the same server, press the default localhost

1$ cfg ['Servers'] [$I] [' port'] ='; / / MySQL port-leave blank for default port

Mysql port. If default is 3306, leave it blank.

C.mysql username and password

1$ cfg ['Servers'] [$I] [' user'] = 'root'

The mysql user name used by MySQL user to access phpmyadmin

1fg ['Servers'] [$I] [' password'] =''

MySQL password (only needed corresponds to the password of the above mysql user name

d. Authentication method

1$ cfg ['Servers'] [$I] [' auth_type'] = 'cookie'

There are four modes to choose from here: cookie,http,HTTP,config

In 01:config mode, you can enter the URL of phpmyadmin directly without entering a user name and password, which is not safe and is not recommended.

02: when this item is set to cookie,http or HTTP, login to phpmyadmin requires a data username and password for authentication

The details are as follows:

PHP installation mode is Apache, you can use http and cookie

PHP installation mode is CGI, you can use cookie

e. Setting of phrase password (blowfish_secret)

1$ cfg ['blowfish_secret'] =''

If the authentication method is set to cookie, you need to set the phrase password, which is up to you to decide why to set the password, but you can't leave it blank, otherwise you will get an error when logging in to phpmyadmin.

All right, so far, you have successfully installed phpmyadmin. It's easy to log in and experience it.

Description:

This document only describes the basic configuration of installing phpmyadmin, and the detailed description of the configuration parameters in the config.default.php file can be found in its English notes.

Detailed version:

PhpMyAdmin is a MySQL database management tool. After installing the tool, you can directly manage MySQL data in the form of web without the need to manage it by executing system commands. It is very suitable for database managers who are not familiar with database operation commands. The installation method of the tool is described in detail below.

First, download

1. First go to the site to download the phpMyAdmin installation package: the http://www.php.cn/xiazai/gongju/97( installation includes various languages all-languages)

2. Extract it to a directory that can be accessed by web. If it is a virtual space, you can unzip it and upload it to the web directory through the ftp tool. At the same time, you can modify the name of the extracted file (you can customize the directory name).

II. Configuration

3. Open the / libraries/config.default.php file (the old version is the config.inc.php file in the root directory)

Edit with WordPad (do not use notepad, which is UTF8 coded) and follow the instructions to configure it.

4. Find $cfg ['PmaAbsoluteUri'] =''; / / change it to the URL of the phpMyAdmin that you will upload to the space

For example, $cfg ['PmaAbsoluteUri'] =' http: / / website domain name / phpmyadmin/'

5. Find $cfg ['Servers'] [$I] [' host'] = 'localhost'; / / usually use default, there are exceptions, and you don't have to modify it

6. Find $cfg ['Servers'] [$I] [' auth_type'] = 'config'; / / debug config; in your own machine if you use cookie in the space on the network.

There are four modes to choose from here: cookie,http,HTTP,config

In ① config mode, you can enter the URL of phpMyAdmin directly without entering a user name and password. It is not safe and is not recommended.

② sets cookie,http,HTTP mode, and data username and password are required to log in to phpMyAdmin.

The details are as follows: PHP installation mode is Apache, you can use http and cookie;PHP installation mode is CGI, you can use cookie.

7. Find $cfg ['Servers'] [$I] [' user'] = 'root'; / / MySQL user name

8. Find $cfg ['Servers'] [$I] [' password'] =''; / / MySQL password (only needed is left blank)

9. Find $cfg ['Servers'] [$I] [' only_db'] =''; / / if you only have 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 of choice, and zh stands for simplified Chinese

11. Look for $cfg ['blowfish_secret'] =''; / / if the authentication method is set to cookie, you need to set the phrase password, and it is up to you to decide why. You can't leave it blank here, otherwise you will be prompted with the error shown in the figure below when you log in to phpMyAdmin.

12. Save it after setting up, and now you can upload it to cyberspace. Browse the domain name of http:// website / phpmyadmin/ to test it. (just enter the user name and password of the database)

Three: frequently asked questions

1. If the following appears during installation: "phpMyAdmin-error missing mysqli extension. Please check the PHP configuration." Mistake.

The solution is as follows:

① to the\ libraries\ config.default.php file in the phpmyadmin folder: $cfg ['Servers'] [$I] [' extension'] = 'mysql'; statement.

If ② finds the sentence $cfg ['Servers'] [$I] [' extension'] = 'mysql';, continue to look for the following sentence $cfg [' Servers'] [$I] ['extension'] =' mysqli'; and remove the comment.

If ③ does not find the phrase $cfg ['Servers'] [$I] [' extension'] = 'mysql';, it changes the $cfg [' Servers'] [$I] ['extension'] =' mysqli'; statement to the $cfg ['Servers'] [$I] [' extension'] = 'mysql'; statement. (that is, make sure that the "mysql" value is valid)

/ * $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'] ='';-set the URL of your phpmyadmin 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 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'] ='';-enter here after setting the root password

/ * *

* 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'.

$iTunes +

$cfg ['Servers'] [$I] [' host'] = 'localhost'; / / MySQL hostname or IP address----. Here you can set the IP address of the remote MySQL server

$cfg ['Servers'] [$I] [' port'] =''; / / MySQL port- leave blank for default port- defaults 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')-how to connect to the MySQL server

$cfg ['Servers'] [$I] [' compress'] = FALSE; / / Use compressed protocol for the MySQL connection

/ / (requires PHP > = 4.3.0)-whether to use compression protocol, PHP version must be > = 4.3.0

$cfg ['Servers'] [$I] [' controluser'] =''; / / MySQL controluser settings

/ / (this user must have read-only

$cfg ['Servers'] [$I] [' controlpass'] =''; / / access to the "mysql/user"

/ / and "mysql/db" tables)-MySQL controls the user settings, which only have full permissions on the user and db tables under the mysql database

$cfg ['Servers'] [$I] [' auth_type'] = 'config'

/ / Authentication method (config, http or cookie based)?-if the PHP installation mode is Apache, you can use http and cookie;. If the PHP installation mode is CGI, you can use cookie; by default to config, which is not safe and is not recommended.

$cfg ['Servers'] [$I] [' user'] = 'root'; / / MySQL user-MySQL to connect to users

$cfg ['Servers'] [$I] [' password'] =''

/ / MySQL password (only needed with 'config' auth_type)-MySQL connection password. It is recommended to set the root password with phpmyadmin after installing PHP and MySQL, and then enter it here

$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- if you set the name of a database here, only this database will be displayed on the left side of the frame after login

$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 ()

$iTunes +

$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 ()

$iTunes +

$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]-whether to show all MySQL servers

$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')-whether to use GZIP output buffering if necessary

$cfg ['PersistentConnections'] = whether FALSE; / / use persistent connections to MySQL database- uses MySQL persistent connections, that is, pconnect

$cfg ['ExecTimeLimit'] = 300; / / maximum execution time in seconds (0 for no limit)-maximum script execution time (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- displays the SQL query statement when running the query

$cfg ['AllowUserDropDatabase'] = FALSE; / / show a' Drop database' link to normal users- whether to display a "delete database" connection to ordinary users

$cfg ['Confirm'] = TRUE; / / confirm' DROP TABLE' & 'DROP DATABASE'- whether a confirmation prompt box appears before deleting the data table / library

$cfg ['LoginCookieRecall'] = TRUE; / / recall previous login in cookie auth. Does mode or not- withdraw the cookie of the previous cookie authentication mode?

$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

two。 In daily development, some people may accidentally delete the phpmyadmin under our www, and then we will not be able to access our database through http://localhost/phpMyAdmin/. The page will prompt Not Found, that is, the file does not exist. How can phpmyadmin exist if we have deleted it? Right?!

Step one:

We can go to phpmyadmin's website to download phpmyadmin for installation.

Step 2:

Unzip it to the root directory of C disk, rename it to phpMyAdmin, enter the folder, find config.sample.inc.php, rename it to config.inc.php, and the editor opens the modified file. Find the following code

$cfg ['blowfish_secret'] =''

Change to

$cfg ['blowfish_secret'] =' c4ca4238a0b923820dcc509a6f75849b

Save exit

Step 3:

Go to the conf folder of apache in the environment, create a new phpmyadmin.conf file, open the code editor, and add the following code:

10Alias / phpmyadmin "c:/phpMyAdmin/"

Options Indexes FollowSymLinks MultiViews

AllowOverride all

Require all granted

Php_admin_value upload_max_filesize 128M

Php_admin_value post_max_size 128M

Php_admin_value max_execution_time 360

Php_admin_value max_input_time 360

Save exit

Step 4:

Find the configuration file httdp.conf in this folder, open it with a text editor, and add the following line at the end:

Include conf/phpmyadmin.conf

Save exit

Step 5: the last step is to restart apache

At this time, we will visit http://localhost/phpmyadmin/ again and it has returned to normal!

At this point, I believe that you have a deeper understanding of the "detailed introduction of phpmyadmin configuration", you might as well come to the actual operation! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.