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

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

D:\Program Files\mysql-5.7.11-winx64 

D:\Program Files\mysql-5.7.11-winx64\bin

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

# 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 = .....

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> 

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize
D:\Program Files\mysql-5.7.11-winx64\bin>

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install
Service successfully installed. //成功安装服务

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 

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')
 ->