PHP + Apache + MySQL classic match, create environment 4 phpMyAdmin installation (reprinted and modified)

PhpMyAdmin Installation

PhpMyAdmin is an excellent tool for managing MySQL databases based on the PHP environment.

Official: http://www.phpmyadmin.net/home_page/downloads.php (download its all-languages.zip package,
Release version. Do not release the development version)

Download from the narrow address above, such as: phpMyAdmin-3.3.4-all-languages.zip (the actual version number is slightly different), decompress and get the phpMyAdmin-3.3.4-all-languages folder, copy the folder to E: \ HTML and rename phpMyAdmin.

PhpMyAdmin can be used without installation.

PhpMyAdmin Configuration

Go to the E: \ HTML \ phpMyAdmin folder, find the config. sample. Inc. php file, and rename it config. Inc. php. Open the file in the editor and make the following changes or settings:

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

After saving the configuration, enter the following URL in the browser: http: // 127.0.0.1/phpMyAdmin. The phpMyAdmin logon page is displayed:

(In fact, I didn't see this interface at the beginning, but reported that the mysqli component was missing. I watched the web for a long time and the machine restarted several times, then I found the following solution on the Internet. After the attempt, the solution is still unsolved. At the end of work, after the next day, open the machine and enter the URL to find that it is running properly. The reason is unknown.

1. Check whether PHP. ini; Extension = php_mysqli.dll has been enabled, that is, remove the previous one;

(It may be caused by this step, because this php_mysqli.dll is not opened in this tutorial, so it may solve the problem after it is enabled)
2. Check whether the php. ini extension_dir address points to the ext directory of the PHP Directory. This step is critical. I am on this step.
= "E: \ www \ php54 \ Ext". Set it to your own directory.

(This step should be useless in the tutorial, because we copied all the DLL files directly to the System32 folder)
3. Check whether lib_mysql.dll has been copied to the Windows directory. This DLL file has multiple forms of libmysql_d.dll with no underscores. Therefore, you should check it yourself.

(This lib_mysql.dll file does not exist in this tutorial. Based on the subsequent successful conclusion, I think this file may not matter)
4. Check whether the php_mysqli.dll file exists online in the ext directory of the PHP installation directory. It also indicates that it is best to decompress the zip package without file loss.

(This reason does not exist in this tutorial)
5. view the PHP details page <? PHP phpinfo () ;?>, Check whether MySQL and mysqli have been started. This step is to check whether you have enabled mysqli.
If the mysqli keyword is not enabled, you cannot view it on the PHP details page.

(I have seen this. mysqli displays the Enable status)

So to sum up, if there is a problem, the changes will still fail to see the effect. We recommend that you restart it. If a master passes by, by the way, we will help you analyze the problem that I reported a lack of mysqli components, the reason for success later is that it is really good .)

Enter the user name and password (for example, root/root123) to go to the database management interface:

PhpMyAdmin allows you to easily manage databases and data tables in the database (create, modify, and delete ).

Summary:

Several files used for Configuration:

1. The php. ini file is copied to C: \ WINDOWS. This file is the configuration file of the PHP function component, used to indicate which functions of PHP are enabled, such as "; php_mysql.dll ";

2. httpd. the conf file is stored in the Apache installation path. It is in the conf folder in the Apache folder under c: \ Program Files by default. It is used to specify the port used and the directory, and the DocumentRoot folder. Which index.html or index. php file is opened after the network address is opened.

3. the config. Inc. php file is located in the phpMyAdmin folder under the DocumentRoot folder specified in the httpd. conf file. It is used to set the password for accessing MySQL and the user name.