环境安装2023-06-30
2023-06-29 本文已影响0人
dataHunter
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
