MySQL8安装记录

1. 下载解压

2. 进入MySql目录创建my.ini文件

文件配置如下：`[mysqld]

# 设置3306端口

port=3306

# 设置mysql的安装目录

basedir=D:\mysql-8.0.22-winx64

# 设置mysql数据库的数据的存放目录

datadir=D:\mysql-8.0.22-winx64\data

# 允许最大连接数

max_connections=200

# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统

max_connect_errors=10

# 服务端使用的字符集默认为UTF8

character-set-server=utf8

# 创建新表时将使用的默认存储引擎

default-storage-engine=INNODB

# 默认使用“mysql_native_password”插件认证

default_authentication_plugin=mysql_native_password
[mysql]

# 设置mysql客户端默认字符集

default-character-set=utf8
[client]

# 设置mysql客户端连接服务端时默认使用的端口

port=3306
default-character-set=utf8

# 忽略密码

# skip-grant-tables`

3. 配置环境变量

设置变量名：MYQSQL_HOME
设置变量值：D:\mysql-8.0.22-winx64


然后path也要配置：D:\mysql-8.0.22-winx64\bin
亦可[%MYSQL_HOME%\bin]

4. 初始化

• 进入目录下的bin目录执行命令：mysqld --initialize --console
• 完毕后出现如下窗口：！一定要记住密码

2022-02-10T04:13:25.937126Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 2HhwIwU/twne上述窗口表示成功记录下临时密码

5.安装启动服务mysqld --install root

成功后如下


6. 接下来就是启动服务器了，输入命令：

net start mysql

7. 登录并修改密码

mysql -u root -p

输入密码后登录成功显示mysql版本Server version: 8.0.22

8. 修改密码

D:\mysql-8.0.22-winx64\bin>mysql -u root -p Enter password: ************ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.22

修改密码命令：mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';

全部命令如下：

D:\mysql-8.0.22-winx64\bin>mysqld --install
Service successfully installed.

D:\mysql-8.0.22-winx64\bin>net start mysql
MySQL 服务正在启动 ....
MySQL 服务已经启动成功。

D:\mysql-8.0.22-winx64\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.22

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
Query OK, 0 rows affected (0.26 sec)

mysql>