MySql 批处理安装不同的端口号 实例
需要准备 install.bat, mysql.ini, create_user.sql 三个文件，内容分别如下。
install.bat 内容
@echo off
echo 启动mysql并更新密码
"c:\mysql57\bin\mysqld.exe" --initialize-insecure --console --explicit_defaults_for_timestamp
"c:\mysql57\bin\mysqld.exe" install MySql57 --defaults-file=c:\mysql57\my.ini
net start MySql57
sc config MySql57 start=auto
ping -n 5 127.1>nul
echo "install mysql"
"c:\mysql57\bin\mysql.exe" --port=3307 -uroot --skip-password -e "CREATE DATABASE IF NOT EXISTS my_db"
"c:\mysql57\bin\mysql.exe" --port=3307 -uroot --skip-password <"c:\mysql57\create_user.sql" --default-character-set=utf8
net stop MySql57
net start MySql57
mysql.ini 内容
[mysql]
default-character-set=utf8
[client]
[mysqld]
#设置3306端口
port = 3307
basedir=c:\mysql57
datadir=c:\mysql57\data
# 允许最大连接数
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
create_user.sql
flush privileges;
set password for root@localhost = password('123456');
CREATE USER 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;
quit