安装绿色版Mysql的步骤以及配置相关

1、解压到D:\ProgramFiles (x86)\mysql-5.7.16-winx64

2、配置my.ini文件如下：（提示，附件中有my.ini文件，学习查看本文章的朋友请自行下载即可）

<<my.ini>>

# 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 thebinary log between backups.

# log_bin

 

# These are commonlyset, remove the # and set as required.

#数据库安装目录

basedir = D:\ProgramFiles (x86)\mysql-5.7.16-winx64

#数据文件目录

datadir = D:\ProgramFiles (x86)\mysql-5.7.16-winx64\data

port = 3306

# server_id = .....

 

 

# Remove leading #to set options mainly useful for reporting servers.

# The serverdefaults are faster for transactions and fast SELECTs.

# Adjust sizes asneeded, 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

3、配置环境变量

MYSQL_HOME  D:\Program Files (x86)\mysql-5.7.16-winx64

path后添加%MYSQL_HOME%\bin; 若path最后没有分号请添加分号

4、按win+r输入cmd进入命令行进入到 D:\Program Files(x86)\mysql-5.7.16-winx64\bin 目录

输入 mysqld --initialize 然后输入

 mysqld install

提示安装成功

输入net start mysql

提示服务启动成功

5、 修改mysql账号及密码

 1.修改my.ini 在[mysqld]下添加 skip-grant-tables

 2. 重启mysql服务在命令行输入 mysql -u root -p进入

 3.输入update mysql.user setauthentication_string=password('root') where user='root' and Host='localhost';

 4. flush privileges;

 5.quit

 6.还原my.ini文件重启服务

 7.可以使用 mysql -u root -p 'root' 进入mysql了