Ungayifaka kanjani iMariaDB ku-Windows?

Ungayifaka kanjani iMariaDB ku-Windows?

Emhlabeni wezinhlelo nokuphathwa kwedathabhesi, I-MariaDB isiphenduke inketho ethandwa kakhulu. Ngokuhambisana kwayo ne-MySQL kanye nokugxila kwayo ekulinganiseni nasekusebenzeni, le ndlela ehlukile yomthombo ovulekile ithole ukuthambekela ngokushesha. Uma ucabanga ukusebenzisa i-MariaDB kumaphrojekthi akho e-Windows, usendaweni efanele. Kulesi sihloko, ngizokuqondisa isinyathelo ngesinyathelo ngenqubo yokufaka i-MariaDB ku uhlelo lwakho lokusebenza Amafasitela.

Isinyathelo 1: Landa isifaki se-MariaDB
Isinyathelo sokuqala sokufaka iMariaDB kuWindows landa isifaki okuhambisana nenguqulo yakho ye-Windows kusuka kusayithi elisemthethweni le-MariaDB. Qiniseka ukuthi ukhetha inguqulo efanele ehambisana neyakho isistimu esebenzayo, kungakhathaliseki ukuthi Amabhithi angu-32 noma angu-64.

Isinyathelo 2: Sebenzisa isifaki
Uma usulande isifaki se-MariaDB, yisebenzise ngokuchofoza kabili efayeleni elilandiwe. Lokhu kuzovula iwizadi yokufaka ezokuqondisa kunqubo yokufaka.

Isinyathelo sesi-3: Khetha izingxenye kanye nezilungiselelo
Kulesi sigaba, iwizadi yokufaka ikuvumela khetha izingxenye ofuna ukukufaka kanye ne-MariaDB, njengamasevisi eklayenti, izixhumi, nezinsiza. Ukwengeza, ungaphinda ulungiselele izinketho zokufaka, njengendawo yefolda yokufaka kanye negama lesibonelo.

Isinyathelo 4: Lungiselela izinketho zomsebenzisi
Okulandelayo, kuzodingeka ukuthi lungisa izinketho zomsebenzisi ukusetha iphasiwedi yomsebenzisi wempande ye-MariaDB. Qiniseka ukuthi ukhetha iphasiwedi eqinile nevikelekile ukuze uvikele eyakho isizindalwazi.

Ngalezi zinyathelo ezilula,⁤ ungakwazi faka i-MariaDB kusistimu yakho yokusebenza ye-Windows futhi uqale ukusebenzisa izinzuzo zayo ngokuya ngokusebenza, ukukala ⁢kanye nokuhambisana ne-MySQL. Ungangabazi ukuhlola imibhalo esemthethweni ye-MariaDB ukuze ufunde ngazo zonke izici nemisebenzi enikezwa yile nkundla. Ngikufisela inhlanhla!

1. Izidingo zesistimu zokufaka i-MariaDB⁣ ku-Windows

Ukuze ufake i-MariaDB ku-Windows, udinga ukuhlangabezana nezidingo zesistimu ezilandelayo:

– Isistimu esebenzayo: I-MariaDB iyahambisana nezinguqulo ezihlukahlukene ze-Windows, kuhlanganise I-Windows 10, Windows Server 2019 kanye ne-Windows Server 2016. Kubalulekile ukwenza isiqiniseko sokuthi unenguqulo ehambisanayo uhlelo lokusebenza ngaphambi kokuqhubeka nokufaka.

– Indawo yokugcina izinto: Qiniseka ukuthi unesikhala esanele sokulondoloza esitholakala kukhompyutha yakho. i-hard drive ngokufaka i-MariaDB. Ukwengeza, kuyatuseka ukuthi kube nesikhala esengeziwe sokukhula kwesizindalwazi esikhathini esizayo.

– Imemori ye-RAM: Kunconywa ukuthi okungenani ube ne-4 GB ye-RAM ukuze usebenze kahle we-MariaDB. Nokho, inani lenkumbulo elidingekayo lingahluka kuye ngosayizi nomthwalo womsebenzi wesizindalwazi.

Ngokungeziwe kulezi zidingo zesistimu, kubalulekile ukucabangela ezinye izici ezifana nenguqulo ye-MariaDB ofuna ukuyifaka kanye namalungelo omlawuli adingekayo ukuze uyifake. Uma lezi zidingo sezihlangabeziwe, ungaqhubeka nokufakwa kwe-MariaDB ku-Windows futhi uqale ukujabulela ukusebenza kwayo okuningi kanye nezinzuzo ekuphathweni kwedathabhesi.

