mysql绿色版安装过程

时间:2021-12-21 16:31:57

-绿色版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’); 修改面密码。