Yadda za a warware kuskure fara MySQL akan Xampp Bayan Sabuntawar Windows: Mutexes da RW_LOcks suna amfani da ayyukan da ba a haɗa su ba

Idan daidai bayan Sabuntawar Windows 10 ta atomatik, Xampp dinku ba zato ba tsammani baya so ya fara sabis na MySQL, yayin da yake aiki sosai kafin kuma ba ku iya kowane canji ba, wannan labarin zai iya kasancewa a gare ku!

Kada ku firgita, maganin zai iya canza tashar jiragen ruwa na MySQL, ko don amfani da madadin da ke gudana.

Matsalar: Kuskuren Mutexes da Rw_locks suna amfani da ayyukan da ba a haɗa su ba

Idan kuna samun wannan kuskuren lokacin da fara phpMyAdmin, yana nufin cewa ba a fara aikin MySQL ba akan aikace-aikacen Xamp:

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.

Idan kuna samun wannan kuskuren lokacin da fara MySQL akan Xampp, yana nufin cewa madayanku na MySQL yana da batun - duba a ƙasa yadda za a warware shi:

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

Kuskuren farawa MySQL / phpMyAmmin a Xampp: Yaya za a warware?

Binciken bincike da warware MySQL fara kuskure a Xampp

Da farko dai, don gano ainihin kuskuren, buɗe allon ikon Xambide, kuma duba kuskuren a akwatin maganganun.

To, buɗe fayil ɗin MySQL akan layin MySQL, a ƙarƙashin maɓallin rajistan ayyukan, nemo MySQL_EPG.

Dole ku gungura zuwa kasan fayil ɗin don nemo abubuwan da ke cikin kwandon, bincika sau biyu don fara MySQL a Xampp, kuma ku kalli kuskuren. A cikin lamarinmu, wannan shine kuskuren da muka samu:

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

Babu saƙon kuskure na gaske, kuma za'a iya samun hanyoyi biyu daban-daban da za a magance wannan batun, gwargwadon matsalar ka.

Hanyar 1: Gwada canza tashar MySQL

Farkon bayani na iya zama don canza tashar MySQL, idan an sanya sabon aikace-aikacen ko fara, kuma yana amfani da ainihin tashar don MySQL.

Don yin hakan, kawai buɗe fayil na My.ini wanda ke ƙarƙashin maɓallin Confgp a cikin kwamitin kula da Xampp ɗinku.

MALAMAN HUKUNCIN SIFFOFI: Yi rijista yanzu!

Canza kasancewar Digital ku tare da karatun halittarmu - fara tafiya ta zuwa zama masanin yanar gizo a yau!

Rijista a nan

A can, sami tashar jiragen ruwa na yanzu, yawanci 3306 ta tsohuwa, kuma canza shi zuwa wata ƙimar - misali 3308.

Tabbatar canza kowane ɗayan portcent na tashar jiragen ruwa a cikin fayil ɗin, wanda yake mafi ƙarancin yanzu yana kammala sau biyu, kuma ana iya rubuta shi har sau biyar.

Da zarar an gama, ajiye fayil ɗin, kuma gwada sake kunna aikace-aikacen MySQL. Idan har yanzu bai yi aiki ba, batun na iya bambanta.

Hanyar 2: gwada samun sabon madadin

Shiga babban fayil na MySQL, a ƙarƙashin babban fayil Xampp> MySQL, da kuma farkon duk, yin madadin babban fayil ɗin data, idan wannan ba batun ainihin batun ba ne.

To, buɗe filin ajiyar, zaɓi duk fayiloli sai dai fayil na Ibdata1, da kwafarsu.

Kwafi su a ƙarƙashin babban fayil ɗin bayanai akan babban fayil na MySQL, kuma gwada sake kunna MySQL ku. Ya kamata yanzu aiki - bincika sau biyu cewa babu bayanan da aka rasa, don fashewa da sahun shiga da kuka saka a cikin bayanan ku na yanzu.

A ƙarshe: Yadda za a warware kuskuren MySQL

Don kammala, warware kuskuren MySQL na iya zama mai sauƙi kamar canza tashar jiragen ruwa, ko amfani da abin da ya kasance na yanzu a cikin gidan kayan aiki.

Idan har yanzu ba su da aiki a gare ku, mafi kyawun shine bincika albarkatun kan layi don nemo mafita da matsalolin MySQL ku.