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.