windows10系统下解压版MySQL5.7.16安装

  1、在MySQL官网下载好MySQL-5.7.16版本的zip压缩包,并解压到相关目录,如下:

windows10系统下解压版MySQL5.7.16安装

 

   2、配置环境变量,如下:

windows10系统下解压版MySQL5.7.16安装

 

 

   3、修改MySQL的配置文件,复制一份默认配置文件my-default.ini并改名为my.ini,如下:

windows10系统下解压版MySQL5.7.16安装

 

 用文本工具打开my.ini文件修改其中的basedir、datadir、port,其中, basedir为MySQL安装根路径,

datadir为MySQL安装根目录下的data文件夹路径(默认没有data目录,先不用管,后续会自动创建),port为默认端口号,

如下:

# 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 = G:\coder\database\mysql-5.7.16-winx64
datadir = G:\coder\database\mysql-5.7.16-winx64\data
port = 3312
# 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

  4、注册MySQL服务,以管理员的身份运行cmd命令提示符窗口并进入到MySQL安装路径下的bin目录,并执行以下命令:

mysqld -install将mysql安装到windows服务(移除服务可以用mysqld --remove);在执行mysql --initialize初始化data目录

(前文中配置的data目录在此步骤自动创建)。

windows10系统下解压版MySQL5.7.16安装

 

   5、启动MySQL服务,执行net start mysql(执行net stop mysql停止MySQL服务)如下:

windows10系统下解压版MySQL5.7.16安装

 

   6、登录root用户并更改root用户默认密码,root用户默认密码在data目录下*.err文件中,修改root用户默认密码命令:

alter user ‘root‘@‘localhost‘ identified with mysql_native_password by ‘新密码‘。如下:

windows10系统下解压版MySQL5.7.16安装

 

 

windows10系统下解压版MySQL5.7.16安装

 

   注意:

    1)mysqld –initialize-insecure:自动生成无密码的root用户;

    2)mysqld –initialize:自动生成带随机密码的root用户;

    3)mysqld -remove:移除mysqld服务;

    4)net stop mysql:停止mysql服务;

    5)如果报错,删除data文件夹,重新执行如下流程remove  -->   initialize  -->  install  -->  start

 

windows10系统下解压版MySQL5.7.16安装

上一篇:Selenium自动化结合Mysql数据项目实战操作


下一篇:小程序自定义组件