CentOS7下mysql8修改datadir之后不能啟動(dòng)-創(chuàng)新互聯(lián)

嘗試修改了mysql的datadir參數(shù)， 同時(shí)將數(shù)據(jù)文件拷貝到了新的目錄/data下， 但是啟動(dòng)mysql服務(wù)時(shí)，提示：

創(chuàng)新互聯(lián)建站-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設(shè)、高性價(jià)比皋蘭網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫(kù),直接使用。一站式皋蘭網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設(shè)找我們，業(yè)務(wù)覆蓋皋蘭地區(qū)。費(fèi)用合理售后完善，十年實(shí)體公司更值得信賴。

[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)

           /tupian/20230522/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)

           /tupian/20230522/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.

再此嘗試啟動(dòng)，成功

分享文章：CentOS7下mysql8修改datadir之后不能啟動(dòng)-創(chuàng)新互聯(lián)
文章URL：http://www.muchs.cn/article22/pcgcc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)網(wǎng)站制作、企業(yè)建站、網(wǎng)站策劃、網(wǎng)站改版、ChatGPT、品牌網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)