MySQL 5.7 version of Windows installation

WIN10 system MySQL download and installation of the detailed tutorial, recorded as follows

The first two days under the Ubuntu installed MySQL encountered some dependencies, the results resolved a half-day, did not solve the good, but also put my system bad, small white destructive power.

To now my Ubuntu also did not install, computer-driven problems, Lenovo small new 3,101 installed Ubuntu, in on the card, originally disabled the original graphics card driver, but the second installation system, the middle of another trick, the result is installed on the system, disable the graphics card driver is also not. Can only install win10 use, Behold win10 under the installation of MySQL and there is a problem, really cue unravelling. Solved for a long time, so write a blog record it.

This blog is also for the WIN10 system to install the MySQL process, I installed the 5.7.19 version of MySQL.

The first step: download MySQL

: Https://dev.mysql.com/downloads/mysql/5.1.html#downloads

Your computer 64-bit download 64-bit, if your own computer 32-bit download 32.

My Computer system is 64-bit, so choose Download: Windows (x86,64-bit) ZIP archive version.

The process is as follows:

1. Select the type to download, 64-bit or 32-bit:

Click on the download will be to the download interface, then the most conspicuous is sign up, some people will feel the need to register an account to download, click on the red in the picture, directly free registration download. When you download the JDK and other things, you can also download the free registration.

OK wait for the download to complete.

2. Unzip and install the Mysql5.7.19

(1) Extract the downloaded package to the specified path, you can specify the path, I directly extracted to the D disk, extracted to the D:\mysql5.7.19-winx64 directory. The full path to the MySQL package is:

D:\mysql-5.7.19-winx64.

(2) Configure environment variables:

New system Environment variables:

Key Name: Mysql_home

Value is: D:\mysql-5.7.19-winx64

Then add the path:%mysql_home%\bin

(Note: If you are a small white that has not been configured environment variables, again special reminder, do not delete anything, just the original back with a semicolon, and then add the environment variable you want to configure it can be)

The process is as follows: Click on this computer, right click on properties. Then select the Advanced system settings:

Then go to the following interface: Click on the environment variable,:

Next add the system environment variable, click on the bottom of the new button, pop up a box to create a new environment variable, fill in the name of the environment variable, and then fill in the path of the environment variable, you can also browse the directory directly selected.

：

Finally, add the new environment variable value to the environment variable: Click on the path above the interface and click Edit. Then click Edit, add Add, and finally click OK to finish.

3. After completing the above, prepare the My.ini file

Before I installed the previous version, and then unzip, the directory will have a My-default.ini or My.ini file, but after 5.7.18, after decompression, do not take this file, then we will manually create a good My.ini file, and then placed in the specified directory.

(1) Create a new text document (that is, open Notepad), and then change the name to My-default or my two names. Paste the contents below into Notepad.

[Client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8basedir=%mysql_home% Datadir=%mysql_home%\data[winmysqladmin]%mysql_home%\bin\mysqld.exe

(2) After the completion of the above operation, we put in Notepad, followed by the prefix or. txt, this time we need to modify the file suffix name, the prefix name changed to. ini

(3) After establishing the My.ini file, copy and paste it to D:\mysql-5.7.19-winx64\bin, and put it in the bin directory where MySQL resides.

4. Open a command prompt with administrator, click Start under Win10 system, then enter CMD, right-click cmd, select Run as Administrator

5. Switch directories to the bin directory where the MySQL package resides. then enter Mysqld.exe-install

After executing the command, prompt: Service successfully installed. Indicates that the installation was successful.

But I encountered the following problem in the execution of this step: if you encounter this problem, do not panic, there is a solution, if you do not encounter problems, you can skip here:

The reason why I installed MySQL so long in the morning is because of this problem, and then some of the online garbage solutions misled me, so I have not felt this problem, God tired.

Online search for the first solution is to download a MSVCR120.dll and then, placed in the C-disk Windows,system32 directory, then I still solve the problem, my classmate is Win7 system, she did feel the problem, I am win10 can not be solved, Also tried other think method, or not, card for a long time.

The following answer is still desirable:

Hehe, VC + + has been updated to the 2015 version, the version number of the MSVCP class file to 140, and most of the solution is still in use do not know which era began the ancestral copy goods, but also the 95 is me, special now still someone with Windows 95 system? Dare not copy paste before you try it? Dare not modify the ancestral 10 years of the answer plus Windows8.1, Windows10?
It is strongly recommended to boycott any DLL that will only download this file to the system disk and then open cmd with the REGSVR command to register the stupid way, which is completely luck.
Some people tried the above method may feel useful, think I alarmist. That's just your luck, the blind cat hit the dead rat. If the 64-bit system according to his argument to put the DLL file into the SysWow64, and you want to open the software or game is a 32-bit program, you see whether it is useful. Even if the version corresponds, you download the DLL is not necessarily effective, because you do not install VC + + runtime, some software is necessary to complete the installation of VC + + runtime to run.

Other:

MSVCP, MSVCR, Vcomp140.dll belong to vc++2015 edition
MSVCP, MSVCR, Vcomp120.dll belong to vc++2013 edition
MSVCP, MSVCR, Vcomp110.dll belong to vc++2012 edition
MSVCP, MSVCR, Vcomp100.dll belong to vc++2010 edition
MSVCP, MSVCR, Vcomp90.dll belong to vc++2008 edition
MSVCP, MSVCR60, 71 and 80.dll, and Vcomp.dll (without the digital version number) belong to the vc++2005 edition

In addition to missing and missing such errors, if a program opens and prompts for "Parallel configuration Error", it is also because the VC + + runtime is not installed.

This situation, and you do not know which version should be installed, each try to feel too much trouble, suggest Baidu search DirectX Repair V3.5 enhanced version, this tool will be in the detection and repair DirectX at the same time install all versions of VC + + runtime, can also solve the loss of MSVCP and other problems. Note, must be enhanced version, the standard version, the online version does not have VC + +.

Because what I lack is msvcr120.dll, so I downloaded the Visual C + + redistributable Packages for Visual Studio 2013, this thing is a few megabytes, very small, downloaded after the installation is ready.

: https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=40784

After the installation is successful, follow the steps above and switch to the bin directory where the MySQL package is located, then enter Mysqld-install and return.

You can see the service successfully installed. Hint (at that time I was in the mood that excited ah, finally the problem solved, feel the solution of the previous attempt to pit Daddy AH).

6. Initialize the MySQL data and create a root user with a blank password, and open cmd to execute the following command:

Mysqld--initialize-insecure--user=mysql

Note: The last parameter--user=mysql may not be added in Windows, but it seems to be important under UNIX and other systems.
After the command is executed, after a while, the system automatically generates the corresponding data directory and automatically creates the root user for the empty password. This indicates that the initialization was successful.

7. In cmd, also called command prompt, enter the following command to start the MySQL service.

net start MySQL
After execution, prompt:
The MySQL service is starting:
The MySQL service has started successfully.
Note: To log in using MySQL, the service is required to be started first. It's the same later.

8. After the service starts, because the root user you just created is a blank password, you need to set the password first. execute the following command:

Mysqladmin-u root-p Password Enter a new password here
Enter Password: Enter the old password here

After executing the above two commands, as long as enter password: After entering the old password is correct, the root user's new password even if the setting is successful. Thereafter, to log in to the root user, you will need to use the new password.
Note: The root user that you just created is a blank password, so when you first modify the root user's password, enter password: After entering no password, you can return directly.

9. At this point, the decompression installation of MySQL v5.7.18 has been completed , so you need to stop the previously started MySQL service, execute the following command:
net stop MySQL

Log in and use MySQL

The previous installation of MySQL database, as long as the installation is successful, you can log in to the root user, and data related operations, such as: Build table, add, delete, change, check and so on. The following is a simple process:

1. Open cmd as Administrator and cut to the bin directory of the MySQL installation directory

2.net start MySQL//Description: The command is to start the MySQL service
Mysql-u root-p//Description: This command is logged in to the root user
Enter Password: The password of the root user that was previously set

3. After the correct login, the data can be manipulated such as: increase, delete, change, check and so on. Example:
mysql> show databases; Show all databases
Mysql> the SELECT statement .....
...

4. When the database is no longer used, to exit the user and stop the service, execute the following command:mysql> quit;

5.net stop MySQL

Deleting a database

If you no longer want to use MySQL, you can execute the following command: Mysqld--remove

Don't want to use the above command to control, we have other ways to use MySQL.

We can open it by downloading and installing Navicat.

I do not have, I am direct Baidu Navicat, then we can also self-Baidu, but will be bound to many rogue software, which requires you to download, installation of caution some, before I particularly like the idiot-style installation, a load down on a key installation, so many rogue software will be installed, So download down, the installation is a step-by-step, you can see the installation interface has a lot of rogue software in front of the hook, we click on those to remove the hook, do not jump step, each step in the middle are almost bound to have rogue software, we step by step, step by step to remove those on the hook can be.

Then we went to find the extracted files folder, inside there is a navicat icon, executable exe file, directly create desktop shortcuts.

Then open it on the desktop, and then create the connection and database on it to use.

、

Create a connection, enter the root password, and set the password yourself.

Then you can use: Click on the connection you created, right click, and then choose Open Connection, you can right-click, there will be a database created, you can create a database, now everything is finished, good use it.

Special topic Sharing: MySQL different version installation tutorial mysql5.7 version installation tutorial mysql5.6 installation Tutorials

The above is the whole content of this article, I hope that everyone's learning has helped, but also hope that we support the script home.

MySQL 5.7 version of Windows installation