2. Landa inguqulo yakamuva ezinzile ye⁢ MariaDB ye-Windows

Ngoba landa inguqulo yakamuva ezinzile ye-MariaDB ye-Windows, Landela lezi zinyathelo ezilula:

1. Finyelela ku- iwebhusayithi Isikhulu sikaMariaDB ku https://mariadb.org/.

2. Zulazula⁢ uye esigabeni sokulanda bese ukhetha inguqulo ye-Windows.

Uma usuqedile ukulanda, Landela lezi zinyathelo ukufaka i-MariaDB kweyakho Uhlelo lweWindows:

1. Chofoza kabili ifayela lokufaka elilandiwe ukuze uqale inqubo yokufaka.

2. Iwizadi yokufaka izovuleka. Khetha ulimi oluthandayo bese uchofoza "Okulandelayo".

3. Yamukela imigomo yelayisensi bese uchofoza "Okulandelayo."

Ekugcineni, lungisa ukufakwa kwakho kwe-MariaDB ku-Windows kanje:

1. Khetha okukhethwa kukho kokufaka okufunayo, njengendawo yokufaka nezinye izingxenye ezengeziwe.

2. Setha iphasiwedi eqinile ye-akhawunti yomphathi we-MariaDB.

3. Qedela iwizadi yokufaka bese ulinda ukuthi inqubo iphele.

Manje usuzoba nenguqulo yakamuva ezinzile ye-MariaDB efakwe ohlelweni lwakho lwe-Windows futhi ungaqala ukusebenzisa lolu hlelo olunamandla lokuphatha isizindalwazi!

3. Inqubo yokufaka i-MariaDB ku-Windows

I-MariaDB iwuhlelo lokuphathwa kwesizindalwazi somthombo ovulekile kanye nemfoloko ye-MySQL. Ukufaka i-MariaDB ku-Windows kuyinqubo elula nesheshayo engaqedelwa ngokulandela izinyathelo ezibalulekile ezimbalwa. Nansi indlela yokufaka i-MariaDB ku-Windows.

Isinyathelo 1: Landa i-MariaDB: Into yokuqala okudingeka uyenze ukulanda inguqulo yakamuva ezinzile ye-MariaDB kuwebhusayithi esemthethweni. Qiniseka ukuthi ukhetha inguqulo ehambisana nesistimu yakho yokusebenza ye-Windows. Uma selilandiwe, ifayela lokufaka lizobe selilungele ukusetshenziswa.

Isinyathelo sesi-2: Qalisa isifaki: Ngemva kokulanda ifayela lokufaka i-MariaDB, lichofoze kabili ukuze uliqalise. Iwindi lokufaka lizovuleka futhi likuqondise kunqubo. Qiniseka ukuthi ufunda futhi wamukele imigomo yelayisensi ngaphambi kokuqhubeka.

Isinyathelo sesi-3: Lungiselela ukufakwa: Phakathi nenqubo yokufaka, uzocelwa ukuba ukhethe izinketho zokumisa ngokusekelwe ezidingweni zakho. Ungakhetha ulimi lokufaka, indawo yefayela, nezinketho zokuqalisa iseva, phakathi kwezinye izilungiselelo. Qiniseka ukuthi ubuyekeza ngokucophelela zonke izinketho ngaphambi kokuqhubeka. Uma usulungise zonke izinketho, chofoza ⁣»Faka» ukuze uqale inqubo yokufaka.

4. ⁢Ukucushwa kwasekuqaleni kwe-MariaDB ku-Windows

Ilungiselela i-MariaDB ku-Windows

Uma usuyifakile i-MariaDB ohlelweni lwakho lokusebenza lwe-Windows, kubalulekile ukwenza ukumisa kokuqala ukuze uqinisekise ukuthi isizindalwazi sisebenza kahle. Kulesi sigaba, ngizokuqondisa ngezinyathelo ezahlukahlukene okudingeka uzilandele ukuze ulungiselele⁤ uMariaDB kuWindows.

Okokuqala, udinga ukuvula iwindi lomugqa womyalo njengomlawuli. Ukuze wenze lokhu, chofoza kwesokudla imenyu yokuqala bese ukhetha u-“Command Prompt (Admin)” ohlwini lokudonsela phansi. Lokhu kuzokuvumela ukuthi wenze izinguquko⁤ ekucushweni kwe-MariaDB.

