MySQL 5.7.18 free installation version configuration tutorial

MySQL 5.7.18 free installation version configuration tutorial

MySQL 5.7.18 free installation version installation tutorial

MySQL is currently the most popular open source database in the world. The core storage of many large companies is often MySQL.

To install MySQL, you can go directly to the official website to download it. This tutorial will explain how to configure and install the free installation version of MySQL.

Official download: https://www.mysql.com/downloads/
Select Download MySQL Community Server and choose the corresponding download according to the number of bits on your computer.

這里寫圖片描述

After downloading, unzip it and create a custom directory.

MySQL cannot be used immediately after decompression. Environment variables need to be configured.

My Computer -> Properties -> Advanced -> Environment Variables

這里寫圖片描述

Create a new MYSQL_HOME variable value and set it to the custom directory you just downloaded and unzipped

這里寫圖片描述

Add the content shown in the above figure after the system variables, and pay attention to the ';' before the content.

After adding the variables, we still cannot start mysql normally because our user initial configuration has not been established and there is no DATA folder and initialization configuration file in your installation directory.

Create a new configuration file in the directory and copy the following content.

[client] 
port=3306 
default-character-set=utf8 
[mysqld] 
port=3306 
character_set_server=utf8 
basedir=D:\mysql-5\mysql-5.7.18-winx64

Unzip the directory

datadir=D:\mysql-5\mysql-5.7.18-winx64\data

Unzip the data directory

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

MySQL server-side storage engine

default-storage-engine=MEMORY 
[WinMySQLAdmin] 
D:\mysql-5\mysql-5.7.18-winx64\bin\mysqld.exe

Among them, D:\mysql-5\mysql-5.7.18-winx64 should be changed to your own installation directory.

And rename it to my.ini.

At this time, our initialization configuration file has been written, but since MySQL version 5.7 no longer comes with data, we do not have a default database, which is the data folder mentioned above. We run the command line in administrator mode. And open it in your own decompressed directory.
D:\mysql-5\mysql-5.7.18-winx64\bin>mysqld –initialize-insecure –user=mysql
At this time, mysql starts to create the data folder itself, and after the creation is completed.

Enter mysql -install in command line mode
The Server successfully installed message indicates that the database is installed successfully.
Entering net start mysql shows that the service is starting and the service started successfully. Description: The database service is started.

mysql -u root -p open the database

Since this is our first time logging into MySQL, just press Enter to log in.

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 5.7.22 binary package installation and installation-free version Windows configuration method
  • Ubuntu16.04 installation mysql5.7.22 graphic tutorial
  • How to install MySQL server community version MySQL 5.7.22 winx64 in win10
  • Installation process of MySQL5.7.22 on Mac
  • mysql5.7.22 download process diagram
  • MySQL 5.6.17 Green Edition (Free Installation) Installation and Configuration Tutorial
  • MySQL 5.7 installation-free configuration graphic tutorial
  • MySQL 5.6 free installation version environment configuration graphic tutorial
  • The actual configuration method of MySQL free installation version
  • MySQL free installation version (zip) installation and configuration detailed tutorial

<<:  Some Linux file permission management methods you may not know

>>:  Summary of relevant knowledge points of ajax in jQuery

Recommend

Mysql implementation of full-text search and keyword scoring method example

1. Introduction Today a colleague asked me how to...

How to modify Ubuntu's source list (source list) detailed explanation

Introduction The default source of Ubuntu is not ...

Mysql query the most recent record of the sql statement (optimization)

The worst option is to sort the results by time a...

JavaScript drag time drag case detailed explanation

Table of contents DragEvent Interface DataTransfe...

Solution to data duplication when using limit+order by in MySql paging

Table of contents summary Problem Description Ana...

js simple and crude publish and subscribe sample code

What is Publish/Subscribe? Let me give you an exa...

A brief introduction to the command line tool mycli for operating MySQL database

GitHub has all kinds of magic tools. Today I foun...

Example of making XML online editor using js

Table of contents Preface The need for online XML...

HTML background color gradient achieved through CSS

Effect screenshots: Implementation code: Copy code...

CSS container background 10 color gradient Demo (linear-gradient())

grammar background: linear-gradient(direction,col...

What does the "a" in rgba mean? CSS RGBA Color Guide

RGBA is a CSS color that can set color value and ...

HTML code to add quantity badge to message button

HTML code: <a onclick="goMessage();"...

How to quickly clean up billions of data in MySQL database

Today I received a disk alarm exception. The 50G ...

js to achieve star flash effects

This article example shares the specific code of ...