Mysql-5.7.31-winx64安装

Mysql-5.7.31-winx64安装

Mysql官网下载地址: https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.31-winx64.zip

1.解压得到文件

2.安装和配置

新建一个配置文件 my.ini

注意不要忘记[mysqld]组名，因为忘记这个报错了

[mysqld]
basedir = C:\\Users\\16431\\Downloads\\mysql-5.7.31-winx64\\mysql-5.7.31-winx64
datadir = C:\\Users\\16431\\Downloads\\mysql-5.7.31-winx64\\mysql-5.7.31-winx64\\data
port = 3306
server_id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
log_bin=mysql-bin
binlog-format=Row

用管理员模式的cmd

进入cmd后cd到 xxxx\mysql-5.7.31-winx64\bin目录下 xxx代表你安装在哪里

需要执行mysqld --initialize mysql-3306 进行初始化。

mysql-3306是服务名

然后键入mysqld install

如果之前安装过可能会出现如下问题

解决方法

3.启动运行

使用net start mysql启动

登入的时候去mysql在根目录下生成data目录，进入data目录，查看xxx.err文件（xxx根据具体的机器进行命名）

root@localhost: 后面就是临时密码

2021-08-04T08:47:56.733873Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-08-04T08:47:56.771541Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-08-04T08:47:56.867649Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: aa2acf03-f500-11eb-9b3e-00ff1f34453b.
2021-08-04T08:47:56.874029Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-08-04T08:47:58.333942Z 0 [Warning] CA certificate ca.pem is self signed.
2021-08-04T08:47:58.765118Z 1 [Note] A temporary password is generated for root@localhost: 5bKdJdXlw(MH

登入使用 mysql -uroot -p你的密码

然后修改你的密码就可以快乐玩耍了

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;

123456就是你的新密码