PHP + Apache + MySQL classic match, create environment 3 MySQL installation (reproduced and modified)

Install MySQL

Official MYSQL: http://www.mysql.com/downloads/mysql (Open this URL, and you will see MySQL Community
Server version, right. You are not mistaken, that is, you should release this version. I currently see the latest version is 5.5.27,: http://www.mysql.com/downloads/mirror.php? Id = 408997. Do not make a mistake. I will make a mistake several times. It is so dark that you can directly install the MSI file. Therefore, some of the following tutorials may fail to be installed due to updates to the MySQL website. This is why I have reproduced and modified this tutorial)

Download the winsows-32-x86 package from the above, such as: mysql-5.1.48.zip (the actual version may be slightly different ). After the download is complete, decompress the file to obtain the installation file. Double-click the installation file to install it.

Prompt

The installation path is recommended in a non-system disk path such as D: \ mysql, so that the data file will not be damaged when the system is reinstalled.

MySQL Configuration

2. After installation is completeTo enter the Database Configuration Wizard interface:

4. Here we select the detailed configuration (detailed configuration), click the next button, and then select the service type:

   We recommend that you select a server machine ).

6. After selecting the server type configuration, click Next To Go To The database usage configuration page. We recommend that you select the multifunctional database, as shown in the figure below.
8. After selecting the database purpose, click Next To go to the InnoDB data storage location configuration page. The installation directory is used by default.
10. After the data storage configuration is selected, click Next to enter the connection count setting page. Select manual setting. You can enter the number of connections as needed for personal development and testing, 20 is enough.
12. After selecting the number of connections configuration, click Next to enter the access port configuration interface. The default value is "3306", which does not need to be changed.
14. After selecting the access port configuration, click Next To go to the character set configuration page:

    You can select the third GBK here, but the current international trend is quite obvious. More and more configurations default to utf8, so you can also select the second item.

16. After selecting the character set configuration, click Next To Go To The Windows service configuration page:

    Select. The first option indicates that MySQL is a service option for Windows. The service name is MySQL, and the "launch the MySQL server automatically" option is checked, it indicates that MySQL is automatically started with the system without manual start.

18. After selecting the Windows service configuration, click Next to go to the root (Administrator) password configuration page. Set a root password and keep it in mind (such as root123 ). If it is a formal application, you should set the password to be complex enough and modify it regularly.

    "Create an anonymous account" indicates creating an anonymous access account, which has certain security risks.

20. After selecting the root password configuration, click the execute button to start configuring MySQL according to the options. wait patiently until the configuration is complete. When "service started successfully" is displayed, the configuration is complete and the MySQL service is started successfully.
22. Click Finish to complete the MySQL configuration process.