win7安装mysql 5.7.25_windows安装MySQL5.7.25解压版

1、新建“MYSQL_HOME”变量，变量的值为解压后MySQL文件夹的名，我的是“D:\AppSoft\Java\mysql-5.7.25-winx64”，Path中添加“%MYSQL_HOME%\bin”

2、在“D:\AppSoft\Java\mysql-5.7.25-winx64”下新建my.ini文件，内容如下

[client]

port = 3306

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

basedir = D:\AppSoft\Java\mysql-5.7.25-winx64

datadir = D:\AppSoft\Java\mysql-5.7.25-winx64\data

port = 3306

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect = 'SET NAMES utf8mb4'

default-storage-engine = INNODB

explicit_defaults_for_timestamp=true

sql-mode = STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER

3、在cmd中进入“D:\AppSoft\Java\mysql-5.7.25-winx64\bin”目录

输入：mysqld -install

安装成功后，输入：mysqld --initialize

启动mysql服务：net start mysql

打开新的cmd在bin这个文件夹下  然后执行命令  mysql -uroot -p ，然后依次进行以下命令:

(1)use mysql;

(2)update user set authentication_string=password('新密码') where user='root' and Host='localhost';

(3)刷新权限：flush privileges;

(4)退出：quit

(5)重新登录：mysql -uroot -p       提示输入密码，这时输入密码会提示欢迎进入