嘗試修改了MySQL的datadir參數(shù), 同時將數(shù)據(jù)文件拷貝到了新的目錄/data下, 但是啟動mysql服務(wù)時,提示:
成都創(chuàng)新互聯(lián)主營秀山土家族苗族網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,重慶App定制開發(fā),秀山土家族苗族h5重慶小程序開發(fā)公司搭建,秀山土家族苗族網(wǎng)站營銷推廣歡迎秀山土家族苗族等地區(qū)企業(yè)咨詢
[root@mysql8-01 data]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2019-07-03 10:42:07 CST; 14s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 2907 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 2885 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 2907 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Error: 13 (Permission denied)
Jul 03 10:42:06 mysql8-01 systemd[1]: Starting MySQL Server...
Jul 03 10:42:07 mysql8-01 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Jul 03 10:42:07 mysql8-01 systemd[1]: Failed to start MySQL Server.
Jul 03 10:42:07 mysql8-01 systemd[1]: Unit mysqld.service entered failed state.
Jul 03 10:42:07 mysql8-01 systemd[1]: mysqld.service failed.
查看mysql日志,發(fā)現(xiàn)有如下警告
2019-07-03T02:38:28.679543Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.14) MySQL Community Server - GPL.
mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2019-07-03T02:40:21.848131Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql8-01.lower-test
2019-07-03T02:40:21.848279Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.14) starting as process 2822
2019-07-03T02:40:21.867130Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql8-01.lower-test
2019-07-03T02:40:21.867181Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /data/ is case insensitive
2019-07-03T02:40:21.868211Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-07-03T02:40:21.868431Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.14) MySQL Community Server - GPL.
mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2019-07-03T02:42:07.555956Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql8-01.lower-test
2019-07-03T02:42:07.556036Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.14) starting as process 2907
2019-07-03T02:42:07.558851Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql8-01.lower-test
2019-07-03T02:42:07.558865Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /data/ is case insensitive
2019-07-03T02:42:07.559679Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-07-03T02:42:07.559877Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.14) MySQL Community Server - GPL.
這里,需要將Selinux關(guān)閉:
[root@mysql8-01 data]# vi /etc/selinux/config
[root@mysql8-01 data]#
[root@mysql8-01 data]# setenforcing 0
bash: setenforcing: command not found...
[root@mysql8-01 data]# setenforce 0
[root@mysql8-01 data]#
[root@mysql8-01 data]#
[root@mysql8-01 data]# systemctl start mysqld
[root@mysql8-01 data]#
[root@mysql8-01 data]#
[root@mysql8-01 data]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2019-07-03 10:46:09 CST; 5s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 3020 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 3042 (mysqld)
Status: "SERVER_OPERATING"
CGroup: /system.slice/mysqld.service
└─3042 /usr/sbin/mysqld
Jul 03 10:46:06 mysql8-01 systemd[1]: Starting MySQL Server...
Jul 03 10:46:09 mysql8-01 systemd[1]: Started MySQL Server.
再此嘗試啟動,成功
網(wǎng)站標(biāo)題:CentOS7下mysql8修改datadir之后不能啟動
網(wǎng)站地址:http://bm7419.com/article8/jcgoip.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供品牌網(wǎng)站設(shè)計、企業(yè)網(wǎng)站制作、手機(jī)網(wǎng)站建設(shè)、、移動網(wǎng)站建設(shè)、Google
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)