MySQL 8.0.15 compressed version installation graphic tutorial

MySQL 8.0.15 compressed version installation graphic tutorial

This article shares the installation method of MySQL 8.0.15 compressed version for your reference. The specific content is as follows

1. Download the mysql8.0.15.zip file

2. Add a configuration file named my.ini in the mysql directory: the content is:

[mysqld]
 
# Set port 3306 port=3306
 
# Set the installation directory of mysql basedir=D:\Program Files\mysql\mysql-8.0.15-winx64
# Set the storage directory of mysql database data datadir=D:\Program Files\mysql\Data
 
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed.
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 
#Default authentication is done with the "mysql_native_password" plugin #mysql_native_password 
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

Among them: When setting the MySQL data storage directory, it depends on your own installation path.

3. Open cmd as an administrator and enter the bin directory in mysql:

4. MySQL initialization: Execute: mysqld --initialize --console The content in the red box in the figure, and write down the temporary password (in the green box): do not count the first space;

5. MySQL installation service: Re-enter cmd and execute: mysqld --install. If the following situation occurs, execute sc delete mysql and then execute mysqld --install

6. Start the mysql service: execute net start mysql

7. You can change the initial password of MySQL according to your personal situation: It is recommended to use the Navicat tool to change the password. When you use the Navicat tool to connect to the MySQL database for the first time, the test passes and Navicat will prompt you to reset the password:

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 installation and configuration tutorial under Win10
  • MySQL 8.0.15 installation and configuration method graphic tutorial under Windows
  • MySQL 8.0.15 winx64 decompression version installation and configuration method graphic tutorial
  • 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 installation graphic tutorial and database basics
  • MySQL 8.0.15 installation and configuration graphic tutorial and password change under Linux
  • MySQL 8.0.15 installation and configuration graphic tutorial under Win10
  • MySQL 8.0.15 winx64 compression package installation and configuration method graphic tutorial

<<:  Samba server configuration under Centos7 (actual combat)

>>:  Docker installation tutorial in Linux environment

Recommend

MySQL 5.7 installation and configuration tutorial under CentOS7 (YUM)

Installation environment: CentOS7 64-bit, MySQL5....

Detailed explanation of the JVM series memory model

Table of contents 1. Memory model and runtime dat...

JS practical object-oriented snake game example

Table of contents think 1. Greedy Snake Effect Pi...

Various methods to implement the prompt function of text box in html

You can use the attribute in HTML5 <input="...

Centos7 implements sample code for restoring data based on MySQL logs

Introduction Binlog logs, that is, binary log fil...

How to use react-color to implement the front-end color picker

background We can use react-color to implement th...

Methods for defragmenting and reclaiming space in MySQL tables

Table of contents Causes of MySQL Table Fragmenta...

How to build a SOLO personal blog from scratch using Docker

Table of contents 1. Environmental Preparation 2....

SQL Practice Exercise: Online Mall Database User Information Data Operation

Online shopping mall database-user information da...

Docker-compose creates a bridge, adds a subnet, and deletes a network card

1. Create a docker network card [root@i ~]# brctl...

Win10 install Linux ubuntu-18.04 dual system (installation guide)

I installed a Linux Ubuntu system on my computer....

Summary of new usage of vi (vim) under Linux

I have used the vi editor for several years, but ...

Quickly solve the problem that the mysql57 service suddenly disappeared

one, G:\MySQL\MySQL Server 5.7\bin> mysqld --i...