Home > Article > Backend Development > How to set up a PHP+MySQL environment on win10
In 2021, the website development industry is developing day by day, and more and more developers and companies are beginning to pay attention to website construction and maintenance. In website construction, setting up a PHP MySQL environment is an essential task. This article will introduce in detail how to build a PHP MySQL environment on Win10.
1. Download and install xampp
xampp is an open source integrated software package for Apache MySQL PHP Perl and a tool for quickly creating a PHP environment. We can download the latest version of xampp through the software official website.
Download link: https://www.apachefriends.org/download.html
After the download is completed, click on the exe file to install. During the installation process, pay attention to modifying the installation location and port number.
2. Start xampp
After the installation is completed, xampp is not started by default, and we need to start it manually.
Click the "Start" button of the xampp control panel. If the startup is successful, there will be the word "Running", indicating that the xampp control panel has been started successfully.
3. Test environment
Open the browser, enter localhost or 127.0.0.1 in the address bar, and enter the default page of xampp. If the page displays normally, xampp has been installed and started successfully.
Next, let’s test whether the PHP environment is successfully established. Create a test.php file in the file manager. The file content is:
After saving the file, place it in the htdocs directory under the xampp installation directory. Visit http://localhost/test.php in the browser. If the page displays PHP information normally, it means that the PHP environment has been set up successfully.
4. Build the MySQL environment
The MySQL version started by xampp by default is MariaDB, but you can also click the "Shell" button in the control panel to open the command prompt as an administrator and enter the following Command to install MySQL:
cd c:\xampp\mysql\bin # 进入MySQL bin目录
mysql -u root -p # 登录MySQL
SET PASSWORD = PASSWORD('yourpassword'); # 设置MySQL密码
5. PHP and MySQL connection test
In order to test whether the connection between PHP and MySQL is normal, we can use the phpMyAdmin tool. phpMyAdmin is a Web-based MySQL management tool that can manage databases, create tables, add and delete data, and other operations.
The xampp integration package already includes phpMyAdmin by default. We can click "Admin" in the xampp control panel to enter the phpMyAdmin page. After logging in, we can perform related operations.
Select "New" -> "Database" on the phpMyAdmin page, enter "test" as the database name, and click "Create" to create a database named "test".
Next, we create a new table in the test database, select "New" -> "Table", fill in the relevant information and click "Save" to create a new table.
Finally, we insert a record into the test table, select "Insert"->"New Row", fill in the record and click "Execute" to successfully insert the record.
6. Summary
This article explains in detail how to build a PHP MySQL environment on Win10 by introducing the installation and startup of xampp, testing the PHP environment, setting up the MySQL environment and testing the connection between PHP and MySQL. Methods. By studying this article, we can quickly and effectively set up a PHP MySQL environment, providing a convenient and efficient environment for our future website development work.
The above is the detailed content of How to set up a PHP+MySQL environment on win10. For more information, please follow other related articles on the PHP Chinese website!