MySQL在root下修改密码报错:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that co
报错:报错原因:新版本MySQL(8.0以上)不支持使用SET PASSWORD FOR ‘username’@‘hostname’ = PASSWORD (‘newpwd’);来修改用户密码。解决方法:alter user’username’@‘hostname’ identified by ‘newpwd’;或者alter username’@‘hostname’ identified with mysql_native_password by ‘newpwd’;或者(修
原创
2020-08-13 11:07:11 ·
5286 阅读 ·
0 评论