Shulou(Shulou.com)05/31 Report--

This article is to share with you about mysql5.7 for windows binary installation and how to configure, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

1) download mysql5.7 binary software

Download address: https://dev.mysql.com/downloads/mysql/5.7.html#downloads

Download software: mysql-5.7.25-win64.zip

2) extract the software to the specified directory

D:\ mysql-5.7.25

3) configure environment variables and path

Environment variable name: MYSQL_HOME

Path add: path=%path%;%MYSQL_HOME%\ bin

4) Edit the my.ini parameter file (add the following variable) and save to% MYSQL_HOME%\ bin

[mysql]

Default-character-set=utf8

[mysqld]

Port=3306

Basedir=d:\ mysql-5.7.25

Datadir=d:\ mysql-5.7.25\ data

Max_connections=200

Character-set-server=utf8

Default-storage-engine=innodb

5) Open the command window and install mysql

D:\ > cd d:\ mysql-5.7.25\ bin

D:\ > mysqld install

Note: if you make an error about MSVCR120.dll and MSVCP120.dll, these two files are missing under c:\ windows\ system2. You need to copy the two files from other similar systems to the c:\ windows\ system2 directory, and then run mysqld install again to install them.

6) initialize the database

D:\ > cd d:\ mysql-5.7.25\ bin

D:\ > mkdir..\ data

D: > mysqld-initialize-user=mysql-console

Note: if you mistakenly report that the data directory is not empty, try the data directory situation again and write down the root password displayed on the screen.

7) start the connection to mysql and change the root password

D:\ > net start mysql

D:\ > mysql-u root-ppassword

Mysql > alter user root@'localhost' identified by 'new_password'

Mysql > flush privileges

Mysql > exit

The above is the mysql5.7 for windows binary installation and how to configure, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.