Home > database >  Can't start the mysql service?
Can't start the mysql service?

Time:10-03

Finished the data backup to restore that's it.
1. The selinux closed
2. Have to chown mysql: mysql/var/lib/mysql
3. The configuration file/etcmy. CNF
[mysqld]
Server_id=1
The log - bin - index=mysql - bin
The log - bin
The log - bin=/logdir db10
Binlog_format="mixed"
Binlog_format="STATEMENT"
Skip - grant - tables
Default - storage - engine=myisam
Secure_file_priv="/var/lib/mysql"
Validate_password_policy=0
/root 10 var @ # systemctl restart mysqld
Job for mysqld. The service failed because the control process exited with an error code. See "systemctl status mysqld. Service" and "journalctl - xe" for details.
/root 10 var @ # systemctl status mysqld
Mysqld. Service - MySQL Server
The Loaded: the Loaded (/usr/lib/systemd/system/mysqld. Service; Enabled. Vendor preset: disabled)
Active: activating (start - pre) since 2017-10-24 for 23:13:50 EDT. 11 ms line
Docs: man: mysqld (8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 17163 ExecStart=/usr/sbin/mysqld - daemonize - pid - file=/var/run/mysqld/mysqld. Pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Control: 17195 (systemd)
CGroup:/system. Slice/mysqld. Service
The control
17195/usr/lib/systemd/systemd - switched - root - system - deserialize 21

On October 24 23:13:50 10. example.com systemd [1] : mysqld. Service holdoff time over, the scheduling restart.
On October 24 23:13:50 10. example.com systemd [1] : Starting MySQL Server...
/root 10 var @ # journalctl - xe
-
- The result is failed.
On October 24 23:14:02 10. example.com systemd [1] : Unit mysqld. Service rose failed state.
On October 24 23:14:02 10. example.com systemd [1] : mysqld. The service failed.
On October 24 23:14:02 10. example.com systemd [1] : mysqld. Service holdoff time over, the scheduling restart.
On October 24 23:14:02 10. example.com systemd [1] : Starting MySQL Server...
Subject: Unit mysqld. Service has begun the start - up
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
- the Unit mysqld. Service has begun starting up.
On October 24 23:14:03 10. example.com mysqld [17424] : the Initialization of mysqld failed: 0
On October 24 23:14:03 10. example.com systemd [1] : mysqld. Service: control the process exited, code=exited the status=1
On October 24 23:14:05 10. example.com systemd [1] : Failed to start the MySQL Server.
Subject: Unit mysqld. Service has failed
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
- the Unit mysqld. Service has failed.
-
- The result is failed.
On October 24 23:14:05 10. example.com systemd [1] : Unit mysqld. Service rose failed state.
On October 24 23:14:05 10. example.com systemd [1] : mysqld. The service failed.
  • Related