MySQL免安装版的配置

1.去官网下载mysql

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

2.点开官网后，看下面两张图，下载下来就行了，是个压缩包

 

 3.用管理员角色打开命令运行窗，就是平时用的win+R快捷键出来的那个黑色窗口

相关的指令都在下面窗口中了，大家可以做个参考

Microsoft Windows [版本 10.0.19041.867]
(c) 2020 Microsoft Corporation. 保留所有权利。

C:\Windows\system32>D:

D:\>cd mysql-8.0.23-winx64

D:\mysql-8.0.23-winx64>cd bin

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

D:\mysql-8.0.23-winx64\bin>mysqld --initialize --console
2021-04-02T13:15:43.958720Z 0 [System] [MY-013169] [Server] D:\mysql-8.0.23-winx64\bin\mysqld.exe (mysqld 8.0.23) initializing of server in progress as process 16708
2021-04-02T13:15:43.988760Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-02T13:15:45.061827Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-02T13:15:46.910630Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: oM29YpRPIy.<

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


D:\mysql-8.0.23-winx64\bin>mysql -u root -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

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

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> alter user 'root'@'localhost' identified by 'root'
    -> ;
Query OK, 0 rows affected (0.04 sec)

mysql> quit
Bye

D:\mysql-8.0.23-winx64\bin>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.23 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>