mysql5.7的安装

官方下载地址:https://dev.mysql.com/downloads/file/?id=485477

1.我下载的是解压版,将安装包拷贝到安装目录下解压 

2.配置环境变量,在path下添加 mysql安装的bin路径

3.创建my.ini

注意事项如下(1.路径要用\\

                        2.不要设置数据库的数据存放路径 datadir,这个目录下的data由mysql自己生成,下面会说如何生成 )

[Client]
port = 3306
 
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=D:\\soft\\mysql\\mysql-5.7.26-winx64
# 设置mysql数据库的数据的存放目录
# datadir=D:\\soft\\mysql\\mysql-5.7.26-winx64\\data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
 
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8

4.打开cmd.exe(以管理员的身份打开),进入mylsql安装的bin路径下

C:\WINDOWS\system32>d:

D:\>cd D:\soft\mysql\mysql-5.7.26-winx64\bin

5.执行命令 mysqld -install

D:\soft\mysql\mysql-5.7.26-winx64>mysqld -install
Service successfully installed.

6.执行 mysqld --console,可以看出是缺少data文件夹的  别担心执行下一步就生成了

D:\soft\mysql\mysql-5.7.26-winx64>mysqld --console
mysqld: Can't change dir to 'D:\soft\mysql\mysql-5.7.26-winx64\data\' (Errcode: 2 - No such file or directory)
2019-05-18T12:19:07.715836Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-18T12:19:07.715898Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-05-18T12:19:07.716161Z 0 [Note] mysqld (mysqld 5.7.26) starting as process 24404 ...
2019-05-18T12:19:07.718417Z 0 [Warning] Can't create test file D:\soft\mysql\mysql-5.7.26-winx64\data\DESKTOP-RK8U16U.lower-test
2019-05-18T12:19:07.718556Z 0 [Warning] Can't create test file D:\soft\mysql\mysql-5.7.26-winx64\data\DESKTOP-RK8U16U.lower-test
2019-05-18T12:19:07.719314Z 0 [ERROR] failed to set datadir to D:\soft\mysql\mysql-5.7.26-winx64\data\
2019-05-18T12:19:07.719942Z 0 [ERROR] Aborting

2019-05-18T12:19:07.720320Z 0 [Note] Binlog end
2019-05-18T12:19:07.720675Z 0 [Note] mysqld: Shutdown complete

7.执行 mysqld --initialize   可能会停顿几秒  在生成data文件夹和文件夹下的文件

8.如何上一步没报错 我们就可以执行 net start mysql

D:\soft\mysql\mysql-5.7.26-winx64>mysqld --initialize

D:\soft\mysql\mysql-5.7.26-winx64>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

9.首次设置密码,5.7不同于前面的版本,首次登陆的时候不是无密码的,在上面初始化data的时候,就已经初始化了一个随机的临时密码,我们通过这个临时密码登陆修改密码.

10.临时密码可以在data文件夹下看到有一个以.err为后缀的文件

11.打开后缀.err的文件 可以看到如下的日志,如下 loRLC0:-Mu;h  就是我的临时密码

2019-05-18T12:19:56.896498Z 1 [Note] A temporary password is generated for root@localhost: loRLC0:-Mu;h

 12.在cmd中执行 mysql -u root -p  再输入密码就完成第一次登录

D:\soft\mysql\mysql-5.7.26-winx64>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.26

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>

13.设置密码,注意要设置永远不过期,否则默认密码的过期时间为360天.

alter user 'root'@'localhost' identified by 'xxxxx' PASSWORD EXPIRE NEVER account unlock;

如果安装失败 可以使用 mysqld -remove 卸载重试,如果卸载失败可以去控制面板看看,试试手动结束进程再执行卸载语句.