Bii o ṣe le yanju iṣoro naa ti iṣẹ MySQL ni XAMPP ti wa ni pipade laifọwọyi lẹhin ti o bẹrẹ fun igba diẹ?

ninu XAMPP rẹMySQLNjẹ iṣẹ naa ti wa ni pipade laifọwọyi?Nkan yii pese awọn solusan lati ṣe iranlọwọ fun ọ lati yanju iṣoro yii.

Fẹ lati ṣe idanwo lori kọnputa agbegbeOju opo wẹẹbu Wodupiresi, idanwo ati tunṣe koodu akori wodupiresi, ki o si fi XAMPP Win64 sori ẹrọSọfitiwiaLẹhin iyẹn, ko si awọn iṣoro eyikeyi.MySQLBibẹrẹ ni igbimọ iṣakoso ati ohun gbogbo ṣiṣẹ bi o ṣe deede.

Sibẹsibẹ, nigbati mo tun bẹrẹ kọmputa naa, Apache tun n ṣiṣẹ, ṣugbọn MySQL kii yoo bẹrẹ!

Lẹhinna, gbiyanju lati tun XAMPP sori ẹrọ, ṣugbọn MySQL ko le ṣiṣẹ bi igbagbogbo, ati paapaa ni kete ti iṣẹ MySQL ti bẹrẹ, yoo ku laifọwọyi laipẹ.

Iṣẹ MySQL ni XAMPP ti wa ni pipade laifọwọyi lẹhin igba diẹ lẹhin ti o ti bẹrẹ

Atẹle jẹ apakan ti akọọlẹ aṣiṣe ti iṣẹ MySQL ti XAMPP▼

09:48:10  [mysql]   Attempting to start MySQL app...
09:48:10  [mysql]   Status change detected: running
09:48:11  [mysql]   Status change detected: stopped
09:48:11  [mysql]   Error: MySQL shutdown unexpectedly.
09:48:11  [mysql]   This may be due to a blocked port, missing dependencies, 
09:48:11  [mysql]   improper privileges, a crash, or a shutdown by another method.
09:48:11  [mysql]   Press the Logs button to view error logs and check
09:48:11  [mysql]   the Windows Event Viewer for more clues
09:48:11  [mysql]   If you need more help, copy and post this
09:48:11  [mysql]   entire log window on the forums

Bii o ṣe le yanju iṣoro naa ti iṣẹ MySQL ni XAMPP ti wa ni pipade laifọwọyi lẹhin ti o bẹrẹ fun igba diẹ?

Ṣi ikarahun kan lati ibi iṣakoso ki o bẹrẹ XAMPP pẹlu aṣẹ atẹle ▼

mysqld --console --skip-grant-tables --skip-external-locking

Ṣii ikarahun miiran lati ibi iṣakoso ki o lo awọn aṣẹ wọnyi lati tun data data ▼

mysqlcheck -r --databases mysql --use-frm

• Duro XAMPP, pa ikarahun naa, ki o tun XAMPP bẹrẹ.