将下载的安装包解压到C盘:C:\mysql-8.0.11-winx64
以管理员身份打开 cmd 命令行工具,切换目录:
进入bin目录:
C:\WINDOWS\system32>cd /d C:\mysql-8.0.11-winx64\bin
初始化数据库:
C:\mysql-8.0.11-winx64\bin>mysqld --initialize --console
执行完成后,会输出 root 用户的初始默认密码,如:
2020-02-15T13:36:17.585717Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 15868
2020-02-15T13:36:37.744981Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: gaFsyzY=i5i=
2020-02-15T13:36:55.209115Z 0 [System] [MY-013170] [Server] C:\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed
输入以下安装命令:
C:\mysql-8.0.11-winx64\bin>mysqld install
启动MySQL服务:
C:\mysql-8.0.11-winx64\bin>net start mysql
登录 MySQL
如果我们要登录本机的 MySQL 数据库,只需要输入以下命令即可:
C:\mysql-8.0.11-winx64\bin>mysql -u root -p
按回车确认, 如果安装正确且 MySQL 正在运行, 会得到以下响应:输入初始化得到的密码
Enter password:
修改root密码:
mysql> alter user 'root'@'localhost' identified by '123456';
#现在密码已经改为:123456
此时Navicat最新版是可以连接上数据库的,但是Node.js,和Navicat老版本是连不上的:
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
参考:https://blog.csdn.net/tcllxxl/article/details/95235104
修改加密规则为普通加密规则:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
更新用户密码:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
刷新权限
mysql> FLUSH PRIVILEGES;
现在Node.js ,Navicat老版本就可以登录了。
删除服务:先停止服务
sc delete mysql