【MYSQL】修改密码时报错解决方案

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe

一、进入mysql命令行:

./bin/mysql -uroot -h 127.0.0.1 -p

或 ./bin/mysql -uroot -h localhost -p

二、flush privileges;

三、ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘重置的密码’;