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. 安装
执行下面的命令。
mysqld –-initialize –-consolemysqld –install
修改密码
alter user 'root'@'locahost' identified by 'new password';
或者
alter user user() identified by 'new password';
