Mysql学习mysql 5.7.11 winx64.zip安装配置方法图文教程

概述介绍《Mysql学习mysql 5.7.11 winx64.zip安装配置方法图文教程》开发教程，希望对您有用。

《MysqL学习MysqL 5.7.11 winx64.zip安装配置方法图文教程》要点：
本文介绍了MysqL学习MysqL 5.7.11 winx64.zip安装配置方法图文教程，希望对您有用。如果有疑问，可以联系我们。

安装和配置MysqL数据库系统.MysqL入门

 1、下载MysqL入门

http://cdn.MysqL.com//Downloads/MysqL-5.7/MysqL-5.7.11-winx64.zip

2.解压缩zip包MysqL入门

D:\Program files\MysqL-5.7.11-winx64 

3.配置环境变量MysqL入门

3.1 添加path路径,MysqL入门

D:\Program files\MysqL-5.7.11-winx64\bin

3.2.修改MysqL-default.ini配置文件,MysqL入门

原MysqL入门

# These are commonly set,remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_ID = .....

改为MysqL入门

# 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.以管理员身份进入命令提示符 cmd MysqL入门

进入MysqL的bin目录下,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\binC:\Users\administrator>d:D:\Program files\MysqL-5.7.11-winx64\bin> 

执行MysqLd.exe --initialize 命令,MysqL入门

D:\Program files\MysqL-5.7.11-winx64\bin>MysqLd.exe --initializeD:\Program files\MysqL-5.7.11-winx64\bin>

创建了data目录MysqL入门

MysqL入门

5.执行 MysqLd -install命令MysqL入门

D:\Program files\MysqL-5.7.11-winx64\bin>MysqLd -installService successfully installed. //成功安装服务

 6.执行MysqLd.exe -nt --skip-grant-tablesMysqL入门

注意：窗口无反应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\binC:\Users\administrator>d:D:\Program files\MysqL-5.7.11-winx64\bin>MysqLd.exe --initializeD:\Program files\MysqL-5.7.11-winx64\bin>MysqLd -installService successfully installed. //服务安装成功D:\Program files\MysqL-5.7.11-winx64\bin>MysqLd.exe -nt --skip-grant-tables 

7.重新打开dos窗口,执行MysqL -u rootMysqL入门

进入MySQL命令行,执行命令use MysqL; update user set authtication_string=Password('123456') where user="root"; set password=Password('123456');MysqL入门

按 Ctrl+C 复制代码MysqL入门

Microsoft windows [版本 6.3.9600](c) 2013 Microsoft Corporation.保留所有权利.C:\Users\administrator>MysqLd.exe -nt --skip-grant-tablesC:\Users\administrator>MysqL -u rootWelcome to the MysqL monitor. Commands end with ; or \g.Your MysqL connection ID is 3Server 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 itsaffiliates. Other names may be Trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MysqL> use MysqLDatabase changedMysqL> update user set authtication_string=Password('123456') where user="root" -> set password=Password('123456') ->

按 Ctrl+C 复制代码MysqL入门

8.在任务管理器中终止MysqLd进程,开启MysqL服务.MysqL入门

安装完成.
MysqL入门

精彩专题分享：MysqL不同版本安装教程 MysqL5.7各版本安装教程 MysqL5.6各版本安装教程MysqL入门

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持内存溢出PHP.MysqL入门

总结

以上是内存溢出为你收集整理的Mysql学习mysql 5.7.11 winx64.zip安装配置方法图文教程全部内容，希望文章能够帮你解决Mysql学习mysql 5.7.11 winx64.zip安装配置方法图文教程所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。