MYSQL密码丢失重置root密码_journal has been rotated since unit was started. l

作者：IT小白 | 2024-02-19 14:28:32

踩

journal has been rotated since unit was started. log output is incomplete or

一、首先关闭服务并查看服务状态
[root@dw-pd-app ~]# systemctl stop mysqld
[root@dw-pd-app ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disa bled)
Active: inactive (dead) since Tue 2020-12-08 18:38:07 CST; 4s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 2569 (code=exited, status=0/SUCCESS)

Dec 08 18:38:02 dw-pd-app systemd[1]: Stopping MySQL Server…
Dec 08 18:38:07 dw-pd-app systemd[1]: Stopped MySQL Server.
Warning: Journal has been rotated since unit was started. Log output is incomplete or u navailable.
二、编辑配置文件添加参数使无密码登录成效并重启服务
[root@dw-pd-app ~]# vi /etc/my.cnf
下最后
添加skip_grant_tables 一行，然后qw保存退出
[root@dw-pd-app ~]# systemctl start mysqld
[root@dw-pd-app ~]# systemctl status mysqld

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/IT小白/article/detail/115233