linux上解决Mysql登录问题
分析问题可能出现的原因:1.mysql启动时找不到Socket 需要在 /etc/my.cnf 中配置socket文件位置位置因为我配置过了socket所以问题不出现在此:继续寻找:想要重启一下mysqld 看看是不是就能回复了service mysqld restart[root@node0 ~]# service mysqld restartRestarting mysqld (via sys
分析问题可能出现的原因:
1.mysql启动时找不到Socket 需要在 /etc/my.cnf 中配置socket文件位置位置
因为我配置过了socket所以问题不出现在此:
继续寻找:
想要重启一下mysqld 看看是不是就能回复了
service mysqld restart
[root@node0 ~]# service mysqld restart
Restarting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
出现问题
[root@node0 ~]# systemctl status mysqld.service
● mysqld.service - SYSV: MySQL database server.
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
Active: failed (Result: exit-code) since 日 2022-03-20 21:42:33 CST; 10s ago
Docs: man:systemd-sysv-generator(8)
Process: 1481 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)3月 20 21:42:32 node0 systemd[1]: Starting SYSV: MySQL database server....
3月 20 21:42:33 node0 mysqld[1481]: MySQL Daemon failed to start.
3月 20 21:42:33 node0 mysqld[1481]: Starting mysqld: [失败]
3月 20 21:42:33 node0 systemd[1]: mysqld.service: control process exited, code=exited status=1
3月 20 21:42:33 node0 systemd[1]: Failed to start SYSV: MySQL database server..
3月 20 21:42:33 node0 systemd[1]: Unit mysqld.service entered failed state.
3月 20 21:42:33 node0 systemd[1]: mysqld.service failed.
查看mysql.log
/var/log/mysqld.log
2022-03-20T12:47:49.951230Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)
2022-03-20T12:47:49.951238Z 0 [ERROR] Can't start server: can't create PID file: No such file or directory
解决
mkdir -p /var/run/mysqld/
chown mysql.mysql /var/run/mysqld/service mysqld restart
登录又出现问题了 明明密码和用户名都对就是死活登录不上去
然后就去各种想办法 看看到底是删了重新安装还是说继续解决下去 毕竟都到这步了
跳过安全
mysqld_safe --skip-grant-tables
打开另一个客户端 连接mysql 进行密码的修改mysql -uroot
use mysql
update user set authentication_string=password('281956') , host='#' where user='root';
flush privileges;
退出mysql
再重新启动即可
service mysqld restart
更多推荐
所有评论(0)