Home Operation and Maintenance Windows Operation and Maintenance About configuring the IIS6.0+php5+MySql5+PHPMyAdmin environment under Windows Server 2003 (picture)

About configuring the IIS6.0+php5+MySql5+PHPMyAdmin environment under Windows Server 2003 (picture)

Jun 07, 2017 am 09:48 AM

Configuration environment:

Operating system: Windows Server 2003 sp2 Enterprise Edition

Web server: IIS6.0 that comes with the system

Required tools:

PHP: php-5.2.12-Win32.zip

Database: mysql-5.0.22-win32.zip

Database management: phpMyAdmin-3.2.5- all-languages.zip

Configuration process:

First let’sInstallationPHP:

  1. Extract php-5.2.12-Win32.zip to any path. I extracted it to D:\php here.

  2. Rename php.ini-recommended in D:\php\ to: php.ini

  3. Let’s modify PHP’s configuration file php.ini

  1. Let's configure IIS so that it can parse PHP

    1. ##Extract phpMyAdmin-3.2.5-all-languages.zip to wwwroot. In order to facilitate management, we will Change the name to phpMyAdmin.
    2. ##Copy the config.default.php file under phpMyAdmin\libraries to phpMyAdmin and rename it to config.inc.php.
    3. Open Internet Information Services (IIS) Manager => Server, click "Web Service Extension" with the backhand key, and then click "Add a new Web Service Extension"
    4. Configure as shown, click OK

      ##Click on the website=>Click "Default Website" with the backhand key=>Click on

      Properties
    5. =>Click. "Home Directory" tab =>Click the "Configure"
    6. button

      =>Click the "Mapping" tab =>Click the "Add" button for the application extension Configure as shown in the figure, click OK.

      We create a new

      phpinfo
    7. .php file in the IIS default root directory wwwroot to check whether we have successfully installed it.
    8. Write in phpinfo.php:

      ##Enter in the browser: http://localhost/phpinfo.php
      At this time we can see the following page↓

    9. Proof that our IIS can parse PHP

      .

    10. However, we can find that libmysql.dll is not loaded by browsing this page. To solve this problem, we copy libmysql.dll to C:\WINDOWS\System32\, and in " Configuration File (php.ini) Path" item shows that the path of php.ini is under C:\WINDOWS, so we put the php.ini file into the specified C:\ Under the WINDOWS path. After restarting the computer and then opening the http://localhost/phpinfo.php page, we can find the following picture ↓

      This proves that our libmysql.dll has been loaded successfully. OK!

      Let’s install MySql below:

      The installation of MySql is very simple, so I won’t describe it here. The following diagram shows my configuration:

      1.

      2.

      3.

      4.

      5.

      6.

      7.

      8.

      9.

      Installation and configurationMySql is very simple, There are a lot of tutorials on the Internet, and they are all very well written. I am just here to give you a rough look at my configuration.

      Finally, let’s configure PHPMyAdmin:

Enter in the browser: http://localhost/ phpMyAdmin/index.php is as shown below: ↓

Note: a. The mcrypt extension cannot be loaded, please check your PHP configuration.
b. Cookies must be enabled to log in.

## Let’s solve these problems:

The first problem a is because D:\php\ libmcrypt.dll is not loaded. The solution is libmysql.dll. Copy libmcrypt.dll to C:\WINDOWS\system32\ and restart the computer. .

The second question b is because of line 177 of the config.inc.php configuration file under C:\Inetpub\wwwroot\phpMyAdmin $cfg['Servers'][$ i]['auth_type'] = 'cookie'; does not take effect. It will take effect after restarting the computer. If it is not a cookie, change it to cookie.

Now let’s browse http://localhost/phpMyAdmin/index.php, as shown below: ↓

At this time we enter the user name and password of the database. My user name here is: root , the password is: 123123, click to execute.

I also encountered a little trouble at this time. When I clicked to execute, it returned to the login page.
My solution is to click continuously after entering the user name and password and click Execute to enter. After entering, sometimes you will be prompted with some errors of one kind or another. It doesn't matter, just refresh a few times. It will be fine after logging in again. I haven't found the reason, maybe there are some bugs in the new software! At this point our environment has been successfully set up!


The above is the detailed content of About configuring the IIS6.0+php5+MySql5+PHPMyAdmin environment under Windows Server 2003 (picture). For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Can I install mysql on Windows 7 Can I install mysql on Windows 7 Apr 08, 2025 pm 03:21 PM

Yes, MySQL can be installed on Windows 7, and although Microsoft has stopped supporting Windows 7, MySQL is still compatible with it. However, the following points should be noted during the installation process: Download the MySQL installer for Windows. Select the appropriate version of MySQL (community or enterprise). Select the appropriate installation directory and character set during the installation process. Set the root user password and keep it properly. Connect to the database for testing. Note the compatibility and security issues on Windows 7, and it is recommended to upgrade to a supported operating system.

How to speed up the loading speed of PS? How to speed up the loading speed of PS? Apr 06, 2025 pm 06:27 PM

Solving the problem of slow Photoshop startup requires a multi-pronged approach, including: upgrading hardware (memory, solid-state drive, CPU); uninstalling outdated or incompatible plug-ins; cleaning up system garbage and excessive background programs regularly; closing irrelevant programs with caution; avoiding opening a large number of files during startup.

How to distinguish between closing a browser tab and closing the entire browser using JavaScript? How to distinguish between closing a browser tab and closing the entire browser using JavaScript? Apr 04, 2025 pm 10:21 PM

How to distinguish between closing tabs and closing entire browser using JavaScript on your browser? During the daily use of the browser, users may...

How to pull the vertical reference line of PS How to pull the vertical reference line of PS Apr 06, 2025 pm 08:18 PM

Pull vertical guides in Photoshop: Enable ruler view (View > ruler). Hover the mouse over the vertical edge of the ruler, and then the cursor becomes a vertical line with double arrows and hold and drag the mouse to pull out the reference line. Click Delete by dragging the guide, or hovering it into a cross.

Solutions to the errors reported by MySQL on a specific system version Solutions to the errors reported by MySQL on a specific system version Apr 08, 2025 am 11:54 AM

The solution to MySQL installation error is: 1. Carefully check the system environment to ensure that the MySQL dependency library requirements are met. Different operating systems and version requirements are different; 2. Carefully read the error message and take corresponding measures according to prompts (such as missing library files or insufficient permissions), such as installing dependencies or using sudo commands; 3. If necessary, try to install the source code and carefully check the compilation log, but this requires a certain amount of Linux knowledge and experience. The key to ultimately solving the problem is to carefully check the system environment and error information, and refer to the official documents.

MySQL can't be installed after downloading MySQL can't be installed after downloading Apr 08, 2025 am 11:24 AM

The main reasons for MySQL installation failure are: 1. Permission issues, you need to run as an administrator or use the sudo command; 2. Dependencies are missing, and you need to install relevant development packages; 3. Port conflicts, you need to close the program that occupies port 3306 or modify the configuration file; 4. The installation package is corrupt, you need to download and verify the integrity; 5. The environment variable is incorrectly configured, and the environment variables must be correctly configured according to the operating system. Solve these problems and carefully check each step to successfully install MySQL.

【Rust Self-study】Introduction 【Rust Self-study】Introduction Apr 04, 2025 am 08:03 AM

1.0.1 Preface This project (including code and comments) was recorded during my self-taught Rust. There may be inaccurate or unclear statements, please apologize. If you benefit from it, it's even better. 1.0.2 Why is RustRust reliable and efficient? Rust can replace C and C, with similar performance but higher security, and does not require frequent recompilation to check for errors like C and C. The main advantages include: memory security (preventing null pointers from dereferences, dangling pointers, and data contention). Thread-safe (make sure multi-threaded code is safe before execution). Avoid undefined behavior (e.g., array out of bounds, uninitialized variables, or access to freed memory). Rust provides modern language features such as generics

See all articles