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.