MySQL（1）WIN10 安装配置 MySQL-8.0.17 以及常见问题

我的环境

• MySQL-8.0.17
• Windows 10

MySQL8.0.17 下载地址

https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.17-winx64.zip

安装步骤

初始化Mysql

解压，使用CMD命名进入解压后的bin目录执行初始化命令：mysqld --initialize --console
初始化完毕后，会生成密码，我生成的密码是yIqn;h&cq4vu

D:\>cd Tools
D:\Tools>cd Mysql-8.0.17-winx64

D:\Tools\Mysql-8.0.17-winx64>cd bin
D:\Tools\Mysql-8.0.17-winx64\bin>mysqld --initialize --console
2019-09-19T18:54:29.151678Z 0 [System] [MY-013169] [Server] 
D:\Tools\Mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server 
in progress as process 16776 2019-09-19T18:55:14.709870Z 5 [Note] [MY-010454] [Server] 
A temporary password is generated for root@localhost: yIqn;h&cq4vu
2019-09-19T18:55:49.626651Z 0 [System] [MY-013170] [Server] 
D:\Tools\Mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server has completed

安装服务

输入安装服务命令：mysqld install MySQL-8.0.17
输入启动服务器命令：net start mysql-8.0.17

D:\Tools\Mysql-8.0.17-winx64\bin>mysqld install MySQL-8.0.17
Service successfully installed.
D:\Tools\Mysql-8.0.17-winx64\bin>net start mysql-8.0.17
MySQL-8.0.17 服务正在启动 ...
MySQL-8.0.17 服务已经启动成功。