windows下载安装mysql

1.首先去MySQL的官网下载安装包
https://downloads.mysql.com/archives/community/
2.进入解压的目录mysql-8.0.40-winx64，创建my.ini文件与data目录

[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=E:\Program Files\mysql-5.7.40-winx64
# 设置mysql数据库的数据的存放目录
datadir=E:\Program Files\mysql-5.7.40-winx64\data
# 允许最大连接数
default_authentication_plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
max_connections=2048
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
#password1:v#,kon>KH2?k
#password2:root123456

使用管理权限安装，c盘切换目录至e盘，e:
cd E:\Program Files\mysql-5.7.40-winx64\bin
mysqld --install mysql      #安装mysql服务
mysqld --initialize --console
#安装mysql  获取一个随机密码
net start mysql
#启动mysql服务
mysql -uroot -p    #登录mysql
出现此提示：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement则需要去修改初始化的密码
alter user user() identified by 'root123456'；
//修改密码为root123456
show databases;


update user set host = '%' where user = 'root';        //更新root用户能够远程登录
flush privileges;                //刷新权限

net stop mysql #关闭mysql
sc delete mysql#删除mysql

安装过程中可能会出现的问题：查找相关文件放到C:\Windows\System32