Detailed tutorial for installing the unzipped version of mysql5.7.28 winx64 on windows

Detailed tutorial for installing the unzipped version of mysql5.7.28 winx64 on windows

1. Unzip

Unzip it to D:\Mysql-5.7 and rename the file to mysql.

2. Create a data folder

Open the mysql folder and create a data folder

3. Add environment variables to mysql

3.1 Open the Control Panel and click 'System and Security'

3.2 After clicking 'System', click 'Advanced system settings'


3.3 Click on environment variables to enter the environment variable setting menu

Select "path" in the system variable, and enter the path value: D:\Mysql-5.7\mysql\bin Save and exit

4. Create a my.ini file in the mysql folder and paste the following content into it

[mysql]
#Set the default character set of MySQL client default-character-set=utf8 
[mysqld]
#Set port 3306 port = 3306
 #Set the installation directory of mysql basedir=D:\\Mysql-5.7\mysql
#Set the storage directory of mysql database data datadir=D:\\Mysql-5.7\mysql\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
# Enable query cache explicit_defaults_for_timestamp=true
skip-grant-tables

5. Open Command Prompt (cmd) (Run as Administrator)

mysqld --initialize
mysqld install 
net start mysql 

Execute the mysql -uroot -p command because we added skip-grant-tables in the my.ini file. Therefore, any value can be entered for the password.

Change password and refresh permissions.

mysql> use mysql; #Switch the database to the mysql database Database changed
mysql> update user set authentication_string=PASSWORD('123456') where user='root'; #Change password Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> flush privileges; #Refresh privileges Query OK, 0 rows affected (0.00 sec)

mysql> quit; # Exit the mysql command line

6. Delete the setting to skip password verification

image.png

Enable non-strict mode, otherwise some statements in version 5.6 will be incompatible. For example, if some fields group by but all fields are queried in the query, the SQL statement will report an error.

# Non-strict mode sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

7. Error problem collection

7.1 mysqld --initialize does not respond

I used powersehll to install it, but it didn't work. Then I used cmd window administrator mode, and it said that msvcp120.dll could not be found and msvcr120.dll was missing.

Solution:
Download Visual C++ Redistributable Packages for Visual Studio 2013 from Microsoft's official website

Reference: https://www.okcode.net/article/74194

This is the end of this article about the detailed tutorial on how to install the unzipped version of mysql5.7.28 winx64 on windows. For more relevant content about installing mysql5.7.28 on windows, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • How to install MySQL 8.0.28.0.msi on Windows (with pictures and text)
  • MySQL 8.0.25 installation and configuration tutorial under Windows 64 bit (most detailed!)
  • Detailed explanation of the problem of installing MYSQL5.7.24 under Windows Server 2012
  • Detailed installation process and basic usage of MySQL under Windows
  • Detailed introduction to the MySQL installation tutorial under Windows
  • The latest version of MySQL 8.0.22 download and installation super detailed tutorial (Windows 64 bit)
  • MySQL 8.0.22 installation and configuration method graphic tutorial under Windows 10
  • MySQL 8.0.19 installation detailed tutorial (windows 64 bit)
  • MySQL 8.0.21 installation tutorial under Windows system (illustration and text)
  • MySQL 8.0.20 Installation Tutorial with Pictures and Text (Windows 64-bit)
  • MySQL 8.0.19 winx64 installation tutorial and change the initial password under Windows 10
  • Tutorial on installing MySQL 8.0.x on Windows

<<:  Markup Language - Phrase Elements

>>:  How to change the domestic image source for Docker

Recommend

Markup language - CSS layout

Click here to return to the 123WORDPRESS.COM HTML ...

Take you to understand MySQL character set settings in 5 minutes

Table of contents 1. Content Overview 2. Concepts...

How to set mysql permissions using phpmyadmin

Table of contents Step 1: Log in as root user. St...

JavaScript canvas implements moving the ball following the mouse

This article example shares the specific code of ...

How to wrap HTML title attribute

When I was writing a program a few days ago, I wan...

Things You Don’t Know About the CSS ::before and ::after Pseudo-Elements

CSS has two pseudo-classes that are not commonly ...

Detailed explanation of 5 solutions for CSS intermediate adaptive layout

Preface When making a page, we often encounter co...

Use html-webpack-plugin' to generate HTML page plugin in memory

When we package the webpackjs file, we introduce ...

Web lesson plans, lesson plans for beginners

Teaching Topics Web page Applicable grade Second ...

JavaScript+html to implement front-end page sliding verification

This article shares the specific code of JavaScri...

Vue realizes screen adaptation of large screen pages

This article shares the specific code of Vue to a...

Analysis of Linux boot system methods

This article describes how to boot the Linux syst...

Why is it not recommended to use an empty string as a className in Vue?

Table of contents Compare the empty string '&...