Isinyathelo esilandelayo ukuhlela ifayela le-my.ini lokumisa elitholakala kufolda yokufaka i-MariaDB. Ungathola leli fayela endleleni ethi C:Program FilesMariaDB ⁣10.6data. Vula ifayela usebenzisa umhleli wombhalo bese ubheka [mysqld] isigaba. Lapha kulapho ungenza khona izinguquko ekucushweni kwe-⁢MariaDB. Eminye yemingcele ebaluleke kakhulu okufanele icatshangelwe ukucushwa kwembobo, usayizi wephakethe omkhulu, kanye nokucushwa kwenjini yokugcina. Qiniseka ukuthi ulondoloza izinguquko zakho uma usuqedile.

Ukwenza lokhu kubalulekile ukuze uqinisekise ukusebenza kahle kwedathabhesi. Landela izinyathelo ezishiwo ngenhla ukuze uvule iwindi lomugqa womyalo njengomlawuli futhi uhlele ifayela lokumisa le-my.ini. Khumbula ukulondoloza izinguquko uma sezenziwe. Ukumisa kahle kungathuthukisa ukusebenza nokuvikeleka kwesizindalwazi sakho se-MariaDB ku-Windows. Uma usuqedile lezi zinyathelo, uzobe usulungele ukusebenza no-MariaDB ohlelweni lwakho lokusebenza lwe-Windows.

5. Ukufinyelela isixhumi esibonakalayo somugqa womyalo we-MariaDB ku-Windows

Uyingxenye ebalulekile yokusebenza nalesi sizindalwazi esinamandla. Ngomugqa womyalo, abasebenzisi bangakhipha imiyalo nemibuzo ngokuqondile kusizindalwazi. Lokhu ⁢kunikeza ukulawula okukhulu nokuvumelana nezimo ekuphathweni kwedatha.

Ukuze ufinyelele isixhumi esibonakalayo somugqa womyalo we-MariaDB ku-Windows, kufanele uqale uvule iwindi lomyalo. Ungakwenza lokhu ngokucindezela ukhiye weWindows + R bese uthayipha "cmd." Lapho iwindi lomyalo livuleka, kufanele ufake umkhombandlela lapho uMariaDB efakwe khona. Ngokuvamile, lena C:Amafayela OhleloMariaDBMariaDB< version >bin, uqinisekisa ukufaka esikhundleni se-< version > ‍ nenguqulo ethile oyifakile.

Uma ususohlwini lwemibhalo olufanele, ungasebenzisa umyalo othi “mysql” ukuze uqalise isixhumi esibonakalayo somugqa womyalo we-MariaDB. Lokhu kuzokuyisa ekwazisweni kwe-MariaDB, lapho ongafaka khona imiyalo yakho nemibuzo. Uma ufuna ukufinyelela kusizindalwazi esithile, ungasebenzisa umyalo othi “sebenzisa <igama lesizindalwazi>” ukuze usikhethe. Ukusuka lapho, ungenza imisebenzi eyahlukene, njengokwenza amathebula, ukufaka idatha, nokusebenzisa imibuzo eyinkimbinkimbi. ⁢Khumbula ukuthi kubalulekile ukuba nolwazi lwangaphambili lwemiyalo ye-MariaDB ukuze usebenze ngempumelelo kusixhumi esibonakalayo somugqa womyalo.

6. Ukudala nokuphatha imininingwane ku-MariaDB ye-Windows

Kulokhu okuthunyelwe, sizokukhombisa ukuthi kanjani faka i-MariaDB ku-Windows kanye nendlela yokudala nokuphatha imininingwane yolwazi kule nkundla. I-MariaDB iwumthombo ovulekile wohlelo lokuphatha isizindalwazi esiphenduke enye indlela edumile ye-MySQL. Onjiniyela abaningi nabaphathi besizindalwazi⁤ bancamela ukusebenzisa i-MariaDB ngenxa yokusebenza kwayo, ukukala, nokuthuthukiswa kokuvikeleka.

Ukuqala landa inguqulo efanele ye-MariaDB ye-Windows kusuka kuwebhusayithi yayo esemthethweni. Qiniseka ukuthi ukhetha inguqulo ehambisana nesistimu yakho yokusebenza. Uma ifayela lokufaka selilandiwe, lichofoze kabili ukuze uqale inqubo yokufaka. Landela imiyalelo esesikrinini ukuze uqedele ukufaka.

