MySQL 8.0.15 installation and configuration graphic tutorial under Win10

MySQL 8.0.15 installation and configuration graphic tutorial under Win10

This article records the installation and configuration methods of MySQL 8.0.15 for your reference. The specific contents are as follows

1. Download

1. Go to the MySQL official website and download the installer
2. If you are connected to the Internet during installation, select the first download, otherwise select the second download. Here I chose the second one

3. If you have Oracle, click Login, otherwise click Sign Up to register and log in. Here I choose Login
4. Fill in some information and click Download Now, then wait for the download to complete.

2. Installation

1. Open the downloaded file

2. Check I accept the license terms and click Next


3. Select Developer Default for default installation, select Sever only for server only, select Full for complete installation, and select Custom for custom installation.
Here I choose custom installation and click next


4. Select the components you want to install and click Next, as shown in the figure. You can choose according to your needs.


5. Click Execute and wait for a while


6. Click next until you need to enter a password


7. Set the server password. Note that this password will be used all the time in the future, so you need to remember it. Click next after completion.


8. Please remember the Windows services Name, the default is MySQL80, you can change it yourself, then click next

Forgot to take a screenshot (escape

9. Click Execute


10. Click Finish when finished


11. Click next


12. Enter the password you just set. The default user name is root.


13. Click check and then click next


14. Click Execute


15. Click Finish


16. Click next


17. Click Finish to complete the installation. You can copy the log


3. Configure the environment

1. Right-click "This Computer" on the desktop and select "Properties", click "Advanced System Properties" on the left, select the "Advanced" tab, and click "Environment Variables"


2. Select path in the system variables list, click Edit, then New, enter C:\Program Files\MySQL\MySQL Server 8.0\bin , click OK to complete the configuration of the environment variables


4. Log in to MySQL database

Run MySQL 8.0 Command Line Client (should be available in the Start menu)

After entering the password, you can start operating the database.

5. Tips

In the command line interface, the shortcut keys for copying and pasting are no longer Ctrl+C, Ctrl+V .

Copy: Select the content in the command line and press Enter to complete the copy.

Paste: Right-click in the command line to complete the paste.

6. Acknowledgements

Installation, configuration, service startup, login, and environment variable configuration of MySQL 8.0

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.23 installation and configuration method graphic tutorial under win10
  • MySQL 8.0.18 installation and configuration method graphic tutorial under win10 (windows version)
  • Win10 64-bit MySQL8.0 download and installation tutorial diagram
  • Installation and configuration tutorial of MySQL 8.0.16 under Win10
  • MySQL 8.0.12 installation and environment variable configuration tutorial under win10
  • How to install mysql8.0.23 under win10 and solve the problem of "the service does not respond to the control function"

<<:  Issues with upgrading Python and installing Mongodb drivers under Centos

>>:  How to deploy LNMP & phpMyAdmin in docker

Recommend

Web front-end development CSS related team collaboration

The front-end development department is growing, ...

DHTML objects (common properties of various HTML objects)

!DOCTYPE Specifies the Document Type Definition (...

Case analysis of several MySQL update operations

Table of contents Case Study Update account balan...

Several ways of running in the background of Linux (summary)

1. nohup Run the program in a way that ignores th...

Let's talk about the performance of MySQL's COUNT(*)

Preface Basically, programmers in the workplace u...

Detailed analysis of several situations in which MySQL indexes fail

1. Leading fuzzy query cannot use index (like ...

Detailed explanation of HTML basics (Part 1)

1. Understand the WEB Web pages are mainly compos...

Mysql multi-condition query statement with And keyword

MySQL multi-condition query with AND keyword. In ...

Implementation of Nginx domain name forwarding https access

A word in advance: Suddenly I received a task to ...

HTML Basics_General Tags, Common Tags and Tables

Part 1 HTML <html> -- start tag <head>...

JavaScript implements the nine-grid click color change effect

This article shares the specific code of JavaScri...

Tutorial on Migrating Projects from MYSQL to MARIADB

Prepare the database (MySQL). If you already have...

How to install and configure GitLab on Ubuntu 20.04

introduce GitLab CE or Community Edition is an op...

SQL implementation of LeetCode (177. Nth highest salary)

[LeetCode] 177.Nth Highest Salary Write a SQL que...