一、安装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