windows下mysql8免安装启动

下载

mysql-8.0.33-winx64.zip

创建配置文件 my.ini

[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=F:/software/mysql/mysql-8.0.33-winx64
# 设置mysql数据库的数据的存放目录
datadir=F:/software/mysql/document/data

max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
default-storage-engine=INNODB
authentication_policy=mysql_native_password
[mysql]
default-character-set=utf8mb4
[client]
default-character-set=utf8mb4

初始化数据目录init.bat

只在第一次启动时运行

start ./mysql-8.0.33-winx64/bin/mysqld.exe --defaults-file=./my.ini --initialize

初始化账号密码login.bat

start ./mysql-8.0.33-winx64/bin/mysql.exe -h localhost -u root -P 3306 -p

相关命令

临时密码在 .err 文件

-- 修改本地root密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ''