MySQL 8.0.15 winx64 installation and configuration method graphic tutorial under windows

MySQL 8.0.15 winx64 installation and configuration method graphic tutorial under windows

This article shares the installation and configuration method of MySQL 8.0.15 winx64 for your reference. The specific content is as follows

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

Download

After downloading, unzip it to a custom directory. All my tools are saved in D:\Project. After unzipping, 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 under the cmd terminal command without entering the corresponding folder directory)

Then, configure the environment variables (right-click My Computer, then click Properties, and then click Environment Variables), the steps are as follows:

Method 1

  • Right click on My Computer
  • Pull down and click on the last property
  • Finally click on Environment Variables

Method 2.

Control Panel---System and Security----System

Select Advanced system settings

Step 3

1. Find [System Variables]----[Path] and select it;
2. Click [Edit] below, and a box with variable name and variable value will pop up;'
3. Select [Variable Value] and add the bin file in the MySQL file directory 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 directly replaced. Remember.

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

2. Install 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.
2. The content of the file is as follows:

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:\\Project\mysql-8.0.11-winx64
# Set the storage directory of mysql database data datadir=D:\\Project\mysql-8.0.11-winx64\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8

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. You should remember your initialization password. If you close it too quickly, you can delete the datadir (that is, the Data folder here) and then initialize it again.

Then the initial password will appear: ******
You can log in to the database with the initial password:

mysql -u root -p
******

Of course, some people may get an error at this time, and the pop-up box is as follows:

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

net start mysql8

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

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

mysql -u root -p

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

If such a message pops up, the login is successful. At this time, we can enter the change password command to change the password:

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

The password after BY is your new password. I entered mysql for easy access. You can configure the password according to your personal habits.

Then enter in the terminal:

mysql -uroot -p
mysql

Log in to the database and you can operate it.
The terminal command for window remote connection is: mstsc .

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

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.15-winx64 uses the zip package to install and the service is shut down immediately after starting
  • mysql-8.0.15-winx64 decompression version installation tutorial and three ways to exit
  • MySQL 8.0.15 winx64 installation and configuration method graphic tutorial
  • MySQL 8.0.15 winx64 decompression version installation and configuration method graphic tutorial
  • MySQL 8.0.15 installation and configuration tutorial under Win10
  • MySQL 8.0.15 installation and configuration method graphic tutorial under Windows
  • MySQL 8.0.15 download and installation detailed tutorial is a must for novices!
  • MySQL 8.0.15 installation and configuration method graphic tutorial
  • MySQL 8.0.15 installation and configuration graphic tutorial
  • mysql 8.0.15 winx64 decompression version graphic installation tutorial

<<:  Implementation of Vue single file component

>>:  How to uninstall MySQL 8.0 version under Linux

Recommend

Do you know all 24 methods of JavaScript loop traversal?

Table of contents Preface 1. Array traversal meth...

Detailed explanation of how to use join to optimize SQL in MySQL

0. Prepare relevant tables for the following test...

Tomcat CentOS installation process diagram

Tomcat CentOS Installation This installation tuto...

MySQL database basic syntax and operation

MySQL database basic syntax DDL Operations Create...

Axios cancels repeated requests

Table of contents Preface 1. How to cancel a requ...

How to quickly modify the table structure of MySQL table

Quickly modify the table structure of a MySQL tab...

Using Docker+jenkins+python3 environment to build a super detailed tutorial

Preface: After the automation is written, it need...

Eight ways to implement communication in Vue

Table of contents 1. Component Communication 1. P...

How to implement Ajax concurrent request control based on JS

Table of contents Preface Ajax serial and paralle...

Vue implements tab navigation bar and supports left and right sliding function

This article mainly introduces: using Vue to impl...

How to encapsulate axios in Vue

Table of contents 1. Installation 1. Introduction...

Example code for implementing WeChat account splitting with Nodejs

The company's business scenario requires the ...