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’......
阅读全文