mysql zip file installation tutorial

This article shares the specific method of installing the MySQL zip file for your reference. The specific content is as follows

1. Download

mysql zip file download address

2. Unzip and configure environment variables

MYSQL_HOME:D:\mysql
Add %MYSQL_HOME%\bin after path

3. Add the my.ini file and data folder

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
#Set port 3306 port = 3306
# Set the installation directory of mysql to basedir=D:\mysql5.7
# Set the storage directory of mysql database data datadir=D:\mysql5.7\data
# 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 that will be used when creating a new table default-storage-engine=INNODB

4. Enter 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 and startup

mysqld --install mysql

net start mysql

Note: If the system is missing the msvcp120.dll file when starting, please download the C++ 2013 library

Address: C++ 2013 Library

6. Change password

SET PASSWORD = PASSWORD('your password');

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.