内容仅作生活记录,请随意参考
安装过程网上一大堆就不叙述了
打开cmd命令框 mysql -u root -p 登录,输入安装mysql初始化后给的初始密码xxxx
当我登录进去后,想做其他操作发现给了一个错误提示You must reset your password using ALTER USER statement before executing this statement.
才想起初始密码需要改,这个只是相当于临时密码而已
然后我就以前的方式 set password = password('新密码');
发现会报错: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('xxxx')' at line 1
顿时觉得很奇怪???
然后查阅了一下资料,发现mysql8.0的策略和语法什么的都改了
现在修改密码的命令是:ALTER USER ‘root'@‘localhost' IDENTIFIED WITH mysql_native_password BY ‘新密码';
这样就可以修改成功了!!!!