mysql window 安装

1.下载并解压

https://dev.mysql.com/downloads/mysql/

2.mysql根目录配置my.ini文件

[mysql]
default-character-set=utf8mb4
[mysqld]
basedir = C:\\mysql
datadir = C:\\mysql\\data
character_set_server=utf8mb4
max_allowed_packet = 20M
max_connections = 1000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names = 1

3.配置环境变量

MYSQL_HOME=C:\mysql

PATH=%MYSQL_HOME%\bin

4. 初始化数据库（此处记录下初始密码）

mysqld --initialize --user=mysql --console 

5. 安装服务并启动

mysqld -install

net start mysql

6. 重置密码

mysql -u root -P3306 -p

SET PASSWORD = PASSWORD('root');

7. 授权远程灯亮

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pssswd' WITH GRANT OPTION;
FLUSH PRIVILEGES;