网上搜索了几种修改密码的方式都报错
进入mysql后修改密码失败情况：
1.输入：update user set password=password('123456') where user='root' and host='localhost';
报错：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 ‘(“123456”) where user=“root”’ at line 1
2丶set password for root@localhost = password(‘123456’);
但是我依旧没有修改成功，报错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 ‘(“123456”) where user=“root”’ at line 1
3.输入：ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
也没有任何反应
修改成功的情况：
4.先输入：flush privileges;
再输入：ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';
这样就密码修改成功！
具体如下图：
