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

This article shares the installation and configuration method of mysql 8.0.15 winx64 for your reference. The details are as follows

1. Go to the official website to download the latest version of mysql-8.0.15 for the 64-bit operating system under window

Download address

After the download is completed, extract it to a custom directory. All my tools are saved in D:\ Project. After the decompression is completed, you will see the following directory:

D:\ Project\ mysql-8.0.15-winx64

2 configure environment variables (the purpose of configuring environment variables is to call and run directly without entering the corresponding folder directory under the cmd terminal command)

Then, configure the environment variable (my computer right-click, then click Properties, and then click the environment variable), the steps are as follows:

Method 1

My computer right-click to drop down the last point properties and click on the environment variable

Method 2.

Control panel-systems and security-systems

Select advanced system settings

Step three

1. Find [system variable]-[Path] and select it

two。 Click "Edit" below to pop up a box of variable name and variable value;'

3. Select [variable value] and add the bin file under the directory of the mysql file you downloaded: for example, the system value I added is: d:\ Project\ mysql-8.0.15-winx64\ bin

Note: it is appended after [variable value], not replaced directly. Remember.

At this point, the configuration of the environment variable is complete, and then:

The operation of installing mysql.

1. Create a new file my.ini in the D:\ Project\ mysql-8.0.15-winx65 directory

Just create a new txt file and rename it to my.ini.

two。 The contents of the document are as follows:

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\\ Project\ mysql-8.0.11-winx64# set the data storage directory of mysql database datadir=D:\\ Project\ mysql-8.0.11-winx64\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. 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 port=3306default-character-set=utf8 used by default when the mysql client connects to the server

At this point, open the cmd window as an administrator

Mysqld-install mysql8

Initialization of mysql:

Mysqld-initialize-console

A code will appear at this time, at this time to remember your initialization password, if the disabled turn off too quickly, you can delete the datadir (that is, my Data folder), and then initialize it again.

After that, the initial password appears: *

You can log in to the database with your initial password:

Mysql-u root-p *

Of course, some people may report an error at this time, with a pop-up box as follows:

Then start the mysql service and enter instructions in the CMD window:

Net start mysql8

The name of the service is entered later, which is written according to your own situation.

At this point, we can log in to mysql to have a look and enter the instructions:

Mysql-u root-p

Then it will ask you to enter your password, enter the initialization password at that time, and you can log in to mysql.

A pop-up message like this means that the login is successful. At this point, we can enter the password change instruction to change the password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' mysql'

BY is followed by your new password, I entered the mysql, easy to enter, you can configure the password according to personal habits.

Then enter it in the terminal:

Mysql-uroot-pmysql

Log in to something in the database and you can operate it.

The terminal command for a window remote connection is: mstsc.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.