Windows Mysql 5.7.18免安装教程

最新推荐文章于 2024-10-13 21:08:42 发布

置顶 Google浏览器不能Google

最新推荐文章于 2024-10-13 21:08:42 发布

阅读量313

点赞数 1

分类专栏：工具安装文章标签： mysql mysql5-7 免安装教程

本文链接：https://blog.csdn.net/fhy1969038887/article/details/71756440

版权

工具安装专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.下载地址

点此进入：https://dev.mysql.com/downloads/mysql/

2.找到下载好的文件解压缩，然后安装服务，并完成初始化操作，具体操作如下：

以管理员身份打开cmd

#进入下载文件夹中
cd {bin目录路径}
#安装服务
mysqld -install

在Mysql安装目录下新建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 = .....
# datadir = .....
# port = .....
# server_id = .....

# 安装目录(修改成自己mysql的安装路径)
basedir = E:\mysql-5.7.18-winx64
# 数据存放目录，记得是个空文件夹（data文件夹自动生成无需创建）
datadir = E:\mysql-5.7.18-winx64\data
# 端口
port = 3306

# 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 

# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 最大连接数量
max_connections = 100
# 单个内存表的最大值限定
max_heap_table_size = 64M
# 为每个线程分配的排序缓冲大小
sort_buffer_size = 8M
# join 连表操作的缓冲大小,根据实际业务来设置，默认8M
join_buffer_size = 32M
# sql查询缓存，如果提交的查询与几次中的某查询相同，并且在query缓存中存在，则直接返回缓存中的结果
query_cache_size = 64M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

初始化Data
以下命令会生成一个空密码

mysqld --initialize-insecure

以下命令会生成一个随机密码

mysqld --initialize

提示：随机密码在生成的data目录下的.err文件里，只可使用一次

3.启动服务

# 启动
net start mysql

# 停止
net stop mysql

4.修改密码

# 登录
mysql -u root -p
输入密码：随机密码（加-insecure可直接登录）
# 修改密码
update mysql.user set authentication_string=password('123456') where User='root';
# 刷新权限
flush privileges;
# 退出
quit;
# 重新登录
mysql -u root -p
输入密码：(输入修改好的密码)