MySQL latest version 8.0.17 decompression version installation tutorial

MySQL latest version 8.0.17 decompression version installation tutorial

Personally, I think the decompressed version is easier to install than the installation version. Without further ado, let's take a look at the installation of the decompressed version~

First, go to the MySQL official website to download the latest MySQL 8.0.17 URL:

Download the unzipped directory:

By default, there is no data directory and my.ini file. Create the my.ini file in the directory above (some tutorials also require creating a data directory. I tried creating a data directory and mysql failed to start)


ini file:

[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:\Program Files\mysql-8.0.17-winx64
#Set the storage directory of mysql database data datadir=D:\Program Files\mysql-8.0.17-winx64\data
#Maximum number of connections allowed max_connections=50
#The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
#Change the default authentication in 8.0 default_authentication_plugin=mysql_native_password
#The default storage engine that will be used when creating a new table default-storage-engine=INNODB
wait_timeout=31536000
interactive_timeout=31536000

The data directory will be automatically generated

Configure MySQL environment variables (this step can be omitted if you open it directly in the MySQL bin directory)

The above picture shows the path environment variable

Start a command line as an administrator and enter:
mysqld --initialize --console Press Enter and a message will pop up. The random password generated after @localhost is important to remember! ! !
Next, enter mysqld --install [service name] (mysql in this example)
After completion, enter net start mysql to directly start the mysql service

Then open mysql in the command line:

You can change your password after logging in:

The latest unzipped version of MySQL has been installed.

Tip: Since it is version 8.0.1x, the jar used must also be correct (I used the 8.0.9 jar before and couldn't find the driver, so I changed to 8.0.17)

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.

You may also be interested in:
  • MySQL 8.0.12 decompression version installation tutorial personal test!
  • mysql8.0.0 winx64.zip decompression version installation and configuration tutorial
  • MySQL 8.0.12 decompression version installation tutorial
  • MySQL v5.7.18 decompression version installation detailed tutorial
  • Detailed graphic instructions for downloading and installing the unzipped version of MySQL 5.7.18 and starting the MySQL service
  • MySQL 8.0.13 decompression version installation and configuration method graphic tutorial
  • How to install and configure MySQL 8.0.12 decompressed version under Windows 10 with graphic tutorials
  • MySQL 8.0.15 winx64 decompression version installation and configuration method graphic tutorial
  • MySQL 8.0.12 winx64 decompression version installation graphic tutorial
  • MySQL 8.0 decompression version download installation and configuration example tutorial

<<:  Steps to install RocketMQ instance on Linux

>>:  Docker uses nextcloud to build a private Baidu cloud disk

Recommend

Detailed explanation of MySQL alter ignore syntax

When I was at work today, the business side asked...

CSS form validation function implementation code

Rendering principle In the form element, there is...

JavaScript code to implement a simple calculator

This article example shares the specific code of ...

MySQL Billions of Data Import, Export and Migration Notes

I have been taking a lot of MySQL notes recently,...

Several commonly used single-page application website sharing

CSS3Please Take a look at this website yourself, ...

Quickly get started with VUE 3 teleport components and usage syntax

Table of contents 1. Introduction to teleport 1.1...

JavaScript BOM Explained

Table of contents 1. BOM Introduction 1. JavaScri...

Public free STUN servers

Public free STUN servers When the SIP terminal us...

Introduction to HTML page source code layout_Powernode Java Academy

Introduction to HTML page source code layout This...

MySQL 5.7.20 Green Edition Installation Detailed Graphic Tutorial

First, let’s understand what MySQL is? MySQL is a...

How to set mysql to case insensitive

mysql set to case insensitive Windows Go to the d...

Introduction to Linux File Compression and Packaging

1. Introduction to compression and packaging Comm...

How to install MySQL 5.7.29 with one click using shell script

This article refers to the work of 51CTO blog aut...

How to use Axios asynchronous request API in Vue

Table of contents Setting up a basic HTTP request...