MySQL 5 installation tutorial. 1. installing Mysql on windows is a standard installation welcome program that we are familiar. If you do not need to change the default installation directory, click next to complete the installation. Follow the steps below to install Mysql
Mysql installation on windows is a standard installation welcome program.
If you do not need to change the default installation directory, click next to complete the installation.
The following describes the options in the installation process in the installation sequence.
1. the default value is Typical. we recommend that you change it to Custom.
In this step, select the component and Change the folder location. use the default component and select Change to Change the installation directory. note: the path for installing mysql cannot contain Chinese characters!
2. the program prompts whether to register on mysql.com. you can Skip this step, that is, Skip Sign-Up.
3. after the installation is complete, select the select box for configuring the mysql server now.
4. start Configuration. select the first Detailed Configuration.
5. select the type of mysql application. The first type is the development server, which only uses as little memory as possible. The second type is the common WEB server, which uses a moderate amount of memory, the last one is that this server only runs the mysql database and occupies all the memory. select one of them based on your needs. I set up a development platform instead of a database server for actual applications, so I chose the first one.
6. select database usage. The first option is multi-function usage. it will optimize the database into a good innodb storage type and an efficient myisam storage type. The second option is only used for transaction processing, it is best to optimize innodb, but it also supports myisam. The last one is a non-transaction processing type and is suitable for simple applications. only the myisam type that does not support transactions is supported. Generally, the first type of function is selected, and the first type is selected.
7. select the data storage location of InnodDB. the default value is enough.
8. select the maximum number of connections allowed by mysql. you can select the number based on your needs. the default value is enough.
9. select the database listening port. Generally, the default port is 3306. if it is changed to another port, remember the modified port when connecting to the database. Otherwise, you cannot connect to the mysql database. the default port is.
10. set the default mysql encoding. you can select gb2312 or gbk as needed. if the database file already exists, it must be consistent with the encoding of the existing database; otherwise, garbled characters may occur.
11. select whether to set mysql to a windows service. we recommend that you set it to a service so that you can enable and disable mysql databases through the service. We recommend that you select the check boxes below. In cmd mode, you do not have to execute commands in the bin directory of mysql.
12. set the mysql super user password. the super user has all permissions for mysql. the check box below shows whether to allow the remote machine to connect to your mysql server with the root user. select as needed.
13. click Execute. if the preceding settings are correct, the installation will soon be successful.
Mysql installation on windows is a standard installation welcome program that we are familiar. If you do not need to change the default installation directory, click next to complete the installation. Next, press...
