mysql
chuxiasama
孤独才是人生常态
展开
-
naivecat连接mysql8.0.11 报错 1251-client does not support authentication protocol
1.在cmd登录mysql2.ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';FLUSH PRIVILEGES; ...原创 2019-07-01 19:01:15 · 486 阅读 · 0 评论 -
Windows下安装Mysql 8.0.16出现登录失败的解决方法
1.安装mysql,官网下载。2.将下载的文件解压,Bin目录加入环境变量。3.在cmd下执行下列命令net stop mysqlmysqld --shared-memory --skip-grant-tables4.在新cmd窗口执行mysql5.在mysql窗口执行FLUSH PRIVILEGES;ALTER USER ‘root’@’localhost...原创 2019-06-28 10:53:07 · 750 阅读 · 0 评论