Install mysql_MySQL in windows

Install mysql bitsCN.com on windows

Install MySql
1. double-click the MySQL installation package and click Next.
2. Setup Type (installation options): Typical (Typical), Complete (Complete), and M (Custom ). Select Custom and click Next.
3. Custom Setup (Custom installation settings). click "Entire feature will be installed on local hard drive" in the inverted triangle to install all the items, click the Change button below, select the installation location, and click Next. Note: Check the installation location of all options. it is best to install them in the same location.
4. Ready to Install the Program (prepare the installation Program), observe the settings in the middle, and click Next. otherwise, click Back and modify.
5. during the installation process, a new window is displayed, which advertises MySQL Enterprise (MySQL Enterprise Edition). if you ignore the window, click Next until the window is closed.
6. Wizard Complete (the installation Wizard is Complete), click the check box before Launch the MySQL Instance Configuration Wizard (start mysql Configuration Wizard), and then click Finish to enter the MySQL Configuration interface.
7. click Next.
8. select the configuration method (Please select a configuration type ). There are two options: Detailed Configuration (Detailed Configuration) and Stardard Configuration (standard Configuration). here we choose Detailed Configuration.
9. select the server type (Please select a server type ). There are three options: Developer Machine (for development and testing), Server Machine (for servers), and Dedicated MySQL Server Machine (for Dedicated servers). since I am used for development, so select the first item and click Next.
10. select database usage ). There are three types: Multifuctional Database, Transactional Database Only, and Non-Transactional Database Only, however, according to the English comments and other online post references, the first Multifuctional Database is selected, and then click Next.
11. select the file storage location of the InnoDB database (Please select the drive for the InnoDB datafile). the default location is the MySQL installation location. Keep the default value and click Next.
12. select the exact traffic (Please set the approximate number of concurrent connections to the server) that is connected to the server at the same time ). Three options: demo-support (DSS)/OLAP (about 20), and Online Transaction Processing (OLTP) (about 500 ), the third is Manual Settings (Manual setting). because I used it for development and testing, select the first one and click Next.
13. network options (Please select the networking options ). The first is whether to Enable TCP/IP connection. I did not select this option. Therefore, I can only access the SQL database on my computer, and the second is Enable Strict Mode, we recommend that you select this option for new users, so that the code is more standard.
14. select the default character set (Please select the character set ). The first is Stardard Character Set (standard Character Set). The default value is Latin1, which is suitable for English storage. The second value is Best Support for Multilingualism (most suitable for multiple languages). The default value is utf8, it is suitable for storing multilingual character sets. The third option is manual selection. Here we select UTF8 encoding, that is, UTF8 in the second or third type.
15. set windows options (Please set the windows options ). The first option is whether to Install the Windows Service (Install As Windows Service). We recommend that you check that the following Service Name is the Name of the server ID, which is the default option, and whether to randomly start MySQL, if this option is not selected, you need to enter net start MySQL on cmd to enable mysql later. The second option is whether to add the bin folder Path to the PATH (Include Bin Directory in Windows Path) in the environment variable. we recommend that you select this option, in this way, you can directly enter any file in the bin folder on cmd.
16. Please set the security options ). The first option is to Modify the Security Settings. The two items in this option are the new root password and the password that you have entered (that is, enter it again ), create An Anonymous Account (Create An Anonymous Account) at the bottom. if this is not required by me, I will not select it. then click Next

BitsCN.com