Detailed phpMyAdmin Simple Installation tutorial

Source: Internet
Author: User
Tags ftp mysql host php file set cookie mysql database phpmyadmin
Simply put, phpMyAdmin is a MySQL management tool that, when installed, can directly manage MySQL data through the web, without the need to perform system commands to manage it,

is ideal for database managers unfamiliar with database operation commands, Next I'll say how to install the tool:

1. First to the Internet to download phpMyAdmin , and then extract to the Web directory can be accessed (if it is virtual space, you can extract the FTP after uploading to the web directory), of course, you can modify the extracted after the name of the file.

2. Configure config file

Open Libraries under the config.default.php file, locate the following sequence, according to the description of the configuration can be:

A. Visit Web site


$cfg [' pmaabsoluteuri '] = '; here to fill out phpMyAdmin's visit URL

b.mysql host information


$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address

fill in the IP address of the server where localhost or MySQL resides, 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 the default is 3306, leave blank to

c.mysql username and password


$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpMyAdmin used MySQL username

fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed corresponds to the above MySQL username password

D. Authentication method

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';

Here are four modes to choose from, Cookie,http,http,config

Config mode that is to enter the phpMyAdmin access URL can directly enter, without entering user name and password, is not safe, do not recommend use.

when the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires the data username and password to authenticate, 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) settings


$cfg [' blowfish_secret '] = ';

If the authentication method is set to a cookie, you need to set the phrase password, set why the password, you decide, but you can not leave blank, otherwise you will be prompted to log in phpMyAdmin error

OK, so far, you have successfully installed phpMyAdmin, simple, and quickly login experience under the bar


This document describes only the basic configuration of the installation phpMyAdmin, the detailed instructions for each configuration parameter in the config.default.php file can be

phpMyAdmin is a MySQL database management tool, after the installation of the tool, that is, the Web form can directly manage the MySQL data, without the need to execute system commands to manage, very suitable for database operation commands unfamiliar database managers, The installation method for the tool is described in detail below.

One, download
1, first to the official site Download phpMyAdmin installation package: contains various languages all-languages)

2, and then extract to the Web can access the directory, if it is virtual space, can be extracted through the FTP tool uploaded to the Web directory, and you can modify the extracted after the name of the file (you can customize the directory name).

II, configuration
3, open the/libraries/config.default.php file (the old version is the root of the file), with WordPad (do not use Notepad, this is the UTF8 encoding) for editing, according to the instructions configured.

4, find $cfg [' Pmaabsoluteuri ']= '; Modify the URL for the phpmyadmin 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 the

6, find $cfg [' Servers '] [$i] [' auth_type '] = ' config '; Debug in your own machine with config, if the space on the network with cookies.

Here are four modes to choose from: Cookie,http,http,config

①config Way is to enter the phpMyAdmin access URL directly, no need to enter user name and password, is not safe, not recommended.

② set cookie,http,http mode, login phpMyAdmin need data username and password to authenticate.

specific as follows: PHP installation mode is 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 can be)

9, find $cfg [' Servers '] [$i] [' only_db '] = '; You only have one data set up, set to your database name; If you want to build a server, then it is recommended to leave blank

10, find $cfg [' defaultlang '] = ' en '; Here is the choice of language, en represents the meaning of Simplified Chinese

11, find $cfg[' blowfish_secret '] = '; If the authentication method is set to a cookie, you need to set the phrase password, set why the password, it is up to you, you can not leave this blank, otherwise you will be prompted as shown in the following image when you log in phpMyAdmin.

12, set up after the save, can now upload to cyberspace, browse http://website domain name/phpmyadmin/test. (Enter the username and password for the database)

If you are in the process of installing: "phpMyAdmin-error is missing mysqli extension." Check your PHP configuration. Error
The workaround is as follows:
① to the librariesconfig.default.php file in the phpMyAdmin folder: $cfg [' Servers '] [$i] [' extension ']= ' MySQL ';
② If there is found $cfg[' Servers ' [$i] [' extension ']= ' MySQL '; this sentence, continue to find the following sentence $cfg[' Servers ' [$i] [' extension']= ' mysqli ']; and remove its annotations.
③ if no $cfg[' Servers ' [$i] [' extension ']= ' MySQL ' is found, the $cfg[' Servers '] [$i] [' extension ']= '] [mysqli ']; cfg[' Servers ' [$i] [' extension ']= ' MySQL '; Statement. (that is, ensure that the "MySQL" value is valid)

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.