mysql安装（windows x64）

换电脑重装了下环境，这里记录下以备查询。
mysql 8.0.20+不需要手动建立my.ini和datadir，管理员运行cmd（非管理员可能遇到一些问题），进入mysql\bin下。
执行命令mysqld --initialize --console
这里可能会报错

这个是缺微软常见运行库，如截止2019年7月提取码：rr0h
也可以去网上找比较新的运行库。

D:\file\environment\mysql-8.0.23-winx64\bin>mysqld --initialize --console
2021-02-02T09:08:08.712536Z 0 [System] [MY-013169] [Server] D:\file\environment\mysql-8.0.23-winx64\bin\mysqld.exe (mysqld 8.0.23) initializing of server in progress as process 19160
2021-02-02T09:08:08.714056Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2021-02-02T09:08:08.714066Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\file\environment\mysql-8.0.23-winx64\data\ is unusable. You can remove all files that the server added to it.
2021-02-02T09:08:08.725711Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T09:08:08.727251Z 0 [System] [MY-010910] [Server] D:\file\environment\mysql-8.0.23-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
#出现上面这条把data目录清空
D:\file\environment\mysql-8.0.23-winx64\bin>mysqld --initialize --console
2021-02-02T09:10:02.553520Z 0 [System] [MY-013169] [Server] D:\file\environment\mysql-8.0.23-winx64\bin\mysqld.exe (mysqld 8.0.23) initializing of server in progress as process 6888
2021-02-02T09:10:02.604356Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T09:10:03.394719Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-02-02T09:10:04.965305Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: eqTQbRo;l5qb
#到这一步讲localhost:后面的临时密码记一下，后面登录要用到
D:\file\environment\mysql-8.0.23-winx64\bin>mysqld --install
Service successfully installed.

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


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

D:\file\environment\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 11
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 '这里输你要改的密码';
Query OK, 0 rows affected (0.07 sec)

mysql> exit;
Bye

D:\file\environment\mysql-8.0.23-winx64\bin>

navicat

navicat15可以直接官网下或者下面的链接里也有
破解文件和navicat15链接提取码：xzyq

安装流程

请务必按照流程进行

1.安装navicat，但是不要打开（不然可能在生成激活码时候会报rsa public key not found的错

2.打开keygen，先点patch（应该是自动找到的，提示cracked！成功；

3.点生成秘钥生成序列号的生成按钮

4.出现序列码后打开navicat激活界面贴上

5.在弹出窗口点手动激活，把请求码贴到keygen中，然后生成激活码，贴到navicat激活框中，完毕。