update mysql.user set password('123456') where user='root';
updatemysql.usersetpassword('123')whereuser('root');ERROR1064(42000):Youhaveanerrorin...
update mysql.user set password ('123') where user('root');
ERROR 1064 (42000): 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 '('123') where user('root')' at line 1
为啥还会报错 展开
ERROR 1064 (42000): 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 '('123') where user('root')' at line 1
为啥还会报错 展开
展开全部
正常的语句如下：请检查是否列user是否开头是大写
update user set password=password('123456') where User='root' and Host='127.0.0.1';
update user set password=password('123456') where User='root' and Host='127.0.0.1';
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
