Detailed steps for in-depth installation and configuration of phpMyAdmin_PHP Tutorial

phpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql data through the web without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands. Let me tell you how to install the tool:

1. First download phpmyadmin from the Internet, and then unzip it to the root directory of an accessible local server, 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 order, and configure them according to the instructions:

A. Visit the website

$cfg['PmaAbsoluteUri'] = ''; Fill in the access URL of phpmyadmin here. My directory is "127.0.0.1/phpMyAdmin/". This depends on the actual situation after decompression

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 is located, if mysql and the phpmyadmin are in For the same server, press the default localhost
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
mysql port, if it is the default 3306 , just leave it empty

C.mysql username and password

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user is the mysql user name used to access phpmyadmin
fg['Servers'][$i][' password'] = ''; // MySQL password (only neededThe password corresponding to the above mysql user name

D. Authentication method

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

There are four modes to choose from here, cookie, http, HTTP, config
The config method is to enter the access URL of phpmyadmin to enter directly. There is no need to enter the user name and password, which is unsafe. Not recommended.
When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:
PHP installation mode is Apache, http and cookies can be used;
PHP installation mode For CGI, you can use cookies

E. Setting of phrase password (blowfish_secret)

$cfg['blowfish_secret'] = '';

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

Missing mysqli extension Solution:

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. Check the php details page to see if mysql and mysqli have been started

Just make modifications based on your own situation. For example, my machine will report an error because of the third reason. Place the lib_mySQL.dll under MySQLbin into the windows directory and it will be ok!

Note: My operating system is win7.

http://www.bkjia.com/PHPjc/327013.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/327013.htmlTechArticlephpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql data through the web. There is no need to execute system commands to manage, which is very suitable for logarithms...