Detailed graphic tutorial on installing mysql on Windows 10, windows10mysql

Detailed graphic tutorial on installing mysql on Windows 10, windows10mysql

Environment: windwos 10 (1511) 64bit, mysql 5.7.14

1. Download mysql

1. Open the mysql official website http://www.mysql.com in the browser/

2. Go to "Downloads" at the top of the page"

3. Open "Community (GPL) Downloads" at the bottom of the page"

4. Find the "MySQL on windows (Installer & Tools)" on the download page in the middle of the page )"

5. Select the first "MySQL Installer"

6. Find the download entry "Windows (x86,
32-bit), MSI Installer ", click the Download button to start downloading, a total of 381.4 MB

Note: The MSI Format refers to the installation program for windows. After downloading it, you can double-click it to enter the Installation Wizard. It is different from the installation method for extracting files;

7. This page will tell you whether to log on and what are the benefits after logon. We will not log on. Click "No thanks, just start my download." at the bottom of the page to go To the download page.

8. Start the download and wait for the download to complete (because the direct download speed is too slow, I will use thunder to download it later)

9. Download complete

Ii. Install mysql

1. Double-click the downloaded mysql Installation File "mysql-installer-community-5.7.14.0.msi" to open the installer, open the need to wait a moment

2. Select the installation type (based on personal needs)

3. I only need to install mysql server, so select "Custom" in the last item. After selecting Custom, the installation process on the left and the description on the right will change, and then click "Next" to continue.

4. here we need to select the mysql server we need from the installable product (Products) provided by the installation program

Expand the first "MySQL Servers" in Available Products and expand its subnodes in turn until the terminal node. My operation is 64-bit, so select "MySQL Server 5.7.14-X64"

Click the green arrow to the right to move the list of products to be installed, and then expand the "MySQL Server 5.7.14-X64" item on the right, deselect the check box for "Development Components" (because we only need to install mysql server), and then click "Next" to go to the Next step.

5. click Execute to start the installation. The installation Progress is displayed during the installation process. After the installation is Complete, the Status displays Complete, A green check box is displayed in front of the mysql icon, and then click "Next" to go to the product configuration page.

6. Click "Next" to configure MySQL Server.

Select "Development Machine" for Config Type. Selecting this option will use a small amount of content to run our mysql server. It is sufficient for small software and learning. Next"

Set the Password of the Database Root Account in the root Account Password. I entered 123456, so the program reminds me that the Password strength is weak. We need to remember this Password, and then click "Next"

Here, you can set the mysql server name and whether to start the mysql server at startup. I changed the name to "MySQLZzz1" and disabled the startup. If the other information is not changed, click "Next"

Click "Next"

This interface applies the previously configured configuration content to our mysql server and click "Execute". Wait until the configuration is complete.

The configuration is complete. Click "Finish" to complete the configuration.

7. After the configuration is complete, the system will return to the installation program. Click "Next" to continue.

Prompt that the installation is complete. Click "Finish"

8. After clicking "Finish" in the previous step, the computer is so calm that people do not know what to do next! Based on previous software installation experience, the computer should automatically start the software just installed. So I looked for it in the process and did not find any process similar to mysql, so let's proceed to the next step.

3. Configure mysql environment variables (optional)

Note: After configuring environment variables for mysql, we can run mysql in cmd (enabling, stopping, and other operations)

1. As with the actual environment variable configuration method, open the environment variable configuration window (combination key win + Pause-> change settings-> select "advanced"-> environment variable in system properties)

2. select "path" in the system variable, enter the path of the bin folder under the mysql installation directory at the beginning of the path value: C: \ Program Files \ MySQL Server 5.7 \ bin, save and exit

Note: The default installation path for mysql server is: C: \ Program Files \ MySQL Server 5.7

3. test whether the configuration is successful: Open cmd, enter "mysql-u root-p" and press Enter. Then, enter the password of the root account (123456) set during mysql installation ), if "Welcome to the MySQL monitor" is displayed. "indicates that the configuration is successful.

4. Start mysql

Yes, we haven't started our mysql yet! So how to start it?

(Based on environment variables configured)

1. Run cmd as an administrator and enter "net start mysqlzzz1" (MySQLZzz1 is the name of the server entered When configuring the mysql server. It can also be used in cmd without case sensitivity)

2. After the startup is successful, we can see the process of running mysqld.exe in the task manager.

Appendix:

If the prompt is displayed: the service name is invalid. Type net helpmsg 2185 for more help.

Solution:Execute the mysqld-install command as administrator in the mysql bin directory.

Attached is the method for uninstalling the mysql service.

1. Use the Administrator's permission to stop mysql and disable the mysql service.

2. Uninstall the mysql service with the Administrator permission mysqld-remove

5. test whether the installation is successful

We use the MySQL management software (Navicat for MySQL) for connection testing to ensure that mysql can use:

1. Open Navicat for MySQL

2. Create a connection and enter the connection information:

Connection name: used to differentiate different connections. Just name the connection by yourself.

Host Name: localhost

Port 3306

Username: root

Password: 123456 (the password entered before mysql configuration)

3. Click "connection test". The connection success dialog box is displayed, indicating that mysql server is enabled.

4. The Navicat for MySQL software is used later.

In addition:

You can also enter "net start mysqlzzz1" again in cmd. If the system prompts "the requested service has been started ." Indicates that the mysql server is started normally;

So far, mysql server has been installed on windows 10 64-bit.