1. Mysql installation
Mysql installation on the Windows platform is a standard installation welcome program we are familiar with.
If you do not need to change the default installation directory, click next to complete the installation.
The following explains the options during the installation process in the order of installation.
1. The default is Typical, it is recommended to change to Custom
This step requires selecting components and changing the folder location. The components can be used by default. Select Change to change the installation directory. Note: The path to install mysql cannot contain Chinese!
2. When the program prompts whether to register on the program, you can choose to skip, that is, Skip Sign-Up.
3. After the installation is completed, select the selection box to start configuring mysql server now.
4. Start the configuration and select the first item Detailed Configuration
5. Choose the type of mysql to be applied to. The first is the development server, which will only use as little memory as possible. The second is an ordinary WEB server, which will use a medium amount of memory. The last is that this server only runs the mysql database, which will occupy all the memory. Choose one of them according to your needs. I built a development platform, not a database server for actual application, so I chose the first one.
6. Choose the purpose of the database. The first is a multi-functional purpose, which will optimize the database into a good innodb storage type and a high-efficiency myisam storage type. The second is only used for transaction processing types. The best optimization of innodb, but also supports myisam. The last is a non-transaction processing type, which is suitable for simple applications. Only the myisam type that does not support transactions is supported. Generally, I choose the first one with multifunctional one, but I choose the first one.
7. Select the data storage location of InnodDB, and the default is as follows.
8. Select the maximum number of connections allowed by mysql. You can choose according to your needs, and the default is
9. Select the port for database monitoring. Generally, the default is 3306. If it is changed to another port, remember the modified port when connecting to the database in the future. Otherwise, the mysql database cannot be connected, and the default is
10. Set the default encoding of mysql. You can select gb2312 or gbk as needed. If there is a database file, it must be consistent with the original database encoding, otherwise garbled code may occur.
11. Choose whether to set mysql to Windows service. It is recommended to choose to set it to service, so that the mysql database can be started and closed in the service in the future. It is recommended to also check the check box below, so that in cmd mode, there is no need to execute the command in mysql's bin directory.
12. Set the super user password of mysql. The super user has all permissions to mysql. The check box below selects whether to allow remote machines to connect to your mysql server with root, and select it according to your needs.
13. Click Execute, and if there is no problem with the previous settings, you can install it successfully soon.
Mysql installation on the Windows platform is a standard installation welcome program we are familiar with.
If you do not need to change the default installation directory, click next to complete the installation.
The following explains the options during the installation process in the order of installation.
1. The default is Typical, it is recommended to change to Custom
This step requires selecting components and changing the folder location. The components can be used by default. Select Change to change the installation directory. Note: The path to install mysql cannot contain Chinese!
2. When the program prompts whether to register on the program, you can choose to skip, that is, Skip Sign-Up.
3. After the installation is completed, select the selection box to start configuring mysql server now.
4. Start the configuration and select the first item Detailed Configuration
5. Choose the type of mysql to be applied to. The first is the development server, which will only use as little memory as possible. The second is an ordinary WEB server, which will use a medium amount of memory. The last is that this server only runs the mysql database, which will occupy all the memory. Choose one of them according to your needs. I built a development platform, not a database server for actual application, so I chose the first one.
6. Choose the purpose of the database. The first is a multi-functional purpose, which will optimize the database into a good innodb storage type and a high-efficiency myisam storage type. The second is only used for transaction processing types. The best optimization of innodb, but also supports myisam. The last is a non-transaction processing type, which is suitable for simple applications. Only the myisam type that does not support transactions is supported. Generally, I choose the first one with multifunctional one, but I choose the first one.
7. Select the data storage location of InnodDB, and the default is as follows.
8. Select the maximum number of connections allowed by mysql. You can choose according to your needs, and the default is
9. Select the port for database monitoring. Generally, the default is 3306. If it is changed to another port, remember the modified port when connecting to the database in the future. Otherwise, the mysql database cannot be connected, and the default is
10. Set the default encoding of mysql. You can select gb2312 or gbk as needed. If there is a database file, it must be consistent with the original database encoding, otherwise garbled code may occur.
11. Choose whether to set mysql to Windows service. It is recommended to choose to set it to service, so that the mysql database can be started and closed in the service in the future. It is recommended to also check the check box below, so that in cmd mode, there is no need to execute the command in mysql's bin directory.
12. Set the super user password of mysql. The super user has all permissions to mysql. The check box below selects whether to allow remote machines to connect to your mysql server with root, and select it according to your needs.
13. Click Execute, and if there is no problem with the previous settings, you can install it successfully soon.