Windows10安装MySQL5.7

本文详细介绍在Windows10环境下安装MySQL5.7的步骤,包括下载、配置环境变量、安装、配置my.ini文件、初始化、启动及进入MySQL等关键环节。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

环境

操作系统:windows10 专业增强版
MySQL:mysql-5.7.24-winx64 下载链接

安装步骤

下载MySQL

选择合适的操作系统版本下载MySQL安装包并解压放置到合适的路径下,例如E:\MySQL路径下
解压路径

配置系统环境变量

Created with Raphaël 2.2.0 此电脑 右击“属性” "高级系统设置" "环境变量" 在 "用户变量"栏新增MySQL变量和值 在"用户变量"栏修改"Path"的值 关闭

新增MYSQL变量
MYSQL变量
修改Path变量值
Path变量

安装MySQL

  1. 右击开始菜单按钮,选择“命令提示符(管理员)”选项。
  2. 进入MySQL安装包跟目录的bin路径下,如图所示,执行安装命令mysqld -install
    安装MySQL

配置my.ini文件

注意: 安装包里面如果没有my.ini文件,需要自己在MySQL安装路径的根目录下创建
my.ini文件内容如下:

[client]

# pipe=

# socket=MYSQL
default-character-set=utf8  
port=3306

[mysql]
no-beep

default-character-set=utf8


# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
# server_type=3
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=MYSQL

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
basedir=E:/MySQL/mysql-5.7.24-winx64

# Path to the database root


# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# General and Slow logging.
log-output=FILE

general-log=0

general_log_file="mysql57.log"

slow-query-log=1

slow_query_log_file="mysql57-slow.log"

long_query_time=10

# Binary Logging.
# log-bin

# Error Logging.
log-error="mysql57.err"

# Server Id.
server-id=1

# Specifies the on how table names are stored in the metadata.
# If set to 0, will throw an error on case-insensitive operative systems
# If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.
# If set to 2, table names are stored as given but compared in lowercase.
# This option also applies to database names and table aliases.
lower_case_table_names=1

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=151

说明

  1. 编码改为utf8

[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

  1. 注意log-error的值(mysql57.err),下面步骤中需要从中获取登录的初始密码

初始化MySQL

在刚才的“命令提示符”中,执行mysqld --initialize

启动MySQL

执行net start mysql
初始化并启动

进入MySQL

  1. 进入安装跟目录的data路径中,找到mysql57.err文件,打开搜索A temporary password is generated for root@localhost:紧跟在后面的就是初始密码(oGkoF:sQe9lf)
    data路径
    初始密码
  2. 执行命令mysql -uroot -p输入上面的初始密码登录
  • 修改root用户密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
    修改用户密码
  • 查看是否为utf8编码 show variables like 'character%';
    查看编码
  • root用户授权 GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
    授权
  • 刷新退出 flush privileges; exit!
    注意事项
    1、彻底删除MySQL, 参考
    2、utf8_general_ci和utf8_unicode_ci区别 参考
    3、一定要以"管理员模式"打开"命令提示符"

参考链接

1、https://blog.youkuaiyun.com/yulutian/article/details/78971369
2、https://www.jianshu.com/p/710e5861c198

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值