Home > Database > Mysql Tutorial > body text

Detailed graphic tutorial on installation and configuration of MySQL5.7 zip version

黄舟
Release: 2017-03-24 14:19:24
Original
1673 people have browsed it

This article mainly introduces the detailed installation and configuration steps of MySQL 5.7 zip version (zip version). It is very good and has reference value. Friends in need can refer to the following

Preface: Reinstall win10 and organize files by the way. , but it took me an entire afternoon to install MySQL, which is really not worth it, so I wrote this article to help everyone.

1. Download

2. Unzip the zip package



3. Configure environment variables

(1) Configure Path



(2) Modify the mysql-default.ini configuration file

Original:

# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....
Copy after login

Modified:

4. Enter the command prompt cmd as administrator

Note: First mysqld -install, then mysqld –initialize

(1) Execute mysqld -install

C:\Users\donald>cd D:\tools\developer\MySQL\mysql-5.7.17-winx64\binC:\Users\donald>d:D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>
mysqld -installService successfully installed. //成功安装服务
Copy after login

(2) Execute mysqld –initialize

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld --initializeD:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>
Copy after login

will automatically create the data folder



(3) mysqld.exe -nt –skip-grant-tables (note: the window does not respond)

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld.exe -nt --skip-grant-tables
Copy after login

(4) Directly close the window and then reopen dos (open as administrator in the same way)

C:\Users\donald>mysql -u root Welcome to the MySQL monitor. Commands end with ; 
or \g. Your MySQL connection id is 3 Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000, 2016, 
Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. 
Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 mysql> use mysql Database changed mysql> update user set authtication_string=Password('admin') where user="root"; 
 //这时候会提示修改成功等,或者waring 什么的。 mysql>flush privileges; 0 rows affected (0.01 sec)
Copy after login

5. Verification successful

(1) Terminate the mysqld process in the task manager and start the mysql service

C:\Users\donald>net start mysql
Copy after login

If it appears:

#Open the task manager, find mysqld, and end the process.

Then restart mysql and that's it.

(2) Enter mysql -u root -p

C:\Users\donald>mysql -u root -p//输入admin
Copy after login

The above is the detailed content of Detailed graphic tutorial on installation and configuration of MySQL5.7 zip version. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template