Mysql8.0 Windows安装

一、下载地址
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-winx64.zip

二、配置环境变量

三、在cmd的bin目录执行以下命令，程序会在动MySQL文件夹下创建data文件夹以及对应的文件，以管理员身份运行cmd

mysqld --initialize-insecure

bin目录下执行

mysqld --install    //安装mysqld服务
net start mysql   //启动mysql服务
mysql -u root -p
回车

修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

注意：

mysqld –initialize-insecure自动生成无密码的root用户，
mysqld –initialize自动生成带随机密码的root用户。

MYSQL安装报错 – 出现Failed to find valid data directory.
https://blog.csdn.net/qwq1503/article/details/86214853
https://blog.csdn.net/weixin_43295278/article/details/82874401

https://blog.csdn.net/qwq1503/article/details/86215704
https://blog.csdn.net/loumoxiaozi/article/details/81118516
https://blog.csdn.net/github_38832708/article/details/83037241
https://www.cnblogs.com/laumians-notes/p/9069498.html
https://blog.csdn.net/gupao123456/article/details/80766154 MySQL 8下忘密码后重置密码的办法
http://www.cnblogs.com/Weirdo-world/p/9269483.html MySQL8.0.11最新版密码重置
https://blog.csdn.net/whimewcm/article/details/83621358
https://www.cnblogs.com/feiyangbaqingchun/p/9751184.html