mysql绿色版本的安装

下载mysql压缩包下载官方正版

找到 Windows (x86, 64-bit), ZIP Archive 点击下载### 下载完成[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传这是下载的包解压出来的文件结构。

配置

1.在这个目录下新建一个my.ini内容为

javascript# 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]#skip-grant-tables # 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 = .....basedir ="D:\mysql" # 设置mysql的安装目录 datadir ="D:\mysql\data" # 设置mysql数据库的数据的存放目录，必须是data，或者是//xxx/data # 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 #服务端的编码方式character-set-server=utf8mb4[client]#客户端编码方式，最好和服务端保存一致loose-default-character-set=utf8mb4 [WinMySQLadmin] Server = "D:\tools\mysql-8.0.19-winx64\bin\mysqld.exe"

2. 建立基础文件夹和data数据存放文件夹以我本地为例，建好之后，将my.ini 的basedir/datadir/Server设置为如下所示内容

javasbasedir ="D:\mysql" # 设置mysql的安装目录 datadir ="D:\mysql\data" # 设置mysql数据库的数据的存放目录，必须是data，或者是//xxx/data Server = "D:\tools\mysql-8.0.19-winx64\bin\mysqld.exe"

3. 配置系统变量配置系统变量的环境变量的path，找到path-点编辑-新建-内容为

javascriptD:\tools\mysql-8.0.19-winx64\bin

4. 初始化data及启动mysql用管理员权限打开cmd，输入命令：

mysqld --initialize-insecure --user=mysql
执行顺利，d/mysql/data目录下。会出现很多文件，在执行
mysqld –install
执行顺利出现，控制台出现Service success installd， 执行顺利会提示，服务已启动字样。
net start mysql
启动服务，执行顺利会提示，服务已启动字样。

5. 初始化密码第一次登陆不用密码，直接回车即可登陆

mysql –u root -p
出现mysql打头，即为登录成功
use mysql;//密码为rootupdate user set authentication_string=PASSWORD("root") where user="root";//更新权限flush privileges; //退出mysqlquit;
最好是初始化一个密码最好。

测试

这样mysql绿色版即为安装成功。可以使用navicat去测试是否可以连接上了。