Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install the decompressed version of mysql8.0.17. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

First, go to the mysql website to download the latest mysql8.0.17 URL:

Download the extracted directory:

There are no data directories and my.ini files by default. Create a my.ini file in the above directory (some tutorials also need to create a data directory, I have tried to create a data directory mysql will not start)

Ini file:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\ Program Files\ mysql-8.0.17-winx64# set mysql database data storage directory datadir=D:\ Program Files\ mysql-8.0.17-winx64\ data# allowed maximum number of connections the character set used by the max_connections=50# server defaults to the 8-bit coded latin1 character set Character-set-server=utf8# changes 8.0 default authentication default_authentication_plugin=mysql_native_password# the default storage engine default-storage-engine=INNODBwait_timeout=31536000interactive_timeout=31536000 that will be used when creating new tables

The data directory is automatically generated

Configure the mysql environment variable (this step can be omitted if it is opened directly under the bin directory of mysql)

The picture above shows the path environment variable

Start the command line as an administrator: enter:

Mysqld-- initialize-- console enter

Then the message will pop up with the random password generated after @ localhost, be sure to remember it!

Next, enter mysqld-- install [service name] (in this case, mysql)

Enter net start mysql to open the myslq service directly after completion.

Then open mysql on the command line:

You can change your password after logging in:

The latest decompressed version of mysql has been installed.

Tip: because it is version 8.0.1x, the jar used should also be correct (the driver could not be found with the 8.0.9 jar before, and then changed to the 8.0.17)

This is the end of the article on "how to install the decompressed version of mysql8.0.17". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.