做完了資料備份恢復就這樣了。
1.selinux已關閉
2.已經重新chown mysql：mysql /var/lib/mysql
3.組態檔/etcmy.cnf
[mysqld]
server_id=1
log-bin-index=mysql-bin
log-bin
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.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[root@10 var]# systemctl status mysqld
mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start-pre) since 二 2017-10-24 23:13:50 EDT; 11ms ago
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
control
17195 /usr/lib/systemd/systemd --switched-root --system --deserialize 21
10月 24 23:13:50 10.example.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
10月 24 23:13:50 10.example.com systemd[1]: Starting MySQL Server...
[root@10 var]# journalctl -xe
--
-- The result is failed.
10月 24 23:14:02 10.example.com systemd[1]: Unit mysqld.service entered failed state.
10月 24 23:14:02 10.example.com systemd[1]: mysqld.service failed.
10月 24 23:14:02 10.example.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
10月 24 23:14:02 10.example.com systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
10月 24 23:14:03 10.example.com mysqld[17424]: Initialization of mysqld failed: 0
10月 24 23:14:03 10.example.com systemd[1]: mysqld.service: control process exited, code=exited status=1
10月 24 23:14:05 10.example.com systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
10月 24 23:14:05 10.example.com systemd[1]: Unit mysqld.service entered failed state.
10月 24 23:14:05 10.example.com systemd[1]: mysqld.service failed.
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/108006.html
標籤：MySQL
下一篇：DEAP2.1