sweat. Without further ado, I will 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 brief explanation of these software:
Mysql uses an older version, as long as it is enough, it is just a learning process, I believe everyone will not have any doubts.
Because I am a novices, it is still necessary to install Mysql GUI (Mysql visualization tool). It is recommended that beginners install it too. Of course, experts should not BS. . .
PHP happens to see the new version released, so use it~
The same goes for Apache, I picked one casually.
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 operating interfaces are it. So, it’s okay to study one.
navicat, another Mysql GUI, a GUI made by third parties, is worth using!
If any friend doesn’t understand what their specific purpose is, I will add it to the topics in future.
The configuration officially begins!
1. First install Mysql. There is nothing special. Next all the way. When you encounter a link that allows you to Sign up, just select skip Sign-Up. Then select Configure the MySQL Server now and start configuring Mysql. Ordinary developer users can select Standard Configuration standard configuration. Follow the given default value Next all the way. When you are in the process of entering your password, type the root password of Mysql you want and then Next (it can be understood as an administrator password). Then Execute, if nothing unexpected happens, congratulations, Mysql will be configured.
There is nothing special about GUI Tool installation. You can complete it in Next. After completion, you can open one of its programs MySQL Adsministraotr. If it is a native database, fill in localhost in Server Host. Username is root. The password is the administrator password entered when installing MySQL. If you can enter smoothly, it will prove again that there is no problem with the configuration of Mysql just now, and you can also confirm that the GUI is also installed.
There is one thing to explain in the installation. At the beginning, when you are asked to configure Server Information, the above three items can be filled in at will, as long as they meet the format of the domain name, host name and email. You can refer to the writing method it gives. It should be noted 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 before on the same machine, then there will be a problem. 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 port conflicts. 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, so let Apache occupy port 80. OK, next all next. The installation of Apache is over. In future posts, I will describe how to modify IIS and Apache ports.
4. In the end, when installing PHP, select Apache 2. Module when installing PHP, as the convention is as follows: Next and Web Server Setup, because this is the Apache we just installed. Next, select the Apache configuration folder to pass through, which is the Apache2.2\conf directory in the previous Apache installation path. After that, select the component to be installed. Note that because you will connect to Mysql in the future, you must select MySQL to form under Extensions. This is the key! Next step, the installation is announced! Next, copy the previous PHP installation directory and the php_mysql.dll in the ext directory under the installation directory to the windows\system32 directory, then restart the Apache service, or simply restart the machine. At this point, the real installation and configuration work will come to an end.
Hurry up, let’s test it. Type localhost in the browser to see if It works appears! If so, congratulations again, there is no problem with Apache’s service. Then we came to the htdocs directory in the Apache installation directory and created a file with the contents of
<?php
echo phpinfo();
?>
Enter the browser again and enter localhost/ in the address bar. You should see the version information of PHP and some other information. In this way, it means that the configuration of PHP has also been successful!
Finally, test the connection with the Mysql database, create a new file and add it to it.
<?php
$link=mysql_connect("localhost","root","previous administrator password ");
if(!$link) echo "No connection was successful!";
else echo "Connected successfully!";
mysql_close();
?>
Return to the browser and type localhost/, it must be that the connection is successful!
OK~ So far, the installation, configuration and testing of Apache+PHP5+Mysql have been completed~ Are you very excited?
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 brief explanation of these software:
Mysql uses an older version, as long as it is enough, it is just a learning process, I believe everyone will not have any doubts.
Because I am a novices, it is still necessary to install Mysql GUI (Mysql visualization tool). It is recommended that beginners install it too. Of course, experts should not BS. . .
PHP happens to see the new version released, so use it~
The same goes for Apache, I picked one casually.
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 operating interfaces are it. So, it’s okay to study one.
navicat, another Mysql GUI, a GUI made by third parties, is worth using!
If any friend doesn’t understand what their specific purpose is, I will add it to the topics in future.
The configuration officially begins!
1. First install Mysql. There is nothing special. Next all the way. When you encounter a link that allows you to Sign up, just select skip Sign-Up. Then select Configure the MySQL Server now and start configuring Mysql. Ordinary developer users can select Standard Configuration standard configuration. Follow the given default value Next all the way. When you are in the process of entering your password, type the root password of Mysql you want and then Next (it can be understood as an administrator password). Then Execute, if nothing unexpected happens, congratulations, Mysql will be configured.
There is nothing special about GUI Tool installation. You can complete it in Next. After completion, you can open one of its programs MySQL Adsministraotr. If it is a native database, fill in localhost in Server Host. Username is root. The password is the administrator password entered when installing MySQL. If you can enter smoothly, it will prove again that there is no problem with the configuration of Mysql just now, and you can also confirm that the GUI is also installed.
There is one thing to explain in the installation. At the beginning, when you are asked to configure Server Information, the above three items can be filled in at will, as long as they meet the format of the domain name, host name and email. You can refer to the writing method it gives. It should be noted 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 before on the same machine, then there will be a problem. 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 port conflicts. 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, so let Apache occupy port 80. OK, next all next. The installation of Apache is over. In future posts, I will describe how to modify IIS and Apache ports.
4. In the end, when installing PHP, select Apache 2. Module when installing PHP, as the convention is as follows: Next and Web Server Setup, because this is the Apache we just installed. Next, select the Apache configuration folder to pass through, which is the Apache2.2\conf directory in the previous Apache installation path. After that, select the component to be installed. Note that because you will connect to Mysql in the future, you must select MySQL to form under Extensions. This is the key! Next step, the installation is announced! Next, copy the previous PHP installation directory and the php_mysql.dll in the ext directory under the installation directory to the windows\system32 directory, then restart the Apache service, or simply restart the machine. At this point, the real installation and configuration work will come to an end.
Hurry up, let’s test it. Type localhost in the browser to see if It works appears! If so, congratulations again, there is no problem with Apache’s service. Then we came to the htdocs directory in the Apache installation directory and created a file with the contents of
<?php
echo phpinfo();
?>
Enter the browser again and enter localhost/ in the address bar. You should see the version information of PHP and some other information. In this way, it means that the configuration of PHP has also been successful!
Finally, test the connection with the Mysql database, create a new file and add it to it.
<?php
$link=mysql_connect("localhost","root","previous administrator password ");
if(!$link) echo "No connection was successful!";
else echo "Connected successfully!";
mysql_close();
?>
Return to the browser and type localhost/, it must be that the connection is successful!
OK~ So far, the installation, configuration and testing of Apache+PHP5+Mysql have been completed~ Are you very excited?