MySQL 5.7.17 winx64 decompression version installation and configuration method graphic tutorial

This article shares the installation and configuration method of MySQL 5.7.17 winx64 decompression version for your reference. The specific content is as follows

1. Download

Download

2. Configuration

1. Unzip the downloaded MySQL installation package, copy the my-default.ini file in the unzipped directory to the same directory, rename it to my.ini file, and then modify the file content as follows:

2. Configure the environment variables and add the directory D:\mysql\mysql-5.7.17-winx64\bin to Path.

3. Installation

1. Open the DOS command line in administrator mode and enter the bin directory of MySQL.

2. Initialize the data and execute the command: mysqld --initialize-insecure (there is a space in front and no space in the back)

Then a data folder will be generated, and the correct size is 120M.

3. Install mysql service: mysqld install

4. Start mysql in two ways:

Method 1: net start mysql

Method 2: Start directly in the service list

4. Verify that MySQL is successfully installed

Restart the DOS command line and enter the command: mysql –uroot –p

If this interface appears, it means that MySQL is installed successfully.

appendix:

1. Stop the service through the command line.

2. Removal of Services

3. Common mysql commands:

1).show databases; #Show all databases

2).create database test; #Create a database named test.

3).use test; means using the test database.

4).create table student(id int primary key auto_increment, sname varchar(20), birthday date);#Create student, primary key automatically increases.

5).insert into student(sname, birthday) values('zhangsan', '1989-12-23');#Insert data

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.