MySql本地安装+navicat8 快捷键

mysql下载官网地址：https://downloads.mysql.com/archives/community/

1-解压后放置C盘根目录

2-开始安装

C:\Windows\system32>cd C:\mysql8023\bin #管理员身份进入，安装服务mysqld --install C:\mysql8023\bin>mysqld --install Service successfully installed. #初始化mysqld --initialize --console C:\mysql8023\bin>mysqld --initialize --console 2021-02-20T17:04:59.269581Z 0 [System] [MY-013169] [Server] C:\mysql8023\bin\mysqld.exe (mysqld 8.0.23) initializing of server in progress as process 19884 2021-02-20T17:04:59.281773Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-02-20T17:04:59.596638Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-02-20T17:05:00.196226Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Rf=eHlZrd2sg

获取随机密码：Rf=eHlZrd2sg

启动服务：net start MySQL

登录验证：mysql -u root -p

修改密码：alter user 'root'@'localhost' identified by 'root';

解决方案

1-以管理员权限运行cmd程序然后输入net stop mysql

2-cmd中运行mysqld –skip-grant-tables，实测在mysql8.0中已失效，现使用mysqld --console --skip-grant-tables --shared-memory

3-无密登录

cmd窗口，输入mysql -u root -p，然后回车，再回车（不输入密码），直接无密登录

4-修改密码

#把密码设置为空： UPDATE mysql.user SET authentication_string='' WHERE user='root' and host='localhost'; #查看USER表： select host,user,plugin,authentication_string from mysql.user; #以caching_sha2_password加密方式设置密码修改密码： ALTER user 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '123456'; #刷新： flush privileges;

5-重新登录

以管理员权限运行cmd程序，再执行net start mysql。在MySQL服务开启成功之后，输入mysql -u root -p然后在输入密码，成功登录MySQL。

6-客户端工具：navicat8lite_mysql_cs