Home >Backend Development >PHP Tutorial >mysql5 detailed installation tutorial_PHP tutorial
mysql5 detailed installation tutorial_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:58:25930browse
1. Mysql installation
The installation of Mysql under the windows platform is a standard installation welcome program that we are familiar with.
If you do not need to change the default installation directory, keep clicking next to complete the installation.
The following explains the options during the installation process in accordance with the installation order.
1. The default is Typical, it is recommended to change it to Custom
This step requires selecting components and changing the folder location. You can use the default components. Select Change to change the installation directory. Note: Install mysql. The path cannot contain Chinese characters!
2. The program prompts whether you want to register on mysql.com. You can choose to skip it, that is, Skip Sign-Up.
3. The installation is complete, select the check box to start configuring the mysql server now.
4. Start the configuration, select the first item Detailed Configuration
5. Select the type of mysql application. The first one is the development server, which will use as little memory as possible. The second one is the development server. The first is an ordinary WEB server, which will use a medium amount of memory. The last is a server that only runs the mysql database and will occupy all the memory. Choose one of them according to your needs. What I built is a development platform, not a database server for actual applications, so I chose the first option.
6. Select the database usage. The first one is multi-functional, which will optimize the database into a good innodb storage type and a high-efficiency myisam storage type. The second one is only used for transaction processing. The best optimized innodb, but also supports myisam. The last one is a non-transaction processing type, suitable for simple applications. Only the myisam type that does not support transactions is supported. Generally, I choose the first type that is multi-functional. I chose the first type.
7. Select the data storage location of InnodDB, the default is enough.
8. Select the maximum number of connections allowed by mysql. You can choose according to your own needs. The default is OK
9. Select the port for database monitoring. Generally, the default is 3306. If you change it to another port , you must remember the modified port when connecting to the database in the future, otherwise you cannot connect to the mysql database, just default it The file must have the same encoding as the original database, otherwise garbled characters may appear.
11. Choose whether to set mysql as a windows service. It is recommended to set it as a service, so that you can start and close the mysql database through the service in the future. It is recommended to check the following checkbox, so that in cmd mode, you do not have to go to the bin directory of mysql to execute the command.
12. Set the super user password of mysql. The super user has all permissions on mysql. Select the check box below to allow remote machines to connect to your mysql server as the root user. Select as needed.
13. Click Execute. If there are no problems with the previous settings, the installation will be successful soon.
http://www.bkjia.com/PHPjc/317601.html