MySQL installation (detailed illustration) _ MySQL

MySQL installation (detailed illustration) bitsCN.com

If you have installed mysql before, uninstall it and delete the "windows service" corresponding to mysql by running the "SC delete mysql" command.

Mysql installation package:

64-bit:
Http://download.pchome.net/internet/server/dbserver/detail-37168.html

After the download is complete, open the installation package. the next steps are the same as my illustration ~

Do not change the path !!!!!!!!!!!

Select the Configuration method, "Detailed Configuration (manual precise Configuration)", and "Standard Configuration". select "Detailed Configuration" to familiarize yourself with the Configuration process.

Select the Server type, "Developer Machine (development and testing class, mysql occupies a small amount of resources)", "Server Machine (Server type, mysql occupies a large amount of resources) "," Dedicated MySQL Server Machine (Dedicated Database Server, mysql occupies all available resources) ", you choose according to your own type, generally choose" Server Machine ", not too little, it will not be full.

Select the general purpose of the mysql Database, "Multifunctional Database (universal multi-function type, Good)", "Transactional Database Only (server type, dedicated to transaction processing, general) "," Non-Transactional Database Only (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data types is limited to Non-transactional ), I chose it with my own purpose. here I select "Transactional Database Only" and press "Next" to continue.

Configure InnoDB Tablespace to select a bucket for the InnoDB database file. use the default location and press "Next" to continue.

Select the average mysql access volume of your website and the number of connections at the same time. for example, "demo-support (DSS)/OLAP (about 20 connections)" and "Online Transaction Processing (OLTP) (about 500) "and" Manual Setting (manually set, enter a number by yourself) ". here I select" Online Transaction Processing (OLTP) "and my server, enough. press "Next" to continue.

Whether to enable the TCP/IP connection and set the Port. if the Port is not enabled, you can only access the mysql database on your machine. I enable it here and tick the Port Number: 3306. on this page, you can also select Enable Strict Mode, so that MySQL will not allow small syntax errors. If you are a newbie, I suggest you cancel the standard mode to reduce the trouble. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database. Press "Next" to continue

The default encoding is set to utf8, so that Chinese characters can be used normally.

Select whether to install mysql as a windows Service. you can also specify the Service Name (Service ID Name) and add the mysql bin directory to the Windows kernel-uusername-ppassword##directory. then, the complete address of mysql.exe is displayed, it is very convenient), I have checked all of them here, and the Service Name remains unchanged. Press "Next" to continue. Select whether to install mysql as a windows Service. you can also specify the Service Name (Service ID Name) and add the mysql bin directory to the Windows kernel-uusername-ppassword##directory. then, the complete address of mysql.exe is displayed, it is very convenient), I have checked all of them here, and the Service Name remains unchanged. Press "Next" to continue.

Enter the password of the root account twice.

========================================================== ========================================================== ========================================================== =

This problem occurs when you configure the path above. it will automatically generate my. if the ini configuration fails, the service cannot be enabled. at this time, your mysql installation program will be stuck in the start service !!

Error: The local computer cannot start the MYSQL service. error 1067: The process is unexpectedly terminated.

BitsCN.com