【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 ‘重置的密碼’;