Shulou(Shulou.com)06/01 Report--

This article is an example to share the specific methods of installing mysql zip files for your reference, the specific contents are as follows

1. download

Download address of mysql zip file

two。 Decompression, configuring environment variables

MYSQL_HOME:D:\ mysql

Add:% MYSQL_HOME%\ bin after path

3. Add files my.ini files, data folder

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ mysql5.7# set mysql database data storage directory datadir=D:\ mysql5.7\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit coded latin1 character set character-set-server=utf8# to create a new table The default storage engine default-storage-engine=INNODB that will be used when the

4. Go to the bin folder of the installation directory and run CMD as an administrator, such as D:mysql\ bin, then initialize the database and remember the assigned password

Mysqld-initialize-user=mysql-console

5. Installation startup

Mysqld-install mysqlnet start mysql

Note: if the system is missing msvcp120.dll files during startup, please download C++ 2013 library

Address: C++ 2013 library

6. Modify the password

SET PASSWORD = PASSWORD ('your password')

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.