度娘也不給力，只好自己研究了。

先把結(jié)論寫出來吧。把pid文件換個(gè)位置，就好了。

問題是， mysqld.servce的文件是從mysql的安裝目錄拷貝的，導(dǎo)致沒有懷疑pid文件位置的問題。一開始還懷疑是不是自己在一些文件里拼寫有誤。

后來，偶然發(fā)現(xiàn)，/var下面的run并不是一個(gè)實(shí)際的目錄(鏈接到 /run)。關(guān)鍵地方是，用 df 命令查看，/run目錄的是 tmpfs的。

# df

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/vda1 41152832 10103228 28936120 26% /

devtmpfs 498860 0 498860 0% /dev

tmpfs 131072 0 131072 0% /dev/shm

tmpfs 508196 324 507872 1% /run

tmpfs 508196 0 508196 0% /sys/fs/cgroup

tmpfs 101640 0 101640 0% /run/user/0

說明：編譯之后的目錄中 /usr/local/mysql/usr/lib/systemd/system/mysqld.service 拷貝到/usr/lib/systemd/system/mysqld.service

(這里提一下，另一個(gè)事，根本問題沒啥關(guān)系。原來的根目錄下的一些目錄，都挪到了 /usr 下了。從哪個(gè)版本起，我記不住了。)

先說解決的步驟，隨后貼上有關(guān)問題。

1，修改 mysqld.service 中的pid文件的位置(2處)。比如放置到mysqld的運(yùn)行目錄(不用重新 chown了)，創(chuàng)建方法略。

2，運(yùn)行 systemctl daemon-reload

3， systemctl start mysqld 。

4，reboot系統(tǒng)后，驗(yàn)證 問題解決。

如果沒有步驟2，提示：

# systemctl start mysqld

Warning: mysqld.service changed on disk. Run 'systemctl daemon-reload' to reload units.

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

有問題時(shí)：

# systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: failed (Result: start-limit) since Sat 2017-07-15 22:58:50 CST; 37s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Jul 15 22:58:50 jlsky systemd[1]: mysqld.service: control process exited, code=exited status=1

Jul 15 22:58:50 jlsky systemd[1]: Failed to start MySQL Server.

Jul 15 22:58:50 jlsky systemd[1]: Unit mysqld.service entered failed state.

Jul 15 22:58:50 jlsky systemd[1]: mysqld.service failed.

Jul 15 22:58:50 jlsky systemd[1]: mysqld.service holdoff time over, scheduling restart.

Jul 15 22:58:50 jlsky systemd[1]: start request repeated too quickly for mysqld.service

Jul 15 22:58:50 jlsky systemd[1]: Failed to start MySQL Server.

Jul 15 22:58:50 jlsky systemd[1]: Unit mysqld.service entered failed state.

Jul 15 22:58:50 jlsky systemd[1]: mysqld.service failed.

問題解決后：

# systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since Sat 2017-07-15 23:03:18 CST; 1min 18s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Main PID: 1503 (mysqld)

CGroup: /system.slice/mysqld.service

└─1503 /usr/local/mysql/bin/mysqld --daemonize --pid-file=/usr/local/mysql/mysqld.pid

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.495016Z 0 [Note] IPv6 is available.

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.495025Z 0 [Note] - '::' resolves to '::';

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.495043Z 0 [Note] Server socket created on IP: '::'.

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.775356Z 0 [Note] Event Scheduler: Loaded 0 events

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.823217Z 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: Version: '5.7.18' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.823232Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a l...is check.

Jul 15 23:03:17 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:17.823234Z 0 [Note] Beginning of list of non-natively partitioned tables

Jul 15 23:03:18 izj6c2quobtad9dwb7gspkz mysqld[887]: 2017-07-15T15:03:18.108745Z 0 [Note] End of list of non-natively partitioned tables

Jul 15 23:03:18 izj6c2quobtad9dwb7gspkz systemd[1]: Started MySQL Server.

Hint: Some lines were ellipsized, use -l to show in full.

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的reboot mysql fail_mysql 5.7.18，在系统重启后，为什么无法启动？的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。