Sida loo xalliyo Khaladaadka MySQL ee XambP-ka ka dib markii Windows Cusboonaysiinta: Mutexes iyo rw_locks Isticmaalka Hawlaha Windows-ka ee Windows

Haddii aad xaq u leedahay ka dib cusboonaysiinta Windows 10, Xambpp-kaaga ma doonayo inuu bilaabo adeegga MySQL, halka uu si fiican u shaqeynayay ka hor oo aadan wax isbeddel ah sameynin, maqaalkan ayaa kuu noqon kara!

Ha argagixin, xalka ayaa laga yaabaa inuu si fudud u beddelo dekedaada MySQL, ama aad u isticmaasho kaydinta jira.

Dhibaatada: Khaladaadka Mutexes iyo RW_Locks Isticmaalka Hawlaha Windows ee Windows

Haddii aad qalad u hesho marka aad bilaabeyso Phpmyadmin, waxay la micno tahay in adeeggaaga MySQL aan laga bilaabin arjiga Xambpp:

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.

Haddii aad qalad u hesho marka aad ka bilaabeyso MySql ee XambP, waxay la micno tahay in rakibidda MySQL ay leedahay arin - fiiri hoosta sida loo xaliyo:

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

Cilad ayaa bilaabaya MySQL / Phpmyadmin ee XambP: Sidee loo xaliyaa?

Baadhista oo xalliso qalad MySQL laga bilaabo XAMPP

Marka ugu horeysa, si loo garto qaladka saxda ah, fur guddiga xakameeya ee Xampp, oo ka hubi qaladka sanduuqa wadahadalka.

Kadib, Fur faylka log ee MySQL khadka tooska ah ee Barnaamijka MySQL, oo ​​hoos timaada badhanka logs, ka hel faylka MySql_lor.log, oo ka hubi arjiga OPTAD ee waa maxay qaladka saxda ah.

Waa inaad ku wareejisaa salka faylka si aad u hesho galka ugu dambeeyay, laba jeer hubi in waqtiga ay u dhigmaan isku dayga ugu dambeeyay ee ay ku bilowdaan Myqql ee Xambpp, oo ay fiiriyaan qaladka. Xaaladdeena, tani waa qaladka aan helnay:

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

Ma jiro farriin khaladka dhabta ah la muujiyo, waxaana jiri kara laba siyaabood oo kala duwan oo lagu xalliyo arrintan, iyadoo kuxiran dhibaatadaada saxda ah.

Habka 1: Isku day inaad beddesho dekada MySQL

Xalka ugu horeeya ayaa laga yaabaa inuu beddelo dekada MySQL, haddii ay dhacdo in arji cusub la rakibay ama la bilaabo, uuna isticmaalo dekeda saxda ah ee saxda ah sida mid loo dhigay MySQL.

Si loo sameeyo sidaas, si fudud u fur faylkayga my.ini oo ku yaal badhanka 'config' ee ku yaal guddiga kontoroolka ee Xamppp-ka.

Baro Aasaaska SEO: Is-qor maanta!

Kordhin aragtida websaydhkaaga iyo taraafikada adoo ka baqaya aasaaska SEO oo ay weheliso koorsadeena aasaaska ah ee-si sahlan loo raaco.

Bilow barashada SEO

Halkaas, ka hel dekada hadda jirta, sida caadiga ah 3306 si caadi ah, oo u beddelo qiimo kale - tusaale ahaan 3308.

Hubso inaad beddesho hal nooc kasta oo dekada ah faylka, kaasoo ugu yaraan labo jeer la joogo, oo waxaa loo qori karaa ilaa shan jeer.

Mar la dhammeeyo, keydi faylka, iskuna day inaad dib u bilawdo arjigaaga MySQL. Haddii taasi weli shaqeyn weydo, arrintu way ka duwanaan kartaa.

Habka 2: Isku day inaad hesho kaydkii ugu dambeeyay

Tag faylka MySQL, oo ​​ka hooseysa faylka Xambpp> Mysql, iyo marka ugu horreysa, samee gurmad faylkaaga xogta, haddii aysan ahayn arrinta dhabta ah.

Kadib, fur faylka gurmadka, dooro dhammaan faylasha marka laga reebo faylka Ibdata1, oo nuqul ka samee.

Nuqul ka dhig faylka xogta ee galka xididka ee MySQL, oo ​​isku day inaad dib u bilowdo MySql-kaaga. Waa inay hada shaqeysaa - laba jeer hubi in wax xog ah lumay, oo loogu talagalay in soo gelitaanka ugu dambeeyay ee aad gelisay keydka macluumaadkaaga.

Gunaanad: sida loo xalliyo qaladka MySQL

Si loo soo gabagabeeyo qalad MySQL waxay noqon kartaa wax fudud sida beddelashada dekada, ama loo adeegsado kaydinta jira ee jira ee galka galka galka.

Haddii xalkani wali aysan adiga kuu shaqeynin, sida ugu fiican ayaa ah in la hubiyo ilaha internetka ee lagu helo xalal loogu talagalay dhibaatooyinkaaga MySQL ee gaarka ah.