Pehea e hoʻoponopono ai i ka halaʻole e hoʻomaka anaʻo MySQL ma Xampp ma hope o Windows Update Update: Mitexes a me nā RW_Lol

Inā pololei ma hope o kahi Windows IT ATTOTER Windows 10,ʻaʻole makemake kāu Xampp e hoʻomaka i ka lawelaweʻana ma mua aʻaʻoleʻoe e hana i kahi o ka mysql

Mai hana i ka panic, e loli paha ka hopena e hoʻololi hou i kāu awa MySQL, a iʻole e hoʻohana i ka hoʻihoʻi hou.

ʻO ka pilikia: Hapa hewa hewa a me nā RW_Lacks e hoʻohana i nā hana Windows interlocked

Ināʻoe e loaʻa ana i kēia hala i ka wā e hoʻomaka ai phpskymmin,ʻo ia ka mea e hoʻomaka ai kāu lawelawe MySQL ma 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.

Ināʻoe e loaʻa ana i kēia hala i ka wā e hoʻomaka ana i kaʻu mea e hoʻomaka ai ma Xamp

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

Hapa ka hoʻomakaʻana o MySQL / phpWadmin i xampp: Pehea e hoʻoponopono ai?

Diagnose a hoʻoponopono i ka hala o MySQL e hoʻomaka i ka hala ma Xampp

ʻO ka mea mua loa, e hōʻoia i ka hewa pololei, wehe i kāu papa inoa o Xampp

A laila, e wehe i ka faila kāleka MySQL ma luna o ka laina papahana MySQL, ma lalo o ka pahu pahu, e nānā i ka palapala notepad.

Ponoʻoe e paʻi i ka lalo o ka faile e loaʻa i nā helu hou, e nānāʻelua i ka manawa hou e hoʻomaka ai i ka halaʻole. I kā mākou hihia,ʻo ia ka hewa ua loaʻa iā mākou:

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

ʻAʻole i hōʻikeʻia nā leka hewa maoli, a aia pahaʻelua mauʻano likeʻole e hoʻoponopono i kēia pilikia, ma muli o kāu pilikia kūpono.

Kaʻina 1: E ho'āʻo e hoʻololi i ka awa MySQL

ʻO ka hopena mua paha e hoʻololi i ka awa MySQL, ma kahi o kahi noi hou i hoʻonohonohoʻia a hoʻomaka paha, a hoʻohana i ke awa like me ka mea hoʻokahi no ka mea hoʻokahi.

E hana pēlā, wehe wale i ka faile my.iTi i loaʻa ma lalo o ka pihi Config ma luna o kāu papa inoa Xampp.

Master Pūnaewele Pūnaewele: E kākau inoa i kēia manawa!

E hoʻololi i kāu heleʻana i kāu kamepiula me kā mākou papa hana maʻamau pūnaewele - hoʻomaka i kāu huakaʻi e lilo i mea loea i kēia lā!

E kākau inoa ma aneʻi

Ma laila, eʻike i ka awa, maʻamau 3306 e ka maʻamau, a hoʻololi i kekahi waiwai'ē aʻe - no keʻano 3308.

E hōʻoia e hoʻololi i kēlā me kēia manawa i ke kahua o ke awa,ʻo ia ka liʻiliʻi ma lalo oʻelua mau manawa, a hiki ke kākauʻia iʻelima mau manawa.

I hanaʻia, mālama i ka faile, a e ho'āʻo e hoʻomaka hou i kāu noi mysql. Ināʻaʻole e hana mauʻia,ʻokoʻa paha ka pilikia.

Kaʻina 2: E ho'āʻo e loaʻa i ka hoʻihoʻi hou

E hele i loko o MySQL Folder, ma lalo o ka waihona Xampp> Mysql, aʻo ka mea mua, e hana i ka hoʻopiʻi maoli.

A laila, e wehe i ka faila o ka waihona, e koho i nā faila a pau wale nō ke kumu o IBDdata1, a kope iā lākou.

Hoʻopili iā lākou ma lalo o ka waihona data i ka folder rootql, a ho'āʻo e hoʻomaka hou i kāu mysql. Pono e hana ia i kēia manawa - e nānāʻeluaʻaʻole i nalowale nā ​​data, no ka hōʻikeʻana i ka mea hou i hoʻokomoʻia ma kāu waihona.

I ka hopena: Pehea e hoʻoponopono ai i ka hala MySQL

I mea e hoʻopau ai, e hoʻopau ana i kahi hala MySQL e hiki ke maʻalahi e like me ke hoʻololiʻana i ke awa, a iʻole ka hoʻohanaʻana i ka backup i kēia manawa.

Ināʻaʻole e hana hou kēia mau hopena noʻoe,ʻoi aku ka maikaʻi o ka nānāʻana i nā kumuwaiwai pūnaewele e loaʻa ai nā pilikia i loaʻa i kāu mau pilikia MySQL.