Jinsi ya Kutatua Kosa Kuanza MySQL kwenye Xampp Baada ya Sasisho la Windows: Mabomba na RW_LOCKS Tumia kazi zilizoingiliana za Windows

Ikiwa ni sawa baada ya sasisho la moja kwa moja la Windows 10, XAMPP yako ghafla haitaki kuanza huduma ya MySQL, wakati ilikuwa inafanya kazi vizuri hapo awali na haujafanya mabadiliko yoyote, nakala hii inaweza kuwa kwako!

Usiogope, suluhisho inaweza kuwa kubadilisha tu bandari yako ya MySQL, au kutumia nakala rudufu iliyopo.

Shida: Makosa bubu na RW_LOCKS Tumia kazi zilizoingiliana za Windows

Ikiwa unapata kosa hili wakati wa kuanza phpmyadmin, inamaanisha kuwa huduma yako ya MySQL haijaanza kwenye programu ya XAMPP:

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.

Ikiwa unapata kosa hili wakati wa kuanza MySQL kwenye Xampp, inamaanisha kuwa usanidi wako wa MySQL una suala - tazama hapa chini jinsi ya kuisuluhisha:

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

Hitilafu ya kuanza MySQL / PHPMYADMIN katika XAMPP: Jinsi ya kutatua?

Tambua na utatue kosa la kuanzia la MySQL katika XAMPP

Kwanza kabisa, kugundua kosa halisi, kufungua jopo lako la kudhibiti XAMPP, na angalia kosa kwenye sanduku la mazungumzo.

Halafu, fungua faili ya logi ya MySQL kwenye mstari wa mpango wa MySQL, chini ya kitufe cha magogo, pata faili ya mysql_error.log, na uangalie katika Maombi ya Notepad ni kosa gani.

Utalazimika kusonga chini ya faili ili kupata viingilio vya hivi karibuni, angalia mara mbili kuwa wakati unalingana na jaribio la hivi karibuni la kuanza MySQL katika XAMPP, na uangalie kosa. Kwa upande wetu, hii ndio kosa tulilopata:

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: '::'.

Hakuna ujumbe wa makosa halisi unaonyeshwa, na kunaweza kuwa na njia mbili tofauti za kutatua suala hili, kulingana na shida yako halisi.

Njia ya 1: Jaribu kubadilisha bandari ya MySQL

Suluhisho la kwanza linaweza kuwa kubadilisha bandari ya MySQL, ikiwa programu mpya imewekwa au kuanza, na hutumia bandari sawa na ile iliyowekwa kwa MySQL.

Kwa kufanya hivyo, fungua tu faili ya my.ini ambayo iko chini ya kitufe cha usanidi kwenye jopo lako la kudhibiti XAMPP.

Uundaji wa Tovuti ya Master: Jiandikishe sasa!

Badilisha uwepo wako wa dijiti na kozi yetu kamili ya uundaji wa wavuti - anza safari yako ya kuwa mtaalam wa wavuti leo!

Jiandikishe hapa

Huko, pata bandari ya sasa, kawaida 3306 kwa msingi, na ubadilishe kuwa thamani nyingine - kwa mfano 3308.

Hakikisha kubadilisha kila umoja wa bandari kwenye faili, ambayo iko chini mara mbili, na inaweza kuandikwa hadi mara tano.

Mara baada ya kumaliza, kuokoa faili, na jaribu kuanza tena programu yako ya MySQL. Ikiwa hiyo bado haifanyi kazi, suala linaweza kuwa tofauti.

Njia ya 2: Jaribu kupata nakala rudufu ya hivi karibuni

Nenda kwenye folda ya MySQL, chini ya folda XAMPP> MySQL, na kwanza kabisa, fanya nakala rudufu ya folda yako ya data, ikiwa sio suala la kweli.

Kisha, fungua folda ya chelezo, chagua faili zote isipokuwa faili ya IBDATA1, na uwakili.

Nakili chini ya folda ya data kwenye folda ya mizizi ya MySQL, na jaribu kuanza tena MySQL yako. Inapaswa kufanya kazi - angalia mara mbili kuwa hakuna data iliyopotea, kwa sababu ya kiingilio ambacho umeingiza hivi karibuni kwenye hifadhidata yako iko.

Kwa kumalizia: Jinsi ya kutatua kosa la MySQL

Kuhitimisha, kutatua kosa la MySQL inaweza kuwa rahisi kama kubadilisha bandari, au kutumia nakala ya nakala rudufu iliyopo kwenye folda ya chelezo.

Ikiwa suluhisho hizi bado hazifanyi kazi kwako, bora ni kuangalia rasilimali za mkondoni kupata suluhisho zilizopewa shida zako maalum za MySQL.