Xampl-da Windows yangilanganidan keyin MySQL-da xatolarni qanday hal qilish kerak: Mutexes va RW_LOLS Windows millatlari qulflangan funktsiyalaridan foydalaning

Agar avtomatik Windows 10 yangilanishidan so'ng, sizning XAMPP-ni to'satdan ishga tushirishni istamasa, MySQL xizmatini ishga tushirishni istamaydi, u oldin juda yaxshi ishlaganda va siz hech qanday o'zgarish qilmadingiz, bu siz uchun bo'lishi mumkin!

Vahima qilmang, echim shunchaki MySQL portingizni o'zgartirishi yoki mavjud zaxiradan foydalanish uchun bo'lishi mumkin.

Muammo: Xato Mutexes va RW_LOLSS WINWESSSELLELLED funktsiyalaridan foydalaning

Agar siz PhpMyAdmin-ni ishga tushirishda ushbu xatolikni boshlayotgan bo'lsangiz, demak MySQL xizmatingiz XAMPP dasturida boshlanmaydi:

MySQL said: Documentation Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Agar siz XAMPP-dagi MySQL-ni ishga tushirganda, agar siz ushbu xatoni boshlasangiz, mysql o'rnatilgan muammoni hal qilishni anglatadi - buni qanday hal qilish kerak:

18:58:08 [mysql] Error: MySQL shutdown unexpectedly.
18:58:08 [mysql] This may be due to a blocked port, missing dependencies, 
18:58:08 [mysql] improper privileges, a crash, or a shutdown by another method.
18:58:08 [mysql] Press the Logs button to view error logs and check
18:58:08 [mysql] the Windows Event Viewer for more clues
18:58:08 [mysql] If you need more help, copy and post this
18:58:08 [mysql] entire log window on the forums

Error Starting MySQL / PHPMyAdmin In XAMPP: How To Solve?

Share

Watch on

Xampp-dagi MySQL / phpMyadmin-ni boshlashda xato: qanday hal qilinadi?

Xamppda MySQL boshlang'ich xatoini tashxislang va hal qiling

Avvalo, aniq xatolarni tashxislash uchun XAMPP boshqaruv panelingizni oching va muloqot oynasida xatolikni tekshiring.

Keyin MySQL log fayliga logs tugmasi ostida, MySQLE_EROR.LOG faylini oching va Notepad dasturida aniq xatolik nima bo'ladi.

So'nggi yozuvlarni topish uchun faylning pastki qismiga o'tishingiz kerak, vaqtni XampP-dagi MySQL-ni ishga tushirishga harakat qiling va xatoni ko'rib chiqing. Bizning holatimizda, bizda xato bor:

2023-01-12 18:58:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-12 18:58:06 0 [Note] InnoDB: Uses event mutexes
2023-01-12 18:58:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-12 18:58:06 0 [Note] InnoDB: Number of pools: 1
2023-01-12 18:58:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-12 18:58:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-12 18:58:06 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-12 18:58:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-12 18:58:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-12 18:58:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-12 18:58:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-12 18:58:06 0 [Note] InnoDB: Waiting for purge to start
2023-01-12 18:58:06 0 [Note] InnoDB: 10.4.21 started; log sequence number 3993504751; transaction id 13792362
2023-01-12 18:58:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-12 18:58:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-12 18:58:06 0 [Note] Server socket created on IP: '::'.

Haqiqiy xato xabari ko'rsatilmaydi va bu muammoni hal qilishning aniq muammosiga qarab hal qilishning ikki xil usuli bo'lishi mumkin.

1-usul: MySQL portiga o'zgartirishga harakat qiling

Birinchi echim MySQL porti o'zgarishi bo'lishi mumkin, agar yangi dastur o'rnatilgan yoki boshlangan bo'lsa, shuningdek, siz aniq portni MySQL uchun o'rnatgan.

Buning uchun My.ini faylingizdagi konfiget tugmachasida joylashgan My.ini faylini oching.

Master veb-yaratish: Hozir ro'yxatdan o'ting!

Raqamli ishtirokingizni to'liq veb-sayt yaratish kursimiz bilan o'zgartiring - bugungi kunda veb-mutaxassis bo'lish uchun sayohatingizni boshlang!

Bu erda ro'yxatdan o'tish

U erda, odatda, 3306 standartni toping va uni boshqa qiymatga o'zgartiring - masalan, 3308.

Minimal mavjud bo'lgan fayldagi portdagi har bir portni o'zgartirishga ishonch hosil qiling, bu kamida ikki marta, va besh marta yozilishi mumkin.

Bir marta bajarilgan, faylni saqlang va MySQL dasturingizni qayta ishga tushirishga harakat qiling. Agar bu hali ham ishlamasa, muammo boshqacha bo'lishi mumkin.

2-usul: Eng so'nggi zaxira nusxasini olishga harakat qiling

MySQL papkasida, XampP> MySQL va birinchi navbatda, ma'lumot papkangizning zaxira nusxasini yarating, agar haqiqiy muammo bo'lmasa, ma'lumotlar papkangizning zaxira nusxasini yarating.

Keyin zaxira papkasini oching, Ibdata1 faylidan tashqari barcha fayllarni tanlang va ularni nusxa oling.

Ularni mysql ildiz papkasidagi ma'lumotlar papkasida nusxalash va MySQL-ni qayta ishga tushirishga harakat qiling. Endi u ishlashi kerak - hech qanday ma'lumot yo'qolganligini ikki marta tekshirish, chunki sizning ma'lumotlar bazangizga kiritilgan so'nggi yozuvlar mavjud.

Xulosa: MySQL xatosini qanday hal qilish kerak

Xulosa qilish uchun MySQL xatini hal qilish portni o'zgartirishi yoki zaxira papkasida mavjud zaxira sovg'alaridan foydalanish mumkin.

Agar ushbu echimlar hali ham siz uchun ishlamayotgan bo'lsa, eng yaxshisi, sizning maxsus MySQL muammolariga bag'ishlangan echimlarni topish uchun onlayn manbalarni tekshirish.