介绍如何将官网下载的 MySQL5.7.x zip 包配置成系统服务，以及 MySQL 的基本配置和初始化。

免安装版下载

点击进入 MySQL 官网下载页面，选：Windows (x86, 64-bit), ZIP Archive

配置

解压至：C:\dev\mysql-5.7.33-winx64，并在此目录添加一个空目录：data

配置文件

在解压目录添加 my.ini，内容如下

1
2
3
4
5
6
7
8
9
10
11
12
13
[mysqld]
basedir = C:\dev\mysql-5.7.33-winx64
datadir = C:\dev\mysql-5.7.33-winx64\data
port = 3306
lower_case_table_names = 1
default_authentication_plugin=mysql_native_password
character-set-server = utf8mb4

[mysql]
default-character-set = utf8mb4

[client]
default-character-set = utf8mb4

安装成系统服务

以管理员身份运行 cmd，进入：C:\dev\mysql-5.7.33-winx64\bin 运行：mysqld --install MySQL

1
2
C:\dev\mysql-5.7.33-winx64\bin>mysqld --install MySQL
Service successfully installed.

添加环境变量

  1. 新增 MySQL 环境变量：MYSQL_HOME = C:\dev\mysql-5.7.33-winx64
  2. 修改 Path 环境变量，Path变量下,末尾新增 %MYSQL_HOME%\bin

初始化数据库

在MySQL安装目录的 bin 目录下执行初始化命令：mysqld --initialize --console

1
2
3
4
5
6
7
8
C:\dev\mysql-5.7.33-winx64\bin>mysqld --initialize --console
2021-03-15T01:21:35.729152Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-15T01:21:37.565248Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-03-15T01:21:37.737449Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-03-15T01:21:37.842739Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c9f76896-852c-11eb-9a59-888888888788.
2021-03-15T01:21:37.848914Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-03-15T01:21:40.485635Z 0 [Warning] CA certificate ca.pem is self signed.
2021-03-15T01:21:41.592488Z 1 [Note] A temporary password is generated for root@localhost: fi;tjh<kj4vS

  1. 注意看提示：A temporary password is generated for root@localhost: fi;tjh<kj4vS
  2. 我们先记住初始密码，一会儿会用上（每次初始化的密码都不一样，你要看自己的提示）：fi;tjh<kj4vS
  3. 删掉 data 目录下的所有目录和文件，再执行一遍初始化命令，又会重新生成，相当于重新初始化。

启动

cmd 执行：net start MySQL

1
2
3
C:\dev\mysql-5.7.33-winx64\bin>net start MySQL
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

修改默认密码

初始化之后，必须修改默认密码，否则使用不了，如下，试着创建新数据库。

先用默认密码登录

1
2
3
4
5
6
7
8
9
10
11
12
13
C:\dev\mysql-5.7.33-winx64\bin>mysql -uroot -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

试着创建数据库

1
2
3
mysql> create schema if not exists apg default character set utf8mb4;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>

修改默认密码

1
2
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'RoOtPaSs';
Query OK, 0 rows affected (0.02 sec)

绿色版卸载

以管理员身份执行

  1. 停止 MySQL 服务
  2. mysqld –remove
  3. 删除 mysql 根目录下 my.ini 配置的 data 目录，删除 mysql server 相关文件
1
2
3
4
5
6
7
8
C:\WINDOWS\system32>mysqld --remove
Failed to remove the service because the service is running
Stop the service and try again
C:\WINDOWS\system32>net stop mysql
MySQL 服务正在停止..
MySQL 服务已成功停止。
C:\WINDOWS\system32>mysqld --remove
Service successfully removed.

c# 连接 MySQL

https://dev.mysql.com/downloads/connector/net/
安装MySQL Connector/NET。可以从MySQL官方网站下载最新版本的Connector/NET。
安装后，到安装目录，对应编译的 framework 目标版本下的 Mysql.Data.dll，引用。
后续的，网上教程挺多的，就不写了。