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博客

网友收藏2024-01-23 00:16

链接地址：https://blog.csdn.net/weixin_42210824/article/details/107974734
链接标题：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博客
所属网站：blog.csdn.net
被收藏次数：8514

文章浏览阅读4.8k次，点赞4次，收藏7次。报错：报错原因：新版本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’;或者(修_mysqladmin -uroot -p1234 password root ; error 1064 (42000): you have an err

本文地址：https://tebull.com/detail/491029.html

标签：mysqladmin -uroot -p1234 password root ; error 1064 (42000): you have an err