Installation of MySQL (detailed illustrations)

installation of MySQL (detailed illustrations)

If you've already installed MySQL, uninstall it and delete MySQL's Windows service from 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 and the next steps are the same as my diagram.

Never change the path!!!!!!!!!!!

Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.

Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", people choose according to their own type, generally choose" Server machine ", not too little, will not be full.

Choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), with their own use and choose, I choose " Transactional Database Only ", press" Next "to continue.

Configure the InnoDB tablespace to select a storage space for the InnoDB database file, use the default location, and press "Next" to continue

Select your site's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500)", " Manual Setting (manually set, you lose a number) ", I choose" Online Transaction Processing (OLTP) ", your own server, should be enough, press" Next "to continue

Whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on your own machine, I am here to enable, put the front tick, Port number:3306, on this page, you can also select "Enable Standard mode" (Enabling Strict Mode), so that MySQL does not allow a small syntax error. If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

The default encoding is set to UTF8 so that you can use Chinese characters normally

Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue. Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

Enter password information for root account two times

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

This is the case when you configure the path on the time there is a problem, it automatically help you generate the My.ini configuration will be problematic, resulting in the service can not be opened, this time your MySQL installer will always be stuck in the start service here!!

Error condition: The local computer cannot start the MySQL service error 1067 process terminated unexpectedly

Installation of MySQL (detailed illustrations)