Maitiro Ekugadzirisa Kanganiso Kutanga MySQL ON XAMPP Mushure mekuvandudza Windows: Mutexes uye RW_L_L_L_LOCKS KUSHANDISA WWWWWWWWHONEDLECKEDS

Kana chaipo mushure meiyo otomatiki Windows gumi

Usavhunduka, mhinduro yacho ingangove yekuchinja yako MySQL chiteshi, kana kushandisa iyo iripo backup.

Dambudziko: Kukanganisa Mutsiva uye rw_locks Shandisa Windows Yakabatanidzwa Mabasa

Kana iwe uri kuwana chikanganiso ichi kana uchitanga Phpmyadmin, zvinoreva kuti yako MySQL sevhisi haina kutanga paXampp application:

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.

Kana iwe uri kuwana iyi chikanganiso kana uchitanga MySQL paXampp, zvinoreva kuti yako MySQL kuiswa ine nyaya - ona pazasi maitiro ekuzvigadzirisa:

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

Kukanganisa kunotanga MySQL / Phpmyadmin muXampp: Maitiro ekugadzirisa?

Kuongororwa uye kugadzirisa iyo MySQL kutanga kukanganisa mu xampp

Chekutanga pane zvese, kuongorora iyo chaiyo chikanganiso, vhura yako xampp kutonga panel, uye tarisa kukanganisa mubhokisi dialog.

Zvadaro, vhura iyo MySQL Log faira pane iyo MySQL Chirongwa mutsara, pasi pebhatani reLogs, tsvaga iyo MySQL_Error.log faira, uye tarisa neNotepad application ndechipi chaiwo chikanganiso.

Iwe unofanirwa kupemberera kuzasi kwefaira kuti uwane iyo yazvino mapindiro, tarisa kuti nguva inoenderana neazvino edza kutanga Myampp, uye tarisa kukanganisa. Pane yedu nyaya, ichi ndicho chikanganiso chatinacho:

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

Hapana iyo chaiyo yekukanganisa meseji iri kuratidzwa, uye panogona kunge paine nzira mbiri dzakasiyana dzekugadzirisa nyaya iyi, zvichienderana nedambudziko rako chairo.

Nzira 1: Edza kuchinja iyo MySQL Port

Mhinduro yekutanga inogona kunge ichishandura iyo MySQL Port, kana iri application nyowani yakaiswa kana kutanga, uye inoshandisa chiteshi chimwe chete ichocho chimwe chete chakagadzirirwa MySQL.

Kuti uite kudaro, ingo vhura iyo faira yangu iyo iri pasi pebhatani bhatani pane yako Xampp kutonga panel.

Master webhusaiti wegumi: Nyoresa izvozvi!

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!

Nyoresa pano

Ikoko, tsvaga iyo yazvino chiteshi, kazhinji 3306 nekusvibiswa, uye ichichinjisa kune imwe kukosha - semuenzaniso 3308.

Ita shuwa kuti uchinje mumwe nemumwe asarudzo yechiteshi mufaira, iyo iri mashoma apa nguva kaviri, uye inogona kunyorwa kusvika kashanu.

Akamboita, chengetedza iyo faira, uye edza kutangazve yako MySQL application. Kana izvo zvisingashandi, nyaya yacho inogona kunge yakasiyana.

Nzira 2: Edza Kuwana Chekupedzisira Backup

Enda muMySQL folda, pasi peFolder Xampp> MySQL, uye yekutanga pane zvese, ita backup yedata yako folda, kana isiri iyo chaiyo nyaya.

Zvadaro, vhura iyo backup folda, sarudza ese mafaera kunze kweiyo Ibdata1 faira, uye uvape.

Venheve pasi peiyo data folda pane MySQL Root Folder, uye edza kutangazve MySQ yako. Izvo zvinofanirwa kunge zviri kushanda - kaviri tarisa kuti hapana data yakarasika, yeExmuple kuti iyo yekunyatso dendwa iwe yawakaisa mune yako database iripo.

Mukupedzisa: Maitiro ekugadzirisa iyo MySQL kukanganisa

Kugumisa, kugadzirisa chikanganiso cheMySQ

Kana aya mhinduro achiri kukushandira iwe, zvakanaka ndeyekuongorora iyo online zviwanikwa kuti uwane mhinduro dzakatsaurwa kune yako chaiyo mySQL matambudziko.