mysql 8安装 + navicat链接
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激活框中,完毕。
日积月累,水滴石穿