今天在实验室连了半天mysql,枯了~~
使用Navicat for MySQL工具,创建连接,连接名可填可不填
但是连接出现 1251Client does not support authentication protocol requested by server
即客户端不支持服务器请求的身份验证协议
解决办法是修改用户名密码(请直接粘贴,防止打错= =):
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
更新user为root,host为% 的密码为123456
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
更新user为root,host为localhost 的密码为123456
连接成功!