sweat. Without further ado, let me first list the versions of the relevant programs I downloaded:
Mysql-4.1.8-essential-win
Mysql-gui-tools-5.0-r12-win32
php -5.2.5-win32-installer
apache_2.2.4-win32-x86-no_ssl
phpMyAdmin-2.11.5.1-all-languages
navicat8_mysql_cs-v8.0
A little bit about these software Explanation:
Mysql uses an older version, which is sufficient anyway. It is just a learning process, so I believe everyone will have no doubts.
Because I am a novice, it is necessary to install the Mysql GUI (Mysql visualization tool). It is recommended that beginners also install it. Of course, experts should not BS. . .
PHP happens to see a new version released, so use it~
The same goes for Apache, I picked one at random.
PHPMyAdmin is a web-based MySQL visualization tool, don’t underestimate it~ If the virtual space provided by general space providers supports MySQL, most of its operation interfaces will be it. So, it doesn’t hurt to learn one.
Navicat is another Mysql GUI. It is a better GUI made by a third party and is worth using!
If there are friends who don’t understand what they are used for, I will add them in future topics.
Configuration officially started!
1. First install Mysql, nothing special. Next, when you encounter a link that asks you to Sign up, just choose skip Sign-Up. Then select Configure the MySQL Server now to start configuring Mysql. Ordinary development users can choose Standard Configuration and follow the default value Next. When the time comes for you to enter the password, type in the root password of Mysql you want. Then Next (can be understood as the administrator password). Then Execute, if nothing else, congratulations, Mysql is now configured.
2. There is nothing special about the Mysql GUI Tool installation. It can be completed by clicking Next. After completion, you can open one of its programs MySQL Adsministraotr. If it is a local database, fill in localhost in the Server Host. Username is root, and the password is the administrator password you just entered when installing Mysql. If you can enter successfully, it once again proves that there is no problem with the Mysql configuration just now, and you can also confirm that the GUI is also installed in place.
3. There is one thing to note about the installation of Apache. Click all Next at the beginning. When it comes time to configure Server Information, you can fill in the above three items as long as they conform to the format of domain name, host name and email. You can refer to the writing method it gives. It should be reminded that the port setting of Apache HTTP uses port 80 as the HTTP service port by default. This is not surprising at first, but if you have installed IIS on the same machine before, then there will be problems. The port of the HTTP service in IIS is also 80. If you let Apache's HTTP port still use 80 here, then it will not be able to start the Apache service due to a port conflict. Then, there are only two solutions, either stop or modify the HTTP service port of IIS, or modify the HTTP service port of Apache. Here, I can only assume that you have not installed IIS, then let Apache occupy port 80. Okay, all next. The installation of Apache is complete. In a future post, I will describe how to modify the IIS and Apache ports.
4. For the final PHP installation, follow the usual practice at the beginning. Select Apache 2.2.x Module during Web Server Setup, because this is the Apache we just installed. Next, select the Apache configuration folder path, which is the Apache2.2conf directory in the previous Apache installation path. Then select the components to be installed. Note that because you will need to connect to MySQL in the future, you must select the MySQL component under Extensions. This is the key! Next step, the installation is completed! Next, copy the libmysql.dll in your PHP installation directory and the php_mysql.dll in the ext directory under the installation directory to the windowssystem32 directory. Then, restart the Apache service, or simply restart the machine. Here, The entire installation and configuration work is now complete.
Hurry up, let’s test it out. Type localhost in the browser and see if It works! If so, congratulations again, there is no problem with Apache's service.Then we went to the htdocs directory in the Apache installation directory and created a test.php file with the content:
echo phpinfo();
?>
Enter the browser again and enter localhost/test.php in the address bar. You should see the version information of PHP and some other information. In this case, it means that the configuration of PHP is also It was a success!
Finally, test the connection with the Mysql database. Create a new test2.php file and add
$link=mysql_connect(" localhost","root","Previous administrator password ");
if(!$link) echo "The connection was not successful!";
else echo "The connection was successful!";
mysql_close() ;
?>
Go back to the browser and type localhost/test2.php. The connection must be successful!
Okay~ At this point, the installation, configuration and testing of Apache+PHP5+Mysql are all completed~ Are you feeling excited~