mysql> use mysql;
Database changed
mysql> update user set password=password('123456') where user='root';
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql>
求解!!
Database changed
mysql> update user set password=password('123456') where user='root';
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql>
求解!!
你 这样:desc user;然后看看这个表里的密码字段是怎么写的 ,好像是 Password
update user set authentication_string=password('1234') where user='root';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
SET PASSWORD [FOR user] = password_optionpassword_option: {
PASSWORD('auth_string')
| 'auth_string'
}
很明显没有password column
5.7版本已经没有PASSWORD 字段了 改为了authentication_string
authentication_string=password('xxx')
5.5以下才有PASSWORD 字段了
要看你mysql版本 大不了你select * from user ; 不就知道了吗