MySQL数据库的下载与安装-优快云博客

本文介绍如何安装MySQL并设置初始密码，以及解决使用Navicat for MySQL客户端时遇到的caching-sha2-password错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、安装MySQL

参考链接：

https://blog.youkuaiyun.com/weixin_40396510/article/details/79277731

1.设置MySQL密码

Microsoft Windows [版本 10.0.17134.285]
(c) 2018 Microsoft Corporation。保留所有权利。

C:\WINDOWS\system32>cd E:\MySQL\zip\mysql-8.0.12-winx64\bin

C:\WINDOWS\system32>e:

E:\MySQL\zip\mysql-8.0.12-winx64\bin>cd E:\MySQL\zip\mysql-8.0.12-winx64\bin

E:\MySQL\zip\mysql-8.0.12-winx64\bin>net start mysql
请求的服务已经启动。

请键入 NET HELPMSG 2182 以获得更多的帮助。


E:\MySQL\zip\mysql-8.0.12-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.12

Copyright (c) 2000, 2018, 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 user() identified by "123456";
Query OK, 0 rows affected (0.22 sec)

mysql>

注：新版本用以下命令重设密码：

alter user user() identified by "新密码";

二、连接Navicat for MySQL客户端

1.客户端登录报caching-sha2-password错误。
参考链接：https://blog.youkuaiyun.com/ziyifengfei/article/details/80668562