can't start my sql [closed]
(fixed layout)
[fsze88hoho@localhost ~]$ systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor pres>
Active: failed (Result: exit-code) since Sat 2019-01-19 12:44:45 HKT; 9s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 13642 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1>
Process: 13617 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=>
Main PID: 13642 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Error: 2 (No such file or directory)
Jan 19 12:44:41 localhost.localdomain systemd[1]: Starting MySQL Server...
Jan 19 12:44:45 localhost.localdomain systemd[1]: mysqld.service: Main process >
Jan 19 12:44:45 localhost.localdomain systemd[1]: mysqld.service: Failed with r>
Jan 19 12:44:45 localhost.localdomain systemd[1]: Failed to start MySQL Server.
anyone can help!!!!?????
It is a bit hard to read. If you indent each line of the output with 4 spaces (Markdown markup for code snippets) it will make it easier to read.
The main thing that looks suspicious is the "No such file or directory" comment. Based on https://forums.mysql.com/read.php?11,665874,665874#msg-665874 it sounds like your data directory may not be accessible by mysql. That post also suggests how to look at the logs to see what is going on. They mention SELinux as well, though, turning it off SELinux may be unnecessary (see https://www.thegeekstuff.com/2016/05/move-mysql-directory/).