MySQL安装和配置

1.官方下载地址：https://dev.mysql.com/downloads/mysql/

2.安装：

• 把mysql压缩包解压到非系统盘目录：例如：F:\creatroblue\software
• 新建my.ini文件（初始化）

[mysql]
default-character-set=utf8mb4

[mysqld]
port=3306
basedir=F:/createblue/software/mysql/mysql-8.0.28-winx64
datadir=F:/createblue/software/mysql/mysql-8.0.28-winx64/data
character-set-server=utf8mb4
max_connections=50

3.安装服务：打开cmd，使用管理员的方式打开

./mysqld --install mysql

4.初始化数据库：

mysql --initialize-insecure --user=mysql

5.启动和停止数据库

net start/stop mysql

6.快速恢复数据库

mysqld --remove mysql
sc delete 服务名（操作系统自带）

7.示例：

C:\WINDOWS\system32>f:

F:\>cd F:\createblue\software\mysql\mysql-8.0.28-winx64

F:\createblue\software\mysql\mysql-8.0.28-winx64>cd F:\createblue\software\mysql\mysql-8.0.28-winx64\bin

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>.\mysqld --install mysql
Service successfully installed.

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>.\mysqld --initialize-insecure --user=mysql

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>net start mysql
mysql 服务正在启动 .
mysql 服务已经启动成功。

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>net stop mysql
mysql 服务正在停止.
mysql 服务已成功停止。

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>.\mysqld --remove mysql
Service successfully removed.

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>.\mysqld --install mysql8
Service successfully installed.

F:\createblue\software\mysql\mysql-8.0.28-winx64\bin>net start mysql8
mysql8 服务正在启动 .
mysql8 服务已经启动成功。