MYSQL必讀
 > [mysqld]
  > # 設置3306端口
  > port = 3306
  > # 設置MySQL的安裝目錄
  > basedir=C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64
  > # 設置MySQL數據庫的數據的存放目錄
  > datadir=C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\data

MYSQL必讀
C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>mysqld -install
Service successfully installed.

MYSQL必讀
net start mysql

MYSQL必讀
C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>net start mysql
The MySQL service is starting.
The MySQL service could not be started.
The service did not report an error.
More help is available by typing NET HELPMSG 3534.

MYSQL必讀
- 創建bin\data目錄,如果存在刪掉以前的
  - 在剛剛的admin權限的運行窗口執行初始化命令,以此來生成沒有密碼的root用戶：
    C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>mysqld --initialize-insecure
  - 再次嘗試打開MySQL服務,不出意外,會返回success：
    C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>net start mysql
    The MySQL service is starting.
    The MySQL service was started successfully.

MYSQL必讀
C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>net start
These Windows services are started:
    ...
  MySQL
    ...

MYSQL必讀
mysql -u root

MYSQL必讀
mysql> use mysql;

MYSQL必讀
mysql> select user, authentication_string from user；
+-----------+-------------------------------------------+
| user   | authentication_string           |
+-----------+-------------------------------------------+
| root   |                      |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+-------------------------------------------+
2 rows in set (0.00 sec)

MYSQL必讀
mysql> update user set authentication_string=password('密碼') where user='root';
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 1

MYSQL必讀
mysql> update user set password=PASSWORD('密碼') where user='root';

MYSQL必讀
mysql> select user, authentication_string from user;
+-----------+-------------------------------------------+
| user   | authentication_string           |
+-----------+-------------------------------------------+
| root   | *8B62E5775164CCBD6B3F9FFFC5ABCEFGHIGKLMNO |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+-------------------------------------------+
2 rows in set (0.00 sec)

MYSQL必讀
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

MYSQL必讀
mysql> exit
Bye

MYSQL必讀
C:\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
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>