下载:可以去官网下载
链接:https://pan.baidu.com/s/1FfPALSBo9ug-AXSYilFhXA
提取码:xqm2
安装:
1.解压到对应想安装的位置
2.在解压后文件夹里,新建data目录和my.ini文件
3.my.ini内容:必须使用ANSI编码格式
以下内容只需要更改:basedir datadir
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
# 设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=E:\developTools\mysql-5.7.26-winx64
# 设置mysql数据库的数据的存放目录
datadir=E:\developTools\mysql-5.7.26-winx64\data
# 允许最大连接数
max_connections=200
# 设置mysql服务端默认字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
#开启查询缓存
explicit_defaults_for_timestamp=true
4.配置环境变量
系统变量path添加mysql的安装路径: E:\developTools\mysql-5.7.26-winx64\bin
5.以管理员身份运行cmd,进入MYSQL的安装目录下的bin目录。
C:\WINDOWS\system32>cd E:\developTools\mysql-5.7.26-winx64\bin
C:\WINDOWS\system32>E:
E:\developTools\mysql-5.7.26-winx64\bin>mysqld --initialize-insecure
E:\developTools\mysql-5.7.26-winx64\bin>mysqld --install
Service successfully installed.
E:\developTools\mysql-5.7.26-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
E:\developTools\mysql-5.7.26-winx64\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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> set password = password('123456')
-> ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
主要执行以下三条命令
mysqld --initialize-insecure
mysqld --install
net start mysql