Shulou(Shulou.com)06/01 Report--

Today, the editor will share with you the relevant knowledge points about how to install the MySQL8.0.x version of Windows. The content is detailed and the logic is clear. I believe most people still know too much about this, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.

First, download

Download link on MySQL official website: https://downloads.mysql.com/archives/community/

Download the zip file after selecting the version

The blogger chose 8.0.13.

Second, install 1 decompression

Unzip the downloaded zip package directly under the path you want.

After the decompression is completed, you will get this interface:

2 configure environment variables right-click this computer to select properties

Double-click the Path of the system environment variable

Create a new path that you just unzipped (pay attention to the path under bin)

3 configure my.ini

Create a new my.ini file under the D:\ Program Files (x86)\ mysql-8.0.13-winx64\ mysql-8.0.13-winx64 path.

Here is a note: if there is a mysql8.0 installation error error: Found option without preceding group in config file:

Then save the ini file as ANSI encoding

The contents of the document are as follows:

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\\ Program Files (x86)\\ mysql-8.0.13-winx64\\ mysql-8.0.13-winx64# be sure to use double slash here, single slash will make an error here. # set the directory where the data of the mysql database is stored datadir=D:\ Program Files (x86)\ mysql-8.0.13-winx64\\ Data# here is the same as above # the maximum number of connections allowed the number of connection failures allowed by max_connections=200#. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port used by default when the mysql client connects to the server port=3306default-character-set=utf84 command line starts mysqlWIN+R enter cmd to enter the window command line

Cd goes to the bin directory where mysql is installed

Input: mysqld-- initialize-- console

Waiting for a while will output a bunch of things. It is recommended that you copy the output and put it in a notepad because it will contain the initial database password you need.

Usually after root@localhost: (it's a bunch of things like garbled code, this is the initial random password, and we'll change it later! )

After writing down the password, execute the command: mysqld-- install install mysql

Successfully is normally output

Then execute the command: net start mysql starts the mysql service

5 change the login password

Command: mysql-u root-p and then copy the initial password you just saved in the txt file into mysql

Command: alter user root@localhost identified by '123456; this 123456 can be customized and modified by me casually. If it is above mysql8, it is recommended not to use a pure numeric password, do not ask me why, it is a lesson from being cheated out!

Note: if you forget the initial random password, you can re-execute the command mysqld-- initialize-- console, but only if you delete the previously generated Data folder.

These are all the contents of the article "how to install the MySQL8.0.x version of Windows". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.

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.