Phpmyadmin3 installation and configuration graphic tutorial

By default, these variables are empty in the phpmyadmin configuration file. you only need to assign values to the variables according to the annotations. During PHP website development, the most basic PHP environment involves PHP, Apache/IIS, and Mysql, and database management, in addition to the command line tool provided by the Mysql database to help developers manage databases, phpmyadmin developed based on PHP is also a very useful Mysql database management program, phpmyadmin is also a required PHP program in PHP environments such as xampp. Today, we will share with you how to install and configure phpmyadmin.

Phpmyadmin installation and configuration preparation

First of all, download the phpmyadmin installation package and provide two phpmyadmin: phpmyadmin1 and phpmyadmin2. address 1 lists phpmyadmin2.x and phpmyadmin3.x. address 2 is the latest phpmyadmin version.

I downloaded phpmyadmin3.3. The PHP environment required for phpmyadmin3 installation must be PHP5.2 or above. How to configure the PHP environment?

Phpmyadmin installation tutorial: how to install phpmyadmin

First, decompress phpmyadmin-3.3.3-rc1-all-languages.zip, rename it phpmyadmin3, copy it to the php program running directory, and copy it to the D: \ PHPWEB directory.

After completing the phpmyadmin3 installation step, make sure that your IIS or Apache server is enabled and that the Mysql service is enabled, you can enter net start mysql in CMD mode to enable Mysql database service, and make sure that PHP has enabled Mysql extension Library. If one item is not enabled, phpmyadmin3 may not be opened and access error may occur.

At this point, the installation of phpmyadmin3 is complete, and the configuration of phpmyadmin is required.

Phpmyadmin Configuration tutorial

Enter the remote access address of phpmyadmin in the browser: http: // localhost/phpmyadmin3. the following interface is displayed:

Phpmyadmin remote access configuration username and password

This interface description: 1. you must use cookies to log on. 2. you must use a valid user name and password to log on remotely. if The phpmyadmin user name and password are not configured, access is denied. So how do I set the user name and password for phpmyadmin? You can configure phpmyadmin2 in either of the following ways:

1. the traditional phpmyadmin configuration method is in the index of the phpmyadmin root directory. create config. inc. php. For more information, see config. sample. inc. php.

2. in phpmyadmin3, there is a new configuration method, that is, you do not need to create config. inc. php. you only need to modify the configuration items in the libraries/config. default. php configuration file. This is because libraries/config is loaded by default in phpmyadmin3. default. php configuration file content, if there is config. inc. in the config. inc. the same variables are found in the php configuration file and overwritten. Therefore, if there are no special settings, you do not need to create a config. inc. php, as long as in libraries/config. default. php configuration.

Set the user name and password as follows:

1 2 3 4 5 6 7

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; // Set The phpmyadmin remote access method to cookie. $ Cfg ['servers'] [$ I] ['user'] = 'root '; $ Cfg ['servers'] [$ I] ['password'] = 'root '; ?>

First, set the logon mode to cookie, and then set the user name and password. the default user name is root, and the password is empty. you need to set the username and password according to the Mysql database configuration. I set them to root.

After phpmyadmin is configured, enter the user name and password to log on to phpmyadmin for Mysql database management,

Phpmyadmin Management Interface

At this point, the configuration of phpmyadmin3 is basically complete.

The additional features of the phpmyadmin chain table have not been activated. how can this problem be solved??

Back to the page, we can see that although phpmyadmin is ready for use after configuration is complete, some configuration work is still prompted at the bottom. one of the prompts is: the additional features of the chain table have not been activated. how can this problem be solved?

First, click the import link to upload scripts/create_tables. SQL and execute it to create the phpmyadmin database.

In The phpmyadmin configuration file config. default. php, find

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

$ 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 _ page'] = '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 '; ?>

By default, these variables are empty in the phpmyadmin configuration file. you only need to assign values to the variables according to the annotations.

After completing the configuration, close the browser and log on again.

The phpmyadmin configuration file now requires a phrase password. how can this problem be solved??

In The phpmyadmin configuration file config. default. php, find

1 2 3

$ Cfg ['blowfish _ secret'] = 'leapsoul. cn' ?>

Here I assign leapsoul.cn, which is used to encrypt Cookies.

Phpmyadmin logon method

Phpmyadmin3 provides four logon methods.

Config: directly enter the phpmyadmin remote logon address. you only need to set the user name and password in the configuration file.

Http: in the dialog box that appears, enter the user name and password

Signon: similar to the logon mode of page jump, you must set $ cfg ['servers'] [$ I] ['signonurl'], after you enter the phpmyadmin remote logon address, the URL set by signonURL is automatically displayed.

Cookie: the logon method when phpmyadmin is configured.

Now the installation and configuration of phpmyadmin3 have been completed, and you can experience the new features of phpmyadmin.