Uma usuyifakile i-MariaDB kusistimu yakho, sekuyisikhathi sokuthi dala futhi uphathe imininingwane egciniwe. Ungasebenzisa umugqa womyalo, i-graphical interface yomsebenzisi, noma amathuluzi okuphatha afana ne-phpMyAdmin. ‍ Ukuze ufinyelele umugqa womyalo we-MariaDB, vula iwindi lomyalo bese uthayipha mariadb ulandelwa ngu -u tu_usuario -p ukungena ngemvume ngegama lakho lomsebenzisi nephasiwedi. Ukusuka lapha, ungasebenzisa imiyalo ye-SQL ukuze udale futhi uphathe imininingwane yakho yolwazi.

7. Ukulungiselela amalungelo omsebenzisi ku-MariaDB ku-Windows

Uma usuyifakile i-MariaDB kusistimu yakho ye-Windows, kubalulekile ukulungisa amalungelo omsebenzisi afanelekile ukuze uqinisekise ukuphepha kanye nokufinyelela okulungile kusizindalwazi. Ngenhlanhla, i-MariaDB inikeza isethi yamathuluzi okuphatha amalungelo omsebenzisi ngempumelelo.

Ukuze uqalise, udinga ukuvula isixhumi esibonakalayo somugqa womyalo we-MariaDB ngokusebenzisa umyalo i-mysql kusuka kumyalo womyalo. Lokhu kuzokuvumela ukuthi ufinyelele ikhonsoli yokuphatha ye-MariaDB. Uma usungaphakathi, ungaqala ukuphatha amalungelo omsebenzisi usebenzisa imiyalo ethile.

Esinye sezinyathelo zokuqala wukudala umsebenzisi omusha ngezimvume ezifanele. Ukuze wenze lokhu, ungasebenzisa umyalo DALA UMSEBENZISI. Isibonelo, uma ufuna ukudala umsebenzisi ogama lakhe lingu-"user1" nge-password "password1", ungasebenzisa umyalo olandelayo:
«`
DALA UMSEBENZISI 'user1'@'localhost' UKHOnjwe 'iphasiwedi1';
«`
Bese, kufanele unikeze amalungelo adingekayo kumsebenzisi osanda kwakhiwa. Ungakwenza usebenzisa umyalo ISIBONELELO. Isibonelo, uma ufuna ukunika u-"user1" wonke amalungelo okufinyelela kusizindalwazi esibizwa ngokuthi "database1", ungasebenzisa umyalo olandelayo:
«`
NIKEZA WONKE AMALUNGELO KUSIZINDAWO1.* KU-'user1'@'localhost';
«`
Khumbula ukuthi kufanele ubuyekeze amalungelo ukuze izinguquko zisebenze usebenzisa umyalo FLUSH⁣ PRIVILEGS. Ngalokhu, ulungiselele ngempumelelo amalungelo omsebenzisi ku-MariaDB ye-Windows, okuzokuvumela ukuthi uphathe futhi ulawule ukufinyelela kusizindalwazi. ngokuphephile.

8. Ukuxazulula izinkinga ezivamile phakathi nokufakwa kwe-MariaDB ku-Windows

Uma usunqume ukufaka i-MariaDB ohlelweni lwakho lokusebenza lwe-Windows, ungase uhlangabezane nezinkinga ezivamile phakathi nenqubo yokufaka.Ngenhlanhla, eziningi zalezi zinkinga zinezixazululo ezilula nezisheshayo. Ngezansi, sizokunikeza izixazululo ezivamile ukukusiza ukuxazulula izithiyo ezivame kakhulu.

1. Iphutha lokuncika: ⁤ Umlayezo wephutha ungase uvele ngesikhathi sokufakwa obonisa ukuthi okunye ukuncika akukho. Ukuze ulungise le nkinga, qiniseka ukuthi unesofthiwe edingekayo efakiwe, njengePhakheji Esabalalisa Kabusha ye-C++ kanye ne-.NET Framework. Uma okuncikile okudingekayo kungafakiwe, landa futhi ukufake ngaphambi kokuzama ukufaka i-MariaDB futhi.

2. Inkinga ye-firewall: Uma i-firewall yakho ivimbela ukufakwa kwe-MariaDB, kubalulekile ukuyikhubaza okwesikhashana phakathi nokuyifaka. Ungakwenza lokhu ngokuya kuzilungiselelo ze-firewall yeWindows bese ukhetha inketho yokuyikhubaza. Uma ukufakwa sekuqedwe ngempumelelo, khumbula ukwenza i-firewall isebenze futhi ukuze ugcine ukuphepha kwesistimu yakho.

9. Ukubuyekeza i-MariaDB ku-Windows: Imikhuba Emihle Nezinyathelo Zokuqaphela Okufanele Uzithathe

Enye yezinzuzo eziyinhloko ze-MariaDB yikhono layo lokuvuselelwa ku izinhlelo zokusebenza IWindows kalula futhi ngokuvikelekile. Nokho, kubalulekile ukukhumbula ezinye⁤ izinqubo ezihamba phambili kanye nezinyathelo zokuphepha ezibalulekile ngaphambi kokwenza inqubo yokuthuthukisa. Lezi zinyathelo zizoqinisekisa ubuqotho bedatha kanye nokusebenza okulungile kweseva egciniwe.

1. Yenza i- isipele kuqediwe: Ngaphambi kokuqhubeka nokuthuthukiswa kwe-MariaDB, kunconywa kakhulu ukuthi uthathe isipele esigcwele sayo yonke imininingwane yolwazi namafayela ahlobene. Lokhu kubalulekile ukuze uvikele ulwazi uma kwenzeka okuthile kungahambanga kahle phakathi nenqubo.⁣ Ungasebenzisa amathuluzi okulondoloza njenge-mysqldump noma izisombululo zesipele zezinkampani zangaphandle ukuze ufeze umsebenzi. Qiniseka ukuthi ikhophi yasenqolobaneni igcinwe endaweni ephephile futhi iyafinyeleleka uma kwenzeka udinga ukuyibuyisela.

2. Qinisekisa izidingo ezincane zesistimu: Ngaphambi kokuthi uqale ukuthuthukisa, qiniseka ukuthi isistimu yakho ihlangabezana nezingxenyekazi zekhompuyutha ezincane nezimfuneko zesofthiwe ukuze isekele inguqulo yakamuva ye-MariaDB. Lokhu kungase kuhlanganise inguqulo yesistimu yokusebenza, inani⁤ le-RAM, isikhala sediski esitholakalayo, phakathi kokunye. Bona amadokhumenti e-MariaDB asemthethweni ukuze uthole imininingwane ethile⁤ mayelana nezidingo zenguqulo oyithuthukisayo.

3. Khubaza izinsiza futhi uvale iseva: Ngaphambi kokuqala ukuthuthukisa, udinga ukukhubaza zonke izinsiza ezihlobene ne-MariaDB futhi uqinisekise ukuthi iseva ivaliwe. Lokhu kuzogwema noma yikuphi ukungqubuzana noma iziphazamiso phakathi nenqubo yokubuyekeza. Ungasebenzisa i-Windows Service Manager ukukhubaza izinsiza ezihambisanayo. Futhi, qiniseka ukuthi wazisa bonke abasebenzisi nezinhlelo zokusebenza ezifinyelela kuseva ngenhloso yakho yokwenza isibuyekezo, ukugwema noma yikuphi ukuphazamiseka noma ukulahlekelwa umsebenzi phakathi nenqubo.

10. Izincomo ezengeziwe zokusetshenziswa okuphumelelayo nokuvikelekile kwe-MariaDB ku-Windows

1. Ukucushwa kwe-Windows Firewall:

Kubalulekile lungisa kahle i-Windows Firewall ukuze uvumele ukufinyelela ku-MariaDB.⁣ Qiniseka ukuthi uvumela ithrafikhi yenethiwekhi yembobo u-MariaDB alalele kuyo, ngokuvamile okuyimbobo engu-3306. Ungase futhi ucabangele ukusebenzisa isixazululo se-Firewall yenkampani yangaphandle ukuze unikeze ukuvikeleka okukhulu ezinsongweni zangaphandle.

2. Ukubuyekezwa okuvamile kwe-MariaDB:

Ukugcina ukufakwa kwakho kwe-MariaDB kuphephile futhi kungenazo ubungozi obaziwayo, kunjalo izibuyekezo ezivamile ezibalulekile. Hlola njalo ikhasi lokulanda kuwebhusayithi esemthethweni ye-MariaDB ukuze uqinisekise ukuthi usebenzisa inguqulo yakamuva ezinzile futhi usebenzisa noma yiziphi izibuyekezo ezidingekayo.

3. Amakhophi asemuva abavamile:

Ukuze uvimbele ukulahleka kwedatha esimweni sokwehluleka kwesistimu noma ukuhlaselwa kwe-cyber, kunjalo Kubalulekile ukwenza ama-backups ajwayelekile kusuka kusizindalwazi sakho. Ungasebenzisa amathuluzi ezinkampani zangaphandle noma imibhalo yangokwezifiso ukuze wenze le nqubo ngokuzenzakalelayo futhi uqinisekise lokho idatha yakho zivikelwe.