linux上安装mysql 5.7.22

sudo  mysql -u root mysql  #新开一个终端窗口,执行改命令,免密码登录root用户

mysql> use mysql;  #切换至mysql的database(注意以分号结束每条语句)

Database changed

mysql> update user set password=password("*******") where user="*******";  #修改密码报错
ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
mysql> update mysql.user set authentication_string=password(‘*******‘) where user=‘*******‘;  #修改密码成功
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> flush privileges;  #立即生效
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

linux上安装mysql 5.7.22

标签：图片   ini   update   set   err   oca   com   www   mic