网上搜索了几种修改密码的方式都报错
进入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';
这样就密码修改成功!
具体如下图: