新版Mysql8.0.11安装与配置

step one

Unzip the package in your local directory and copy the path like D:\mysql-8.0.11-winx64\bin
Add environment variable : add it into System Variables Path

step two

Create a file my.ini and put it into the folder D:\mysql-8.0.11-winx64\bin
Note: the content about path depend on you own directory
my.ini

 [client]
port=3306
default-character-set=utf8

[mysqld] 
# 设置为自己MYSQL的安装目录 
basedir=D:\mysql-8.0.11-winx64
# 设置为MYSQL的数据目录 
datadir=D:\mysql-8.0.11-winx64\data
port=3306
character_set_server=utf8
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[WinMySQLAdmin]
%MYSQL_HOME%\bin\mysqld.exe
#开启查询缓存
#explicit_defaults_for_timestamp=true
#skip-grant-tables

step three

Run cmd as the administrator,and cd into path like D:\mysql-8.0.11-winx64\bin

//mysql安装  
mysqld -install
//执行结果为 Service Successfully installed

//初始化mysql数据，并创建一个具有空密码的root用户
mysqld --initialize-insecure 
//注意：最后的参数 --user=mysql 在 windows 也可以不用添加，但在 unix 等系统下好像很重要。执行命令后，等一会后，系统会自动生成相应的 data 目录，并自动创建好空密码的 root 用户。此时表示初始化成功。

//开启服务
net start mysql
//执行结果为The MySQL sevice is starting...
//The MySQL service was started successfully.

//原密码为空直接回车即可
mysqladmin -u root -p password  新密码
Enter password: //旧密码回车即可
New Password://新密码
Confirm New password://新密码

Step four

Almost done.let's test it right now.

net stop mysql 
net start mysql
mysql -u root -p
Enter password: //新密码

Now you are in ;-)