mysql一次安装通过，不折腾

1.下载
地址：https://dev.mysql.com/downloads/mysql/5.7.html

推荐下载zip版

2.解压放到磁盘中 D:\04_DevicesTools\mysql-5.7.33-winx64

3.在mysql解压缩包根目录下创建my.ini 文件

 [mysqld]
basedir=D:\04_DevicesTools\mysql-5.7.33-winx64\
datadir=D:\04_DevicesTools\mysql-5.7.33-winx64\data\
port=3306
skip-grant-tables

basedir—mysql目录
datadir—数据路径，data目录（用户初始化数据库文件目录）
skip-grant-tables —刚开始跳过登陆校验，后续要删除

4.添加path环境变量

D:\04_DevicesTools\mysql-5.7.33-winx64\bin

5.以管理员打开命令行窗口，并进入到mysql的bin目录,安装mysql服务及初始化数据库
win中搜索命令行，右键以管理员运行

a 安装服务：
mysqld install
b 初始化数据库
mysqld --initialize-insecure --user=mysql

C:\Users\tangwenbo6>mysqld install
Service successfully installed.

C:\Users\tangwenbo6>mysqld --initialize-insecure --user=mysql

6.跳过登陆，启动mysql
上述第三个步骤中skip-grant-tables起到了作用，使得登录不需要密码
net start mysql

C:\Users\tangwenbo6>cd /d D:\04_DevicesTools\mysql-5.7.33-winx64\bin
D:\04_DevicesTools\mysql-5.7.33-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

7.进入mysql，修改密码，并刷新权限
D:\04_DevicesTools\mysql-5.7.33-winx64\bin>mysql

UPDATE mysql.user SET authentication_string = PASSWORD(‘新密码’) WHERE user = ‘root’;

FLUSH PRIVILEGES; 记得分号，下面代码有错误示范

D:\04_DevicesTools\mysql-5.7.33-winx64\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33 MySQL Community Server (GPL)

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.

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE user = 'root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> FLUSH PRIVILEGES
    -> FLUSH PRIVILEGES;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FLUSH PRIVILEGES' at line 2
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

8.exit退出mysql，然后将mysql根目录下的my.ini 配置文件中的跳过登陆配置skip-grant-tables注释掉

 [mysqld]
basedir=D:\04_DevicesTools\mysql-5.7.33-winx64\
datadir=D:\04_DevicesTools\mysql-5.7.33-winx64\data\
port=3306
#skip-grant-tables

9.再次登陆mysql。
mysql -u root -p123456

D:\04_DevicesTools\mysql-5.7.33-winx64\bin>mysql -u root -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.33 MySQL Community Server (GPL)

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.

注意：
net命令失效的原因 环境变量中这个删掉了

参考链接 https://www.kuangstudy.com/bbs/1362588667884941314