WINDOWS10 installation MySQL detailed graphics tutorial

Install MySQL detailed graphics tutorial on WINDOWS10

This article mainly introduces the installation of MySQL detailed graphic tutorial on WINDOWS10, this article introduces very detailed, with reference value, interested friends to see it together

Environment: Windwos (1511) 64bit, MySQL 5.7.14

First, download MySQL

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

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

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

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

5. Select the first item "MySQL Installer"

6. At the bottom of the page find the download Portal "Windows (x86,
32-bit), MSI Installer ", click the Download button to start the download, total 381.4M

Note: The MSI format refers to the installation program of Windows, which can be accessed directly by double-clicking on the Installation Wizard, which is different from the installation method of extracting the files;

7. This page tells you whether you are logged in, tell you what the benefits of login, we do not log in, click on the bottom of the page "No thanks, just start my download." button to go to the download page

8. Start the download, wait for the download to complete (because the direct download speed is too slow, then I use the Thunder download completed)

9. Download complete

Second, install MySQL

1. Double-click the downloaded MySQL installation file "Mysql-installer-community-5.7.14.0.msi" to open the installation program, you need to wait a moment after opening

2. Select the type of installation (depending on your needs)

3. I only need to install MySQL server, so choose the last "Custom", choose custom after the left of the installation process and the right of the description text will change, and then click "Next" button to continue

4. Here we need to select the MySQL server we need from the installable product (products) provided by the installer

We expand the first "MySQL Servers" in available products, expand its sub-nodes in turn, until its terminal node, my operation is 64-bit, so check "MySQL Server 5.7.14-x64"

Then click the green right arrow, move the current product to the list that needs to be installed, then expand the MySQL Server 5.7.14-x64 item on the right and uncheck the "Development Components" checkbox (because we only need to install MySQL Server), then click on the "Next" button to enter the next step

5. Click "Execute" to start the installation, the installation process will show the installation of the Progress (progress), waiting for the installation after the status will show the Complete,mysql icon will appear before a green tick, and then click "Next" button to enter the product configuration interface

6. Click "Next" button to enter MySQL Server configuration

Config type Select "Development Machine", select this will use smaller content to run our MySQL server, corresponding to small software, learning is fully sufficient. After "Next"

In root account password set the password of the database root, I fill in 123456 so the program reminds me that the password strength is weak, we need to remember this password, and then click "Next"

Here can set the name of the MySQL server and whether to boot, I changed the name to "MySQLZzz1", canceled the boot, the other did not change, click "Next"

Click "Next"

This interface applies the configuration previously set to our MySQL server, click "Execute" and wait for it to complete.

Configuration complete, click "Finish" to complete the configuration link

7. After the configuration is completed, we will go back to the installer and click "Next" to continue

Prompt us to install complete, click "Finish"

8. After clicking "Finish" in the previous step, the computer is so calm that people don't know what to do next! Experience of installing software in the past this time the computer should automatically start the software that has just been installed. So I looked in the process and did not find a mysql-like process, so we went to the next step.

Third, configure the MySQL environment variable (not necessary)

Description: After configuring environment variables for MySQL, we can run MySQL in cmd (open, stop, etc.)

1. As is the case with the environment variable configuration, we open the Environment Variable configuration window (win+pause, change settings, and System Properties, select "Advanced"-environment variable)

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\mysql Server 5.7\bin, save exit

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

3. Test whether the configuration is successful: open cmd, enter "Mysql-u root-p" and enter the password for the root account set at MySQL installation (123456), if prompted "Welcome to the MySQL monitor." Description the configuration was successful.

Four, start MySQL

Yes, by now we haven't started our mysql!. So how do you start it?

(based on the condition of the configured environment variable)

1. Run cmd as administrator, enter "net start Mysqlzzz1" (MySQLZzz1 is the server name that is filled in when you configure MySQL server, CMD is not case-sensitive or can be used)

2. We can see the "Mysqld.exe" process in the Task Manager process after the launch is successful.

Report:

Prompt when executing a command: The service name is invalid. Please type NET helpmsg 2185 for more help.

Workaround: execute the mysqld-install command under the MySQL Bin directory with administrator privileges

A method for uninstalling the MySQL service is attached.

1. To Administrator's permissions net stop MySQL, turn off MySQL service

2, with the administrator's permission mysqld-remove, uninstall the MySQL service

Five, test whether the installation is successful

We use the MySQL management software (Navicat for MySQL) to test the connection and make sure that MySQL is ready for use:

1. Open Navicat for MySQL

2. Create a new connection and fill in the connection information:

Connection name: Used to distinguish between different connections, you can name it

Host name: localhost

Port: 3306

User name: Root

Password: 123456 (password to be filled in before MySQL is configured)

3. Click the "Connect Test" button to eject the Connection Success dialog box, which means that MySQL server is turned on

4. Then the use of navicat for MySQL software

Other:

We can also enter "net start Mysqlzzz1" again in cmd, if prompted "the requested service has been started." "indicates that MySQL server has started normally;

At this point, MySQL server is installed on Windows 10 64-bit.

Reproduced:

They call me Zhou Zhouzhou.

Address: http://www.jb51.net/article/92158.htm

Installation process reference: https://www.cnblogs.com/lingduqianli/p/8103792.html

WINDOWS10 installation MySQL detailed graphics tutorial