Simple notes for installing mysql 5.7.17 in windows 10, mysql5.7.17

Simple notes for installing mysql 5.7.17 in windows 10, mysql5.7.17

I have been using MySQL in Linux for a long time, and the installation is also very simple. Today, I tried to install MySQL in windows and found that it is really a pitfall.

Now, let's record the installation process.

1. First, we have to go to the mysql official website to download the resources we need and select Downloads-> Community. Then we can see the MySQL Community Server.

Download the installation package of mysql-5.7.10-winx64.zip.

Decompress path: G: \ mysql \ mysql-5.7

2. In this path, create my. ini

[Mysql]

; Set the default Character Set of the mysql client

Default-character-set = utf8

[Mysqld]

; Set port 3306

Port = 3306

; Set the installation directory of mysql

Basedir = G: \ mysql \ mysql-5.7.

Set the directory for storing mysql database data

Datadir = G: \ mysql \ mysql-5.7 \ data

Tmpdir = G: \ mysql \ mysql-5.7 \ data // here is the key, the online tutorial missed this step

; Maximum number of connections allowed

Max_connections = 200

The default character set used by the server is the 8-bit latin1 character set.

Character-set-server = utf8

The default storage engine used to create a new table

Default-storage-engine = INNODB

3. Open the cmd window as an administrator and switch the directory to the bin directory of the decompressed file. Enter mysqld install and press enter to run the command. Note that mysqld is not mysql.

4. Next we use mysqld -- initialize to initialize the data DIRECTORY first. Otherwise, the data folder will not appear under the folder of mysql5.7, and another mysql folder will appear under the data folder.

5. Enter net start mysql to start the service. Or if it is not too troublesome, start it manually. Open the service and start the mysql service. The installation of mysql is complete.

To sum up, the red part of my. ini and step 4th are the key. If you miss this part, mysql cannot be started.

The above is a simple note for installing mysql 5.7.17 on windows 10. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!