mysql-8.0.15-winx64 decompression version installation tutorial and three ways to exit

mysql-8.0.15-winx64 decompression version installation tutorial and three ways to exit

1. Download from the official website and unzip

https://dev.mysql.com/downloads/mysql/

2. Set environment variables

Configure MYSQL_HOME to the MySQL decompression path and set %MYSQL_HOME%\bin in path

Environment variables

3. In the MySQL decompression path, create a new my.ini file to configure the initialization parameters:

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
#Set port 3306 port = 3306 
# Set the installation directory of mysql to basedir=D:\Java\mysql-8.0.15-winx64
# Set the storage directory of mysql database data datadir=D:\Java\mysql-8.0.15-winx64\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

4. Initialize the database

Open the cmd command window as an administrator and enter the mysqld --initialize command to initialize the mysql data directory. After initialization, a data folder will be generated in the decompressed directory. In this folder, there is a file ending with .err. When opened, a randomly generated password will appear.

5. Installation service

# Register service mysqld --install
# Start the service net start mysql 

mysql installation

6. Change your password

ALTER USER USER() IDENTIFIED BY 'new password';

Login successfully with new password, done!

Problems encountered during installation

1. The service name is invalid

Invalid service name

Cause of the problem: MySQL is not registered in the system, that is, there is no MySQL service in the current path.

Solution: Enter mysqld --install in the command line. If Service successfully install appears, it means the installation is successful.

2. Can log in in cmd, but not in Navicat

Tip: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Cause of the problem: The encryption rule in versions before mysql8 is mysql_native_password, and after mysql8, the encryption rule is caching_sha2_password.

Solution: Restore the MySQL user login password encryption rule to mysql_native_password, or upgrade the Navicat driver

insert image description here

#Update the user's password rule ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; 
#Flush permissions FLUSH PRIVILEGES;

【Attached with small tips】

Quickly enter the administrator cmd

cmd

Add three ways to exit MySQL:

mysql > exit;
mysql > quit;
mysql> \q;

Summarize

The above is the detailed graphic installation tutorial of the mysql-8.0.15-winx64 decompression version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time!

You may also be interested in:
  • Python uses Flask to operate MySQL to realize login function
  • Install MySQL database 5.6 source code under Linux and change the login user password
  • MySQL login operation example based on DOS command line (illustration)
  • How to log in to MYSQL through DOS command under Windows
  • About MYSQL remote login authorization method command
  • MySQL login and exit command format

<<:  Implementation of Vue large file upload and breakpoint resumable upload

>>:  Create a virtual machine and install the Redhat Linux operating system on VMware (graphic tutorial)

Recommend

Vue uses better-scroll to achieve horizontal scrolling method example

1. Implementation principle of scrolling The scro...

Detailed process of installing the docker plugin in IntelliJ IDEA (2018 version)

Table of contents 1. Development Environment 2. I...

Detailed explanation of CocosCreator optimization DrawCall

Table of contents Preface What is DrawCall How do...

Basic concepts and common methods of Map mapping in ECMAScript6

Table of contents What is a Mapping Difference be...

Summary of MySQL 8.0 Online DDL Quick Column Addition

Table of contents Problem Description Historical ...

How to set mysql permissions using phpmyadmin

Table of contents Step 1: Log in as root user. St...

Use of Linux file command

1. Command Introduction The file command is used ...

Solve the problem when setting the date to 0000-00-00 00:00:00 in MySQL 8.0.13

I just started learning database operations. Toda...

Summary of things to pay attention to in the footer of a web page

Lots of links You’ve no doubt seen a lot of sites ...

HTML+CSS+JS sample code to imitate the brightness adjustment effect of win10

HTML+CSS+JS imitates win10 brightness adjustment ...

Three Ways to Find the Longest Word in a String in JavaScript (Recommended)

This article is based on the Free Code Camp Basic...

CSS sets the box container (div) height to always be 100%

Preface Sometimes you need to keep the height of ...

npm Taobao mirror modification explanation

1. Top-level usage 1. Install cnpm npm i -g cnpm ...

JavaScript canvas realizes dynamic point and line effect

This article shares the specific code for JavaScr...