mysql 8 zip版安装指南

1.配置

https://www.jb51.net/article/139277.htm

2.异常处理

1）net start mysql 发生系统错误2

C:\Windows\system32>cd ../..

C:\>cd Program Files\MySQL\MySQL Server 5.6\bin

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --remove

Service successfully removed.

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --install

Service successfully installed.

C:\Program Files\MySQL\MySQL Server 5.6\bin>net start mysql

MySQL 服务正在启动 .

MySQL 服务已经启动成功。

3.navicat安装

1）下载安装：https://blog.csdn.net/a599174211/article/details/82795658

2）Navicat连接Mysql报错：Client does not support authentication protocol requested by server；

    命令行登陆mysql ,执行命令如下：

        1、use mysql;

        2、alter user 'root'@'localhost' identified with mysql_native_password by '********';

        3、flush privileges;

        https://www.cnblogs.com/zichuan/p/9203129.html