安装mysql教程
1. 下载安装包选择社区版的
2. 安装包打开后,选择自定义的
3. 配置环境变量
4.查看安装的版本号
5.用CMD登陆mysql
教程网址:https://www.bilibili.com/video/BV1dA411M7q1/?spm_id_from=333.788.recommend_more_video.0
6.问题:1251 client does not support ...
解决步骤:
(1)查看用户信息
select host,user,plugin,authentication_string from mysql.user;
(2)修改用户密码
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