MySQL5.7.24压缩包安装教程

刺骨的言语ヽ痛彻心扉 2024-04-03 13:39 19阅读 0赞

MySQL安装包下载：

https://dev.mysql.com/downloads/mysql/

![MySQL5.7.24压缩包安装教程\_MySQL5.7.24压缩包安装教程][MySQL5.7.24_MySQL5.7.24]

根据需要下载对应版本MySQL

![MySQL5.7.24压缩包安装教程\_MySQL5.7.24压缩包安装教程\_02][MySQL5.7.24_MySQL5.7.24_02]

接下来，点击Download，选择No thanks, just start my download就会直接下载安装包。

二：配置环境变量

新建MYSQL\_HOME变量，变量名为你的解压路径名

编辑path变量，在末尾加上 ;%MYSQL\_HOME%\\bin;

三：解压安装包到指定路径-------my.ini文件

1. 下载完成后解压到你想要放的目录(5.7.20左右的版本(至少5.7.20是)，没my-default.ini这个文件了)

2. 在bin的同级目录，新建my-default.ini文件。我的ini文件是这样的：

\[mysqld\]

port = 3306

basedir=D: ools\\mysql-5.7.24-winx64//mysql安装目录

datadir=D: ools\\mysql-5.7.24-winx64/data

max\_connections=200

character-set-server=utf8

default-storage-engine=INNODB

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

\[mysql\]

default-character-set=utf8

3. 在bin目录下面，新建(或者复制my-default.ini)my.ini文件，不然初始化mysqld --initialize-insecure, data文件会报找不到文件夹(不能自动生成data文件夹)

我的my.ini：

\# For advice on how to change settings please see

\# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

\# \*\*\* DO NOT EDIT THIS FILE. It's a template which will be copied to the

\# \*\*\* default location during install, and will be replaced if you

\# \*\*\* upgrade to a newer version of MySQL.

\[mysqld\]

\# Remove leading \# and set to the amount of RAM for the most important data

\# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

\# innodb\_buffer\_pool\_size = 128M

\# Remove leading \# to turn on a very important data integrity option: logging

\# changes to the binary log between backups.

\# log\_bin

\# These are commonly set, remove the \# and set as required.

basedir = D: ools\\mysql-5.7.24-winx64//mysql安装目录

datadir = D: ools\\mysql-5.7.24-winx64\\data

port = 3306

\# server\_id = .....

\# Remove leading \# to set options mainly useful for reporting servers.

\# The server defaults are faster for transactions and fast SELECTs.

\# Adjust sizes as needed, experiment to find the optimal values.

\# join\_buffer\_size = 128M

\# sort\_buffer\_size = 2M

\# read\_rnd\_buffer\_size = 2M

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

四：安装MySQL服务以及初始化

以管理员身份运行cmd，

执行安装mysql服务的命令：mysqld --install

我们可以看到服务已经成功安装。

假设这里出现安装不成功，那么就有可能是你之前安装了但是卸载不完全导致的，所以一定要卸载完整。

完全卸载mysql教程：https://blog.csdn.net/hcrw01/article/details/84261749

初始化MySQL：

? ?mysqld --initialize

初始化完成后会出现data文件夹

如果有data文件夹了，先删除掉，再执行mysqld?--initialize.

![MySQL5.7.24压缩包安装教程\_MySQL5.7.24压缩包安装教程\_03][MySQL5.7.24_MySQL5.7.24_03]

然后启动MySQL：

? ? net start mysql

![MySQL5.7.24压缩包安装教程\_MySQL5.7.24压缩包安装教程\_04][MySQL5.7.24_MySQL5.7.24_04]

MySQL登录：mysql -u root -p

注意：初始密码可以在生成的data文件夹下后缀名为.err的文件

![MySQL5.7.24压缩包安装教程\_MySQL5.7.24压缩包安装教程\_05][MySQL5.7.24_MySQL5.7.24_05]

然后设置自己的登录密码：

alter user user() identified by "你的新密码";

?mysql>FLUSH PRIVILEGES; //刷新权限

[MySQL5.7.24_MySQL5.7.24]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/c023a7b1f282409f8cdface589cfae5f.png
[MySQL5.7.24_MySQL5.7.24_02]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/78eca8e727484614b9e47618b7bd3f77.png
[MySQL5.7.24_MySQL5.7.24_03]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/153ef75824014e87b2a62bf3e213324b.png
[MySQL5.7.24_MySQL5.7.24_04]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/eee231430141412998bbe613018ffea4.png
[MySQL5.7.24_MySQL5.7.24_05]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/a9162cf7feff44bb9ce0cff248083e34.png