MySQL5.7 database detailed installation method and configuration steps (pictures and texts)

MySQL is a relational database management system , developed by the Swedish MySQL AB company, and is currently a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in one big warehouse, which increases speed and Increased flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites.

Due to the excellent performance of its community version, it can form a good development environment with PHP and Apache. The following is the mysql installation tutorial:

1. Install MySQL

When installing in windows, there are two installation methods to choose from: 1.MSI (Windows Installer); 2.ZIP installation package;

MySQL5.7 database download address: http://www.php.cn/xiazai/gongju/116

1. Double-click mysql-installer-community-5.7.17.0.msi

##2. Select the default

The required tools will be checked before installation. python3.4 is missing here

Then Next, it will automatically download Python3.4 and install it

This is the installation in progress

After the installation is completed

Next, you need to configure some parameters below

The port can be changed to what you like, the default is 3306

Set root user password

Set default startup

Test the connection, enter the password yourself, check Next

displays success, next

The installation is successful and you can finish

2. Verify installation

1. Method one, use MySql’s own

2. Method two, use cmd

Right-click My Computer-->Properties-->Advanced--->Environment Variables, add the path to the mysql bin directory in path.

Select the environment variable and enter your MySQL path under the path path in the environment variable. OK. Note that if your user environment variable also has path, fill it in as well.

This is the default installation path C:\Program Files\MySQL\MySQL Server 5.6\bin

Okay, you can enter it. mysql -h 127.0.0.1 -u root -p and enter the password. You can connect to the local MySql database.

3. Client Tools

It is very inconvenient to write statements in this black box. Here I introduce two clients Terminal tools, you can directly write sql statements, view databases, etc.

1. MySQL Workbench 6.3 CE Here, MySQL comes with it when you install it.

I hope it will be a reference for new PHP users when installing and MySQL5.7 database !

Related articles:

Mysql database database installation video tutorial

MySQL data learning road MySQL installation and MySQL Overview

linux mysql installation and maintenance