


This article mainly shares with you the graphic tutorial of the mysql5.7.11 installation and configuration method, which has a certain reference value. Interested friends can refer to
Installation and ConfigurationMySql Databasesystem.
1. Download
http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip
2. Unzip the zip package
D:\Program Files\mysql-5.7.11-winx64
3. Configure environment Variables
3.1 Add path ,
D:\Program Files\mysql-5.7.11-winx64\bin
3.2. Modify the mysql-default.ini configuration file,
original
# These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = .....
is changed to
# These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.11-winx64 datadir = D:\Program Files\mysql-5.7.11-winx64\Data port = 3306 # server_id = .....
4. Enter the command prompt cmd as an administrator
Enter the bin directory of mysql,
Microsoft Windows [版本 6.3.9600] (c) 2013 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>cd D: D:\ C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin C:\Users\Administrator>d: D:\Program Files\mysql-5.7.11-winx64\bin>
Execute the mysqld.exe --initialize command,
D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize D:\Program Files\mysql-5.7.11-winx64\bin>
created the data directory
5. Execute the mysqld -install command
D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install Service successfully installed. //成功安装服务
6. Execute mysqld.exe -nt --skip-grant-tables
Note : The window is unresponsive
Microsoft Windows [版本 6.3.9600] (c) 2013 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>cd D: D:\ C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin C:\Users\Administrator>d: D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install Service successfully installed. //服务安装成功 D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe -nt --skip-grant-tables
7. Re-open the dos window, execute mysql -u root
to enter the mysql command line, and execute the command use mysql; update user set authtication_string=Password('123456') where user="root"; set password=Password('123456');
Press Ctrl+C to copy the code
Microsoft Windows [版本 6.3.9600] (c) 2013 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>mysqld.exe -nt --skip-grant-tables C:\Users\Administrator>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.11 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('123456') where user="root" -> set password=Password('123456') ->
Press Ctrl+C to copy the code
8. Terminate the mysqld process in the task manager and start the mysql service.
The installation is complete.
The above is the detailed content of Detailed explanation of mysql5.7.11 winx64.zip installation and configuration method (picture). For more information, please follow other related articles on the PHP Chinese website!

从零开始学习Pygame:完整的安装和配置教程,需要具体代码示例引言:Pygame是一个使用Python编程语言开发的开源游戏开发库,它提供了丰富的功能和工具,使得开发者可以轻松创建各种类型的游戏。本文将带您从零开始学习Pygame,并提供完整的安装和配置教程,以及具体的代码示例,让您快速入门。第一部分:安装Python和Pygame首先,确保您的计算机上已

PyCharm社区版是一款非常强大且广泛使用的Python集成开发环境(IDE),它提供了丰富的功能和工具,帮助开发者提高效率。本文将为大家提供一份详细的PyCharm社区版安装教程,无论您是否有编程经验,都可以轻松地安装和配置PyCharm。一、下载PyCharm社区版首先,我们需要下载PyCharm社区版的安装包。您可以访问JetBrains官方网站(h

Flask安装配置全攻略:轻松掌握PythonWeb开发的基石引言:随着Python的快速发展,越来越多的开发者开始关注PythonWeb开发。在PythonWeb开发中,Flask作为一种轻量级的Web框架,受到了广大开发者的喜爱。本文将为大家介绍Flask的安装与配置过程,并提供具体的代码示例,帮助大家轻松掌握PythonWeb开发的基石。一、环境

轻松上手:UbuntuVNC安装和配置指南导语:Ubuntu是一款功能强大且广受欢迎的操作系统,VNC则是一种远程桌面协议,可以使用户通过网络控制远程计算机。本文将带你详细了解Ubuntu系统中VNC的安装和配置过程,包括具体代码示例。第一步:安装VNCServer打开终端(Terminal),输入以下命令以安装VNCServer:sudoapt-g

从零开始:Java虚拟机安装及配置详解【导语】Java是一种跨平台的编程语言,其执行平台依赖于Java虚拟机(JavaVirtualMachine,JVM)。通过安装和配置Java虚拟机,你可以在不同的操作系统上运行Java程序。本文将带你从零开始,详细介绍如何安装和配置Java虚拟机,以及提供一些常用的Java代码示例。让我们开始学习吧!【第一部分:J

一步步教你在Ubuntu上安装配置golang,需要具体代码示例在计算机编程领域,Golang是近年来备受关注的一门编程语言。它简洁、高效、并发性能优异,因此受到了越来越多的开发者的青睐。在本文中,我们将一步步教你如何在Ubuntu操作系统上安装和配置Golang,并提供一些实际的代码示例供你练习。第一步,安装Golang。为了在Ubuntu上安装Golan

Golang新手指南:Mac系统下安装和配置全攻略Go语言(又称Golang)是一种由Google开发的开源编程语言,它具有快速编译、高效执行和轻量级的特点,适合用于构建高性能的应用程序。本篇文章将为Mac系统下的Golang新手提供详细的安装和配置指南,帮助他们轻松入门这门新兴的编程语言。1.安装Golang步骤一:下载Golang安装包首先,打开官方网

安装设置下载tar包:wget-chttp://download.redis.io/releases/redis-3.2.4.tar.gz解压安装tarzxvfredis-3.2.4.tar.gzmkdir/usr/local/redismakePREFIX=/usr/local/redisinstall设置环境变量vim/etc/profileexportREDIS_HOME=/usr/local/redisexportPATH=$PATH:$REDIS_HOME/bin:wqsource/e


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

SublimeText3 English version
Recommended: Win version, supports code prompts!

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Dreamweaver CS6
Visual web development tools

WebStorm Mac version
Useful JavaScript development tools