美文网首页
环境安装2023-06-30

环境安装2023-06-30

作者: dataHunter | 来源:发表于2023-06-29 23:19 被阅读0次

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

相关文章

网友评论

      本文标题:环境安装2023-06-30

      本文链接:https://www.haomeiwen.com/subject/uelzydtx.html