Step-by-step phpMyAdmin installation and configuration-PHP Tutorial

Go deep into phpMyAdmin installation and configuration steps. Phpmyadmin is a mysql management tool. after installing this tool, you can directly manage mysql data in the form of web, instead of executing system commands, phpmyadmin is a mysql management tool. after installing phpmyadmin, you can directly manage mysql data on the web without executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. next I will explain how to install the tool:

1. download phpmyadmin from the Internet and decompress it to the root directory of the local server that can be accessed, such as the www directory of apache.

2. configure the config file
Open the config. default. php file under libraries, find the following items in sequence, and configure the items as instructed:

A. visit the website

$ Cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access url here. my directory is" 127.0.0.1/phpMyAdmin/", which depends on the actual extraction.

B. mysql host information

$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address
Enter the IP address of the localhost or mysql server. if mysql and phpmyadmin are on the same server, press the default localhost
$ Cfg ['servers'] [$ I] ['port'] = ''; // MySQL port-leave blank for default port
Mysql Port. if it is 3306 by default, leave it blank.

C. mysql User name and password

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name
Fg ['servers'] [$ I] ['password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql User name

D. authentication method

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

There are four modes available here: cookie, http, HTTP, config
In config mode, you can directly access the phpmyadmin access url without entering the user name and password. it is insecure and is not recommended.
When this option is set to cookie, http, or HTTP, you need to verify the data username and password to log on to phpmyadmin. The details are as follows:
The PHP installation mode is Apache, and http and cookie can be used;
The PHP installation mode is CGI and cookie can be used.

E. set the phrase password (blowfish_secret)

$ Cfg ['blowfish _ secret'] = '';

If the authentication method is set to cookie, you need to set the phrase password.

Solution to mysqli extension missing:

1. check whether php. ini; extension = php_mysqli.dll is enabled.

2. check whether the php. ini extension_dir address points to the ext Directory of the php directory.

3. check whether lib_mysql.dll has been copied to the windows directory.

4. check whether the php_mysqli.dll file exists in the ext Directory of the php installation directory.

5. view the php details page To see if mysql and mysqli have been started

Make modifications based on your own situation. For example, my local Machine reports an error for 3rd reasons. Put lib_mySQL.dll under MySQL \ bin in the windows directory!

Note: my operating system is win7.

...