1、解压MySQL5.7版本
2、管理员权限运行cmd:
3、进入MySQL的bin文件夹
C:\Windows\system32>cd C:\mysql-5.7.39-winx64\bin
4、依次运行
mysqld --initialize --console
(初始化MySQL,添加console的意思是把初始化的信息打印到控制台及cmd里上显示出来,因为打印的密码后面登录需要用到)
mysqld --install mysql
(安装MySQL)
net start mysql
(启动MySQL)
mysql -uroot -p
(进入MySQL)
set password = password('1234');
(修改密码为1234)
5、打开Navicat,进行连接,结束。
下面是我具体安装的操作,以及遇到的问题:
Microsoft Windows [版本 10.0.19043.1237]
(c) Microsoft Corporation。保留所有权利。
C:\Windows\system32>cd C:\mysql-5.7.39-winx64\bin
C:\mysql-5.7.39-winx64\bin>mysqld --initialize --console
2022-11-09T16:41:20.974841Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-11-09T16:41:21.403543Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2022-11-09T16:41:21.404327Z 0 [ERROR] Aborting
C:\mysql-5.7.39-winx64\bin>mysqld --initialize --console
2022-11-09T16:41:37.149903Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-11-09T16:41:37.154354Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2022-11-09T16:41:37.155040Z 0 [ERROR] Aborting
C:\mysql-5.7.39-winx64\bin>
C:\mysql-5.7.39-winx64\bin>mysqld --install mysql
Service successfully installed.
(安装时提示缺少dll,按照提示安装,再删除MySQL重新安装)
C:\mysql-5.7.39-winx64\bin>mysqld remove mysql
Service successfully removed.
(卸载成功后记得删除初始化的data文件夹)
C:\mysql-5.7.39-winx64\bin>mysqld --initialize --console
2022-11-09T16:42:23.158118Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-11-09T16:42:24.043328Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-11-09T16:42:24.186906Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-11-09T16:42:24.276398Z 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: 7ce93326-604d-11ed-98e6-16faa753ab5f.
2022-11-09T16:42:24.279678Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-11-09T16:42:25.898206Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-11-09T16:42:25.898739Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-11-09T16:42:25.900067Z 0 [Warning] CA certificate ca.pem is self signed.
2022-11-09T16:42:26.413572Z 1 [Note] A temporary password is generated for root@localhost: Xh9%/RbKjtkk(密码记住)
C:\mysql-5.7.39-winx64\bin>mysqld --install mysql
Service successfully installed.
C:\mysql-5.7.39-winx64\bin>net start mysql
mysql 服务正在启动 .
mysql 服务已经启动成功。
C:\mysql-5.7.39-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.39
Copyright (c) 2000, 2022, 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>
mysql> set password = password('1234');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql>
PS:初始化完成后,进行安装提示缺少 vcruntime140_1.dll,按照提示下载该dll后,继续安装。
若忘记密码则要删除mysql
进入bin目录运行mysqld remove mysql即可删除,初始化的data文件夹也要删除,然后重新安装即可