Where is the configuration file for installing php mysql on win7?

During the installation and configuration of PHP and MySQL, some people will face the problem of not being able to find the configuration file. Especially when using Windows 7 system, this situation may be more common. In this article, we will discuss how to install PHP and MySQL in Windows 7 system and solve the problem of how to find their configuration files.

1. Install PHP

First, we need to download the latest PHP installation program from the official website (https://www.php.net/). Once the download is complete, double-click the installer and follow the wizard's instructions to install PHP. During the installation process, be sure to select the "Add to environment variables" option, otherwise PHP will not run on the command line.

After the installation is complete, open the command prompt and enter the "php -v" command. If the installation is successful, you will see the PHP version number, otherwise you will need to check your installation steps.

2. Install MySQL

Download the latest community edition installer of MySQL, and then double-click the installer. During the installation process, you will need to set a root password. Please make sure your password is strong enough to prevent attacks.

After the installation is complete, open the command prompt and enter the "mysql -V" command. If the installation is successful, you will see the MySQL version number, otherwise you will need to check your installation steps.

3. Configure PHP

Now, we need to find the PHP configuration file. Under Windows 7 systems, PHP configuration files are usually located in the "C:\Program Files (x86)\PHP" directory. In this directory, we can find a file named "php.ini". If you cannot find this file, you need to create a new one in the PHP root directory.

Open the "php.ini" file and find the following configuration items:

;extension=php_mysql.dll
;extension=php_mysqli.dll

Uncomment these two lines of configuration items, and then set their values ​​to the DLL corresponding to the MySQL version you installed document. For example, if you installed MySQL 8.0, you should use the following configuration items:

extension=php_mysqlnd.dll
extension=php_mysqli.dll

4. Configure MySQL

Similarly, we need to find the MySQL configuration file. Under Windows 7 system, the MySQL configuration file is usually located in the "C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" directory. If you cannot find this file, you need to create a new one in the MySQL root directory.

Open the "my.ini" file and find the following configuration items:

#bind-address = localhost

Uncomment this line of configuration items, and then set it to the IP address of the server or "0.0.0.0" to Allow remote access to MySQL server.

5. Test

After completing the above configuration, we need to restart the Apache or PHP-fpm service in order for the configuration to take effect. Enter the following command in Command Prompt or PowerShell:

net stop apache2.4（或 php-fpm）
net start apache2.4（或 php-fpm）

Next, we need to test whether PHP and MySQL are working properly. Create a new file named "test.php" in the text editor and copy the following code into it:

<?php echo phpinfo(); ?>

Save and place the file in the root directory of the web server, and then open it in the browser http://localhost/test.php. If everything goes well, you will see the PHP configuration information page, which contains MySQL information.

In this way, you are done installing, configuring PHP and MySQL in Windows 7 system, and finding their configuration files!

The above is the detailed content of Where is the configuration file for installing php mysql on win7?. For more information, please follow other related articles on the PHP Chinese website!