MySQL Daemon CentOS 6 serverida ishga tusholmadi

SQLD xizmatini ishga tushirishga harakat qilsam, MySQL Daemon ishga tushirilmadi. Men o'zimga xizmatni "ishga tushirishga" harakat qildim:

[[email protected] ~]# service mysqld restart
mysqld stopped:                                            [  OK  ]
MySQL Daemon failed to start.
mysqld started:                                            [FAILED]
[[email protected] ~]#

MySQL xato jurnalida so'nggi kiritilgan ma'lumot hech qanday ma'lumot emas:

170314  3:24:59 [Note] /usr/libexec/mysqld: Normal shutdown

170314  3:24:59 [Note] Event Scheduler: Purging the queue. 0 events
170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 1605619  user: 'admin'

170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 1605617  user: 'admin'
170314  3:25:01 [Warning] /usr/libexec/mysqld: Forcing close of thread 13  user: 'admin'

170314  3:25:06  InnoDB: Starting shutdown...
170314  3:25:08  InnoDB: Waiting for 35 pages to be flushed
170314  3:25:46  InnoDB: Shutdown completed; log sequence number 26624434202
170314  3:25:47 [Note] /usr/libexec/mysqld: Shutdown complete

170314 03:25:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Men MySQL ni safemoda ishga tushirishga harakat qildim

[[email protected] log]# mysqld_safe
170314 09:36:39 mysqld_safe Logging to '/var/log/mysqld.log'.
170314 09:36:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170314 09:36:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[[email protected] log]#

SELinux mening centos maschine ustida o'chirilgan. Menga kim yordam berishi mumkin? EDIT: Kecha tunda hech qanday yangilash yo'q.

1
Serveringiz kecha kecha yangiladimi? Hozirda shunga o'xshash muammolarga duch kelmoqdaman ...
qo'shib qo'ydi muallif Vince Pettit, manba
Yuqoridagi barcha usullar ishlamayotgan bo'lsa, ushbu javobni tekshiring: https://stackoverflow.com/a/45727391/3286605
qo'shib qo'ydi muallif Duc Filan, manba
qo'shib qo'ydi muallif haichao hu, manba

7 javoblar

    yum history

yangilash identifikatorini toping

    yum history undo 

Men bu masalani faqat men oldik va bu men uchun hal qilindi.

2
qo'shib qo'ydi

TIP: It's always a good idea to back up the directory /var/lib/mysql before executing trial commands in case you need to go back to an initial state.

Buyruqni belgilangan javobda bajarganingizdan so'ng sizning mysqld xizmatini ishga tushirmasangiz /var/lib/mysql mysql: MySQL dir.

Agar ular bunday bo'lmasa, quyidagilarni bajarish kerak:

(Men buni CentOS-da qildim, men o'zimning ildiz otib ketgan mulkim bor edi: root).

chown -R mysql:mysql /var/lib/mysql

Shundan keyin xizmati mysqld start nihoyat ishladi.

1
qo'shib qo'ydi

Bu erda https://stackoverflow.com/a/43950190/4778754 saytida ko'rishingiz mumkin. Muammo shundaki, my.con faylida siz o'rnatgan o'lcham va aslida fayl katalogidagi ma'lumotlar hajmi.

1
qo'shib qo'ydi

Ya'ni yumshoq yangilashni boshlaganimdan keyin CentOS serverimda bir xil muammo yuzaga keldi. Menda hech qanday Plesk o'rnatilgan emas, lekin ularning maqolasi https: //support.plesk .com/hc/en-us/articles/115001906725 yordam berdi.

install -m 0700 -o MySQL -g MySQL -d /var/lib/mysql-files

Atom reposidagi MySQL to'plami singan.

1
qo'shib qo'ydi
1
qo'shib qo'ydi

Bu buyruq men uchun ishladi. Ushbu buyruqni ishga tushiring.

sudo service httpd restart
0
qo'shib qo'ydi

Bu muammo Plesk tomonidan buzilgan yangilanish bilan bog'liq.

Iltimos, ushbu maqolani o'qing: https://support.plesk.com/hc/en- bizga/maqola/115001906725 .

Siz ushbu buyruqni bajarib, tuzatasiz:

o'rnatish -m 0700 -o MySQL -g MySQL -d/var/lib/mysql-files

va mysql-ni boshlang

xizmati mysqld boshlash

0
qo'shib qo'ydi
Boshqa har qanday urinishlar? Men qatl qildim, lekin hech narsa o'zgarmaydi.
qo'shib qo'ydi muallif Chayemor, manba