![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
C_TestMG
分享自动化测试、功能测试、性能测试三类文章、测试所需环境搭建等资源,还包括一些书籍文章的读后感、以及一些笔记
展开
-
ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
D:\TestSoftware\mysql5731>cd binD:\TestSoftware\mysql5731\bin>mysql -uroot -pEnter password: ****Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.31 MySQL Community Server (GPL)Copyrig.原创 2020-09-02 15:58:21 · 1083 阅读 · 0 评论 -
Navicat MySQL 连接出现 Authentication plugin ‘caching_sha2_password‘ cannot be loaded
1、进入mysql ,密码输入当前密码mysql -u root -p2、修改账户密码加密规则并更新用户密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "root";ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';3、刷新权限,重置密码FLUSH PRIVILEGES;转载 2020-08-29 15:01:52 · 122 阅读 · 0 评论