mysql更改密码报错
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
执行刷新语句:flush privileges;
忘记mysql 密码
到/etc/my.cfg里 加入skip-grant-tables=1, 然后重启服务, systemctl restart mysqld
停止firewall
systemctl stop firewalld.service