MySQL绿色版安装

1. 创建配置文件

my.ini文件

[mysqld]
port=3306
basedir=C:\Program Files\mysql-8.0.16-winx64
datadir=D:\Files\MySQL Files
max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password

[mysql]
default-character-set=utf8mb4

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

2. 配置环境变量

...

3. 安装

执行下面的命令。

1. mysqld –-initialize –-console
2. mysqld –install

修改密码

alter user 'root'@'locahost' identified by 'new password';

或者

alter user user() identified by 'new password';