Windows环境下安装Mysql5.7.35&远程授权命令

---

1.下载

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.35-winx64.zip

2.解压

解压Mysql到D:\Program Files (x86)\mysql-5.7.35-winx64

3.准备my.ini

准备好my.ini，放在D:\Program Files (x86)\mysql-5.7.35-winx64目录下，目录下没有my.ini，新建即可。my.ini内容如下：

[client]
port=3306
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
basedir = "D:\Program Files (x86)\mysql-5.7.35-winx64"
datadir = "D:\Program Files (x86)\mysql-5.7.35-winx64\data"
port = 3306
server_id = 1

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

character-set-server=utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

default-storage-engine=InnoDB
max_connections=2000
max_allowed_packet = 128M

innodb_file_per_table=1
lower_case_table_names=1

max_heap_table_size=16M

4.配好mysql环境变量

windows下加入环境变量Path: D:\Program Files (x86)\mysql-5.7.35-winx64\bin

步骤（win10）：此电脑->属性->高级系统设置->环境变量->用户变量->新建path，然后填写。

5.安装MySQL的windows服务

mysqld install MySQL --defaults-file="D:\Program Files (x86)\mysql-5.7.35-winx64\my.ini"

6.删除MySQL服务

如果需要卸载mysql，删除D:\Program Files (x86)\mysql-5.7.35-winx64目录，同时进行 mysql服务的卸载

mysqld --remove MySQL

7.启动与停止mysql

cmd命令下执行：

net start mysql
net stop mysql

8.未安装服务的情况下，如何进行启动

####.mysql手动启动与停止，无服务的情况
D:\Program Files (x86)\mysql-5.7.35-winx64\bin
mysqld --defaults-file="D:\Program Files (x86)\mysql-5.7.35-winx64\my.ini"
pause

####停止mysql命令
mysqladmin -u root shutdown（在设置了密码的情况下的命令为mysqladmin -u root -p shutdown）

9.远程授权命令

grant all privileges on *.* to 'webuser'@'%' identified by '123456' with grant option;
flush privileges;