Phpmyadmin3 Installation Configuration Diagram tutorial

In PHP Web development, the most basic PHP environment to build involved in PHP, Apache/iis, Mysql, for database management, in addition to the MYSQL database itself provides command-line tools to facilitate the management of the database outside the developer, PHP based on the development of phpMyAdmin is also a very useful MySQL database management program, in XAMPP and other PHP environment configuration installer, phpMyAdmin is also an essential PHP program. Share with you today how to install, configure phpMyAdmin.

phpMyAdmin Installation Configuration Preparation work

First of course is Download phpMyAdmin installation package, provide two phpMyAdmin download address: phpMyAdmin Download address 1,phpmyadmin download Address 2, Address 1 lists phpmyadmin2.x and phpmyadmin3.x, and address 2 is the latest phpMyAdmin version.

I downloaded the phpmyadmin3.3, the PHP environment required for phpmyadmin3 installation is at least PHP5.2,MYSQL5 version. How do I configure the PHP environment?

phpMyAdmin Installation Tutorial: How to Install phpMyAdmin

First unpack the phpmyadmin-3.3.3-rc1-all-languages.zip, then rename it to phpmyadmin3, copy it to the PHP program run directory, and I copy it to the D:\PHPWEB directory.

After completing this step of the phpmyadmin3 installation, make sure that your IIS or Apache server is turned on and that the MySQL service is turned on and that you can enter the MySQL database service in cmd mode and start MySQL. Also, make sure that PHP has the MySQL extension library enabled. As long as one of the items is not turned on, it may cause phpmyadmin3 to open and access errors.

So far phpmyadmin3 installation work completed, the next will be phpMyAdmin configuration work.

phpMyAdmin Configuration Tutorial

First enter the phpMyAdmin remote access address in the browser: http://localhost/phpmyadmin3, the following interface appears

phpMyAdmin Remote Access configuration user name password

This interface description: 1, must be in the form of cookies, 2, must be a legitimate user name and password for remote login, if not configured phpMyAdmin username and password, Access will be denied. So how do you set a username and password for phpMyAdmin? There are two ways to configure the configuration of the phpmyadmin2 version:

1, the traditional phpMyAdmin configuration, in the phpMyAdmin root directory index.php the same level directory, create config.inc.php, specific reference profile please refer to config.sample.inc.php.

2, in the phpmyadmin3 version, there is a new way to configure, that is, do not need to create config.inc.php, as long as the libraries/config.default.php configuration file to modify the configuration items. This is because libraries/is first loaded by default in Phpmyadmin3 Config.default.php the contents of the configuration file, if there is a config.inc.php, will find the same variable in the config.inc.php configuration file and overwrite, so if there is no special setting, you do not need to create a config.inc.php, as long as the LIBR Aries/config.default.php the relevant configuration can be done.

Setting the username and password works as follows

1 2 3 4 5 6 7

? $cfg ["Servers"] [$i] ["auth_type"] = "cookie";/set phpMyAdmin remote access method as a cookie $cfg ["Servers"] [$i] ["user"] = "root"; $cfg ["Servers"] [$i] ["password"] = "root"; ?>

First set the login as a cookie, and then set the username and password, the default user name is root, the password is empty, you need to be based on the MySQL database configuration username and password settings, I set for root.

After configuring the phpMyAdmin, then enter the username and password to login phpmyadmin for MySQL database management, as shown:

phpMyAdmin Management Interface

so far, phpmyadmin3 configuration work is basically completed.

phpMyAdmin The additional features of the linked table have not been activated how to solve the problem ?

Back to the diagram above we see that although the phpMyAdmin configuration is complete, but the bottom is still a hint that some of the configuration work is not complete, one of the tips: The additional features of the linked table have not been activated, so how to solve it?

First, click on the import link, upload scripts/create_tables.sql and execute, create the phpMyAdmin database.

Second, in the phpMyAdmin configuration file config.default.php found

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21st

? $cfg ["Servers"] [$i] ["pmadb"] = "phpMyAdmin"; $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] ["designer_coords"] = "pma_designer_coords"; $cfg ["Servers"] [$i] ["tracking"] = "pma_tracking"; ?>

These variables are empty by default in the phpMyAdmin configuration file, and you only need to assign values to the variables based on the annotations.

After you complete the configuration, turn off the browser and log on again.

phpmyadmin configuration file now needs a phrase password How to solve ?

Found in the phpMyAdmin configuration file config.default.php

1 2 3

? $cfg ["blowfish_secret"] = "leapsoul.cn" ?>

Here I assign a value of leapsoul.cn, which is used for the encryption of cookies.

phpMyAdmin Login Mode Description

In Phpmyadmin3, there are four types of logins in total

Config: Directly enter phpMyAdmin remote login address, as long as the user name password in the configuration file can be set.

http: Pop-up dialog box, enter user name and password

Signon: Similar to the page jump login mode, at the same time need to set $cfg["Servers" [$i] ["Signonurl"], when you enter the phpMyAdmin remote login address will automatically jump to the Signonurl set URL.

Cookie: That is, the phpMyAdmin configuration when the login method.

Now that the entire phpmyadmin3 installation and configuration is complete, you can experience the new features of phpMyAdmin new version.

　　Note : PHP Web Development Tutorials-leapsoul.cn Copyright, reproduced in the form of links to indicate the original source and this statement, thank you.