mysql绿色版安装过程

-绿色版mysql安装过程
1、先下载mysql文件,路径为:https://dev.mysql.com/downloads/mysql/
2、下载之后进行解压,目录自己选定,然后载解压后的bin目录下新建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 = C:\Program Files\mysql-5.7.19-winx64
datadir = C:\Program Files\mysql-5.7.19-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 
# !o>UZ!e(h6(m  初始化的密码

3、配置mysql的path路径:我的电脑–>属性–>高级系统设置–>环境变量–>系统变量–>path(值为安装的目录)
4、进入cmd,进入解压目录的bin路径下,mysqld –install(安装mysql服务命令),如果出现Install/Remove of the Service Denied!这个错误,请以管理员身份运行cmd.exe;当出现Service successfully installed.说明已经安装成功。
5、在运行mysqld –install命令(初始化配置文件),出现A temporary password is generated for root@localhost: f-N7sekNwKhf提示时,初始化完成。(此时记住f-N7sekNwKhf这个密码,下面要用到)
6、执行net start mysql命令,提示MySQL服务已经启动成功,则完成该操作。
7、执行mysql -uroot -p命令,登录mysql,密码为之前生成的密码。
8、执行set password=password(‘root’); 修改面密码。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值