MySQL 8.0.18 installation and configuration method graphic tutorial

MySQL 8.0.18 installation and configuration method graphic tutorial

This article records the installation and configuration graphic tutorial of MySQL 8.0.18 for your reference. The specific contents are as follows

Step 1: Download MySQL

Download address: MySQL

Step 2: Install MySQL

Open the downloaded file and unzip it to the specified directory.
(My unzip directory is G:\MySQL\mysql-8.0.18-winx64)

Open the unzipped MySql file and create my.ini (mysql configuration file) in the root directory

The contents of the my.ini file are as follows:

[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=G:\MySQL\mysql-8.0.18-winx64 
# Set the storage directory of mysql database data datadir=G:\MySQL\mysql-8.0.18-winx64
# 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

Here you need to change the basedir and datadir paths to the mysql decompression path

Find the CMD command prompt, right click and run it as administrator

Enter the mysql subdirectory bin and enter

mysqld --install (Installation)
mysqld --initialize (Initialization)
net start mysql (run)

Step 3: Set the MySql login password

After mysql is installed, open the data folder in the mysql installation directory. There is a .err file in it. Open it with Notepad++ and you can see the line

A temporary password is generated for root@localhost: xxxxxxxx

localhost: The following is the default password, copy this password to log in

After a successful login, you must reset your password, otherwise the following error will be displayed.

You must reset your password using ALTER USER statement before executing this statement.

After starting mysql, enter the following command, NEW PASSWORD is the password you set for yourself

mysql> ALTER USER USER() IDENTIFIED BY 'NEW PASSWORD';

The installation is complete.

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:
  • Windows free installation MySQL 8.0.28 version graphic tutorial
  • mysql 8.0.28 winx64.zip installation and configuration method graphic tutorial
  • MySQL 8.0.28 installation and configuration tutorial under Windows
  • MySQL 8.0.28 installation and configuration method graphic tutorial
  • How to install MySQL 8.0.28.0.msi on Windows (with pictures and text)
  • Install MySQL 8.0.28 on Kylin V10 and implement remote access
  • MySQL 8.0.22 installation and configuration method graphic tutorial
  • MySQL 8.0.22 installation and configuration graphic tutorial
  • MySQL 8.0.22 download, installation and configuration method graphic tutorial
  • Ubuntu MySQL 8.0.28 installation and configuration method graphic tutorial

<<:  Difference and principle analysis of Nginx forward and reverse proxy

>>:  Summary of Operator Operations That Are Very Error-Prone in JavaScript

Recommend

A brief analysis of the four import methods and priorities in CSS

First: 4 ways to introduce CSS There are four way...

Design theory: people-oriented design concept

<br />When thoughts were divided into East a...

A brief introduction to the simple use of CentOS7 firewall and open ports

Overview (official has more detailed description)...

Advantages and Problems of XHTML CSS Website Design

XHTML is the standard website design language cur...

CSS3 transition to implement notification message carousel

Vue version, copy it to the file and use it <t...

Promise encapsulation wx.request method

The previous article introduced the implementatio...

Future-oriented all-round web design: progressive enhancement

<br />Original: Understanding Progressive En...

Implement full screen and monitor exit full screen in Vue

Table of contents Preface: Implementation steps: ...

Web front-end development CSS related team collaboration

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

Detailed example of using the distinct method in MySQL

A distinct Meaning: distinct is used to query the...

mysql command line script execution example

This article uses an example to illustrate the ex...

A detailed introduction to deploying RabbitMQ environment with docker

Prerequisites: Docker is already installed 1. Fin...

Analysis of the principle of using PDO to prevent SQL injection

Preface This article uses pdo's preprocessing...