1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

[mysqld]
default-time_zone = '+8:00'
basedir=D:\Software\mysql-8.0.40-winx64
datadir=D:\Software\mysql-8.0.40-winx64\data

bind-address=127.0.0.1
mysqlx-bind-address= 127.0.0.1
max_connections=200
max_connect_errors=10
character-set-server=utf8

[mysql]
default-character-set=utf8

[client]
port=3306

1
2

cd bin
.\mysqld.exe --initialize --console

1

./mysqld.exe --install  mysql

1

mysql -u root -p

1
2

alter user 'root'@'localhost' IDENTIFIED BY '123456';
exit

1

mysql -u root -p