MySQL在root下修改密码报错：ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that co_mysqladmin -uroot -p1234 password root ; error 106-CSDN博客网友收藏

MySQL在root下修改密码报错：ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that co_mysqladmin -uroot -p1234 password root ; error 106-CSDN博客

文章浏览阅读4.8k次，点赞4次，收藏7次。报错：报错原因：新版本MySQL（8.0以上）不支持使用SET PASSWORD FOR ‘username’@‘hostname’ = PASSWORD (‘newpwd’);来修改用户密码。解决方法：alter user’username’@‘hostname’ identified by ‘newpwd’......
2024-01-23 00:16 评论 0 阅读
阅读全文