安装mysql文件包

下载mysql-8.0.15-winx64.zip，地址是https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15-winx64.zip

写bat文件

把文件夹解压缩到D盘（其实解压到哪都行），在目录下新建install.bat和films.sql

install.bat内代码的内容为

@ECHO ON
@echo 设置环境变量
@SET sqlpath=%~dp0
@setx /M PATH "%sqlpath%bin;%path%"
@echo 初始化数据库配置文件
@del %sqlpath%\my.ini
@echo [mysqld]>>%sqlpath%\my.ini
@echo port=3306>>%sqlpath%\my.ini
@echo basedir=%sqlpath%>>%sqlpath%\my.ini
@echo datadir=%sqlpath%\data>>%sqlpath%\my.ini
@echo max_connections=200>>%sqlpath%\my.ini
@echo max_connect_errors=10>>%sqlpath%\my.ini
@echo character-set-server=utf8>>%sqlpath%\my.ini
@echo default-storage-engine=INNODB>>%sqlpath%\my.ini
@echo default_authentication_plugin=mysql_native_password>>%sqlpath%\my.ini
@echo [mysql]>>%sqlpath%\my.ini
@echo default-character-set=utf8>>%sqlpath%\my.ini
@echo [client]>>%sqlpath%\my.ini
@echo default-character-set=utf8>>%sqlpath%\my.ini
@echo port=3306>>%sqlpath%\my.ini
@%sqlpath%\bin\mysqld.exe --initialize-insecure --user=mysql --console
@echo 开始安装数据库
@%sqlpath%\bin\mysqld.exe --install
@echo 创建电影数据库
@net start mysql
@%sqlpath%\bin\mysql.exe -uroot < %sqlpath%\films.sql
@pause

写films.sql文件

CREATE DATABASE filmsremarks;
USE filmsremarks; 
DROP TABLE IF EXISTS `films_base_temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `films_base_temp` ...