Question

mysql> use mysql; Database changed mysql> updata user set password='1234' where user='root';

mysql> use mysql;
Database changed
mysql> updata user set password='1234' 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 'updat
a user set password='1234' where user='root'' at line 1

mysql> updata users set password='1234' 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 'updat
a users set password='1234' where user='root'' at line 1
mysql>

Answer 1

语法错误，应该这样写：
mysql>update user set password=password("new_pass") where user="root";
你的少了一个password加密函数。
谢谢！

追问

updata user set password=passworld('1234') where user='root'; 也错了啊

追答

你追问的命令是你复制的吗 ？是不是你的update写错误了啊

update user set password=password("new_pass") where user="root";
参考下面的文章看看

参考资料： http://blog.sina.com.cn/s/blog_a6dcb5bd01016vms.html

Answer 2

更新语句的命令是 UPDATE
不是 updata

拼写错误啊.

MySQL

修改当前登录用户的密码： （也就是修改自己的密码）

mysql> SET PASSWORD = PASSWORD('test');
Query OK, 0 rows affected (0.00 sec)

mysql> select host, user, password from mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | |
| localhost | | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+-----------+------+-------------------------------------------+
2 rows in set (0.00 sec)

要想更改已有账户的密码，使用UPDATE来设置Password列值：

shell> mysql -u root mysql
mysql> UPDATE user SET Password = PASSWORD('bagel')
-> WHERE Host = '%' AND User = 'francis';
mysql> FLUSH PRIVILEGES;

Answer 3

updata user set password='1234' where user='root';

改成

update user set password='1234' where user='root';

或者
update user set password=old_password('1234') where user='root';

或者
update user set password=password('1234') where user='root';

Answer 4

亲是update 不是updata啊

Answer 5

update 不是updata