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

How to regularly clean up docker private server images

Using CI to build docker images for release has g...

The reason why MySQL uses B+ tree as its underlying data structure

We all know that the underlying data structure of...

Two ways to remove the 30-second ad code from Youku video

I believe everyone has had this feeling: watching ...

Thoughts on truncation of multi-line text with a "show more" button

I just happened to encounter this small requireme...

Detailed explanation of Nginx static file service configuration and optimization

Root directory and index file The root directive ...

Solve the problem of ugly blue border after adding hyperlink to html image img

HTML img produces an ugly blue border after addin...

Vue-CLI multi-page directory packaging steps record

Page directory structure Note that you need to mo...

Implementing a simple calculator with javascript

This article example shares the specific code of ...

How to use CSS media query aspect-ratio less

CSS media query has a very convenient aspect rati...

How to expand the disk partition for centos system

Problem/failure/scenario/requirement The hard dis...

How to install MySQL for beginners (proven effective)

1. Software Download MySQL download and installat...

js basic syntax and maven project configuration tutorial case

Table of contents 1. js statement Second, js arra...