因为工作需要只有解压版本,所以不得不安装这个版本,我也是在百度搜索方法,整理了我安装这个版本的步骤和需要注意的点,分享出来;
1.mysql官网下载解压版本
MySQL :: Download MySQL Community Server (Archived Versions)
2.解压放置到你想放的位置
在更目录创建文件my.ini和文件夹data
如果通过txt创建请保存为下面格式
文件内容如下:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/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.
[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:\mysql-5.7.34-winx64
datadir = D:\mysql-5.7.34-winx64\data\
port = 3308
server_id = mysql3308
# 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
------------------或者用下面文件,data文件最后自行生成-----------------------------------
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=D:\devsoftware\installed\mysql-5.7.19-winx64\mysql-5.7.19-winx64
datadir=D:\devsoftware\installed\mysql-5.7.19-winx64\mysql-5.7.19-winx64\data
[WinMySQLAdmin]
D:\devsoftware\installed\mysql-5.7.19-winx64\mysql-5.7.19-winx64\bin\mysqld.exe
(Tips:其中basedir为%MYSQL_HOME%,datadir为%MYSQL_HOME%\data ,[WinMySQLAdmin] 下目录为%MYSQL_HOME%\bin\mysqld.exe , 这里的%MYSQL_HOME%需要自定义为自己的解压目录)
4.新建data文件夹,与bin目录同一层级
5.cmd窗口管理员模式打开
6.cd到%MYSQL_HOME%bin目录
7.执行mysqld.exe -install
win10家庭版可能提示这个错误
解决方案:https://www.microsoft.com/zh-CN/download/details.aspx?id=40784 直接下载64位,默认安装,一路Next到底。
重新执行 mysqld.exe -install
提示Service successfully installed
-----------------------------------------------------
3.安装
安装mysql服务,进入到D:\mysql-5.7.34-winx64\bin,打开命令提示符,输入
mysqld install
初始化mysql,输入以下命令,mysql目录下会生成 data 文件夹
mysqld –-initialize
如果没有生成data文件夹及里面的默认数据库文件夹,则使用以下命令
mysqld --no-defaults --initialize
或者
mysqld --initialize-insecure --user=mysql
若是重装可考虑删除data文件夹,通过初始化重新创建
启动mysql,设置密码
net start mysql
mysql admin -u root -p password
设置密码失败,不知道默认密码,则
重置root密码
net stop mysql
使用mysqld –skip-grant-tables实测在mysql8.0.21中已失效,现使用以下命令进入免密登录模式
mysqld --console --skip-grant-tables --shared-memory
另外开一个cmd窗口,使用mysql直接无密登录。输入以下命令回车,提示输入密码时再按回车进入
mysql -uroot -p
use mysql
update user set authentication_string = password('12345'), password_expired = 'N', password_last_changed = now() where user = 'root';
#在之前的版本中,密码字段的字段名是 password,5.7版本改为了 authentication_string
flush privileges;
exit;
4.关闭所有命令提示符窗口
重新打开命令提示窗口,启动服务
net start mysql
输入重置后的用户密码
mysql -uroot -p
“密码”
登录成功即可使用我们客户端连接了,
在配置文件中端口默认是3306好像配置文件没有生效。如果要改端口,大家可以研究下!