Uyifaka njani iMariaDB kwiWindows?

Uyifaka njani iMariaDB kwiWindows?

Kwihlabathi lenkqubo kunye nolawulo lwedathabheyisi, UMariaDB iye yaba yinto ethandwa kakhulu. Ngokuhambelana kwayo ne-MySQL kunye nokugxila kwayo kwi-scalability kunye nokusebenza, le ndlela yomthombo ovulekileyo iye yafumana ngokukhawuleza. Ukuba ucinga ukusebenzisa iMariaDB kwiiprojekthi zakho zeWindows, ukwindawo elungileyo. Kweli nqaku, ndiza kukukhokela inyathelo ngenyathelo ngenkqubo yokufaka uMariaDB kwi inkqubo yakho yokusebenza Iifestile.

Inyathelo 1: Khuphela isifakeli seMariaDB
Inyathelo lokuqala lokufaka iMariaDB kwiWindows Khuphela isifaki ehambelana noguqulelo lwakho lweWindows kwindawo esemthethweni ye-MariaDB. Qiniseka ukuba ukhetha uhlobo oluchanekileyo oluhambelana neyakho inkqubo yokwenza, nokuba Iibhithi ezingama-32 okanye ezingama-64.

Inyathelo lesi-2: Sebenzisa umfaki
Nje ukuba ukhuphele i-installer ye-MariaDB, yiqhube ngokunqakraza kabini kwifayile ekhutshelweyo. Oku kuya kuvula iwizadi yokuhlohla eya kukukhokela kwinkqubo yokuhlohla.

Inyathelo 3: Khetha amacandelo kunye nolungelelwaniso
Kweli nqanaba, iwizadi yokuhlohla ikuvumela khetha izinto ezisetyenzisiweyo ofuna ukuyifaka kunye ne-MariaDB, njengeenkonzo zabaxhasi, iziqhagamshelo, kunye nezinto eziluncedo. Ukongeza, ungaqwalasela iinketho zokuhlohla, njengendawo yokufaka isiqulathi seefayili kunye negama lomzekelo.

Inyathelo 4: Qwalasela iinketho zomsebenzisi
Okulandelayo, kuya kufuneka qwalasela iinketho zomsebenzisi ukuseta igama eligqithisiweyo lomsebenzisi eliyingcambu ye-MariaDB. Qinisekisa ukuba ukhetha igama eliyimfihlo elinamandla nelikhuselekileyo ukukhusela i-password yakho isiseko sedatha.

Ngala manyathelo alula,⁤ ungakwazi faka i-MariaDB kwinkqubo yakho yeWindows kwaye uqale ukuthatha inzuzo yayo ngokwemigaqo yokusebenza, ukukala ⁢kunye nokuhambelana noMySQL. Ungathandabuzi ukuphonononga amaxwebhu asemthethweni e-MariaDB ngakumbi ukuze ufunde malunga nazo zonke iimpawu kunye nokusebenza eli qonga linikezelayo. Nqwenelela impumelelo!

1. Iimfuno zenkqubo yokufaka i-MariaDB⁣ kwi-Windows

Ukuze ufake i-MariaDB kwi-Windows, kufuneka uhlangabezane nezi mfuno zenkqubo zilandelayo:

– Inkqubo yokwenza: UMariaDB uyahambelana neenguqulelo ezahlukeneyo zeWindows, kubandakanya IiWindows 10, iWindows Server 2019 kunye neWindows Server 2016. Kubalulekile ukuqiniseka ukuba unoguqulelo oluhambelanayo yenkqubo yokusebenza phambi kokuba uqhubeke nofakelo.

– Indawo yokugcina izinto: Qinisekisa ukuba unendawo eyaneleyo yokugcina ekhoyo kwikhompyuter yakho. ihadi drayivu yokuhlohla MariaDB. Ukongeza, kuyacetyiswa ukuba ube nendawo eyongezelelweyo yokukhula kwedatha kwixesha elizayo.

– Imemori ye-RAM: Kucetyiswa ukuba okungenani ube ne-4 GB ye-RAM yokusebenza kakuhle kwe-MariaDB. Nangona kunjalo, inani lememori efunekayo linokwahluka ngokuxhomekeke kubukhulu kunye nomthwalo womsebenzi wesiseko sedatha.

Ukongeza kwezi mfuno zenkqubo, kubalulekile ukuqwalasela eminye imiba efana nenguqulelo ye-MariaDB ofuna ukuyifaka kunye namalungelo omlawuli ayimfuneko ekufakeni. Nje ukuba ezi mfuno zifezekisiwe, ungaqhubeka nofakelo lwe-MariaDB kwiWindows kwaye uqalise ukonwabela imisebenzi yayo emininzi kunye nezibonelelo kulawulo lwedatha.

2. Khuphela inguqulelo yamva nje ezinzileyo ye⁢ MariaDB yeeWindows

Ngokuba khuphela inguqulelo yamva nje ezinzileyo yeMariaDB yeWindows, Landela la manyathelo alula:

1. Fikelela kwi iwebhusayithi Igosa likaMariaDB kwi https://mariadb.org/.

2. Khangela⁢ ukuya kwicandelo lokukhuphela kwaye ukhethe inguqulelo yeWindows.

Nje ukuba ugqibe ukukhuphela, Landela la manyathelo ukufaka uMariaDB kwisixhobo sakho Inkqubo yeWindows:

1. Cofa kabini ifayile yokuhlohla ekhutshelweyo ukuqalisa inkqubo yokuhlohla.

2. Iwizadi yokufakela iya kuvula. Khetha ulwimi oluthandayo kwaye ucofe "Okulandelayo".

3. Yamkela imigaqo yelayisensi kwaye ucofe "Okulandelayo."

Ekugqibeleni, qwalasela ufakelo lwakho lweMariaDB kwiWindows ngolu hlobo lulandelayo:

1. Khetha ukhetho olufunekayo lokufakela, njengendawo yokufakela kunye nezixhobo ezongezelelweyo.

2. Seta igama eliyimfihlo elinamandla kwiakhawunti yomlawuli we-MariaDB.

3. Gcwalisa iwizadi yokuhlohla kwaye ulinde inkqubo ukuba igqitywe.

Ngoku uya kuba nenguqulelo yamva nje ezinzileyo ye-MariaDB efakwe kwinkqubo yakho yeWindows kwaye ungaqala ukusebenzisa le nkqubo yolawulo lwedatha enamandla!

3. Inkqubo yokufaka iMariaDB kwiWindows

UMariaDB yinkqubo yolawulo lwesiseko semithombo evulekileyo kunye nefolokhwe yeMySQL. Ukufaka iMariaDB kwiWindows yinkqubo elula nekhawulezayo enokugqitywa ngokulandela amanyathelo abalulekileyo ambalwa. Nantsi indlela yokufaka iMariaDB kwiWindows.

Inyathelo 1: Khuphela uMariaDB: Into yokuqala ekufuneka uyenzile kukukhuphela inguqulelo yamva nje ezinzileyo ye-MariaDB kwiwebhusayithi esemthethweni. Qiniseka ukuba ukhetha inguqulelo ehambelanayo nenkqubo yakho yokusebenza yeWindows. Nje ukuba ikhutshelwe, ifayile yokuhlohla iya kuba ilungele ukusetyenziswa.

Inyathelo 2: Qhuba isifakeli: Emva kokuba ukhuphele ifayile yokufakela iMariaDB, cofa kabini ukuyiqhuba. Ifestile yokuhlohla iyakuvula kwaye ikukhokele kwinkqubo. Qiniseka ukuba ufunda kwaye wamkele imiqathango yelayisensi phambi kokuba uqhubeke.

Inyathelo 3: Lungisa ufakelo: Ngexesha lenkqubo yokuhlohla, uya kucelwa ukuba ukhethe iinketho zoqwalaselo ngokusekelwe kwiimfuno zakho. Unokukhetha ulwimi lokufakela, indawo yefayile, kunye neenketho zokuqalisa iseva, phakathi kwezinye iisetingi. Qinisekisa ukuba uphonononga ngononophelo zonke iinketho phambi kokuba uqhubeke. Nje ukuba uqwalasele zonke iinketho, cofa ⁣»Faka»ukuqalisa inkqubo yokuhlohla.

4. ⁢Uqwalaselo lokuqala lwe-MariaDB kwi-Windows

Ukuqwalasela iMariaDB kwiWindows

Nje ukuba ufake i-MariaDB kwi-Windows operating system yakho, kubalulekile ukwenza uqwalaselo lokuqala ukuqinisekisa ukuba i-database isebenza kakuhle. Kweli candelo, ndiza kukukhokela kumanyathelo ahlukeneyo ekufuneka uwalandele ukuze uqwalasele⁤ uMariaDB kwiWindows.

Okokuqala, kufuneka uvule iwindow yomgca womyalelo njengomlawuli. Ukwenza oku, cofa ekunene kwimenyu yokuqalisa kwaye ukhethe u- "Command Prompt (Admin)" kuluhlu oluhlayo. Oku kuya kukuvumela ukuba wenze utshintsho⁤ kuqwalaselo lwe-MariaDB.

Isinyathelo esilandelayo kukulungisa ifayile ye-my.ini yoqwalaselo ebekwe kwifolda yokufaka i-MariaDB. Ungayifumana le fayile kwindlela C: Iifayile zeNkquboMariaDB ⁣10.6data. Vula ifayile usebenzisa umhleli wombhalo kwaye ujonge i [mysqld] icandelo. Apha kulapho unokwenza khona utshintsho kuqwalaselo ⁢MariaDB. Ezinye zezona parameters zibalulekileyo ekufuneka ziqwalaselwe kuqwalaselo lwezibuko, ubungakanani bepakethe enkulu, kunye noqwalaselo lwenjini yokugcina. Qinisekisa ukugcina utshintsho lwakho xa lugqityiwe.

Ukwenza oku kubalulekile ukuqinisekisa ukusebenza ngokupheleleyo kwedatha. Landela la manyathelo akhankanywe ngasentla ukuvula iwindow yomgca womyalelo njengomlawuli kwaye uhlele ifayile ye-my.ini yoqwalaselo. Khumbula ukugcina utshintsho lwakuba lwenziwe. Ulungelelwaniso olufanelekileyo lunokuphucula ukusebenza kunye nokhuseleko lwedatha yakho ye-MariaDB kwi-Windows. Nje ukuba uwagqibile la manyathelo, uya kuba ukulungele ukusebenza noMariaDB kwinkqubo yakho yeWindows.

5. Ukufikelela kwi-interface yomgca womyalelo we-MariaDB kwi-Windows

Uyinxalenye ebalulekileyo yokusebenza nale database inamandla. Ngomgca womyalelo, abasebenzisi bangenza imiyalelo kunye nemibuzo ngokuthe ngqo kwisiseko sedatha. Oku ⁢kubonelela ngolawulo olukhulu kunye nokubalula kulawulo lwedatha.

Ukufikelela kumgca womyalelo weMariaDB kwiWindows, kufuneka uqale uvule iwindow yomyalelo. Unokwenza oku ngokucofa iqhosha leWindows + R kwaye emva koko uchwetheze "cmd." Nje ukuba iwindow yomyalelo ivuleke, kufuneka ufake uluhlu apho uMariaDB efakwe khona. Ngokuqhelekileyo, le yi C: Iifayile zeNkquboMariaDBMariaDB< version>bin, uqinisekisa ukuba ubeka enye indawo < inguqulo > ‍ noguqulelo oluthile olufakileyo.

Nje ukuba ukuluhlu oluchanekileyo, ungasebenzisa "mysql" umyalelo wokuqalisa ujongano lomgca womyalelo we-MariaDB. Oku kuya kukusa kwi-MariaDB ekhawulezayo, apho unokufaka khona imiyalelo kunye nemibuzo. Ukuba ufuna ukufikelela kwisiseko sedatha ethile, ungasebenzisa "sebenzisa <igama ledatha>" ukuze ukhethe. Ukusuka apho, ungenza imisebenzi eyahlukeneyo, efana nokwenza iitafile, ukufaka idatha, kunye nokuqhuba imibuzo enzima. ⁢Khumbula ukuba kubalulekile ukuba nolwazi lwangaphambili lwemiyalelo ye-MariaDB yokusebenza ngokufanelekileyo kujongano lomgca womyalelo.

6. Ukudala nokulawula i-database kwi-MariaDB ye-Windows

Kule posi, siza kukubonisa ukuba njani faka uMariaDB kwiWindows kunye nendlela yokwenza kunye nokulawula ugcino lweenkcukacha kweli qonga. I-MariaDB yinkqubo evulekileyo yolawulo lwesiseko sedatha ethe yaba yinto edumileyo kwi-MySQL. Abaphuhlisi abaninzi kunye nabalawuli bedatabase⁤ bakhetha ukusebenzisa iMariaDB ngenxa yokusebenza kwayo, ukukala, kunye nokuphuculwa kokhuseleko.

Ukuqala khuphela uguqulelo olufanelekileyo lweMariaDB yeWindows kwiwebhusayithi yayo esemthethweni. Qinisekisa ukuba ukhetha uguqulelo oluhambelanayo nesixokelelwano sakho sokusebenza. Nje ukuba ifayile yokuhlohla ikhutshelwe, cofa kabini ukuqalisa inkqubo yokuhlohla.

Nje ukuba uyifakile iMariaDB kwinkqubo yakho, lixesha lokuba dala kwaye ulawule oovimba beenkcukacha. Ungasebenzisa ilayini yomyalelo, ujongano lomsebenzisi womzobo, okanye izixhobo zolawulo ezifana nephpMyAdmin. ‍ Ukufikelela kumgca womyalelo we-MariaDB, vula iwindow yomyalelo kwaye uchwetheze. mariadb ilandelwe ngu -u tu_usuario -p ukungena ngegama lakho lomsebenzisi kunye negama lokugqitha. Ukusuka apha, ungaqhuba imiyalelo yeSQL ukwenza nokulawula idatabase yakho.

7. Ukuqwalasela amalungelo omsebenzisi kwi-MariaDB ye-Windows

Nje ukuba ufake i-MariaDB kwinkqubo yakho yeWindows, kubalulekile ukuqwalasela amalungelo afanelekileyo omsebenzisi ukuqinisekisa ukhuseleko kunye nokufikelela okuchanekileyo kwisiseko sedatha. Ngethamsanqa, uMariaDB ubonelela ngeseti yezixhobo zokulawula amalungelo omsebenzisi ngokufanelekileyo.

Ukuze uqalise, kufuneka uvule ujongano lomgca womyalelo we-MariaDB ngokuqhuba umyalelo i-mysql ukusuka kwi-command prompt. Oku kuya kukuvumela ukuba ufikelele kwi-console yolawulo ye-MariaDB. Nje ukuba ungaphakathi, ungaqala ukulawula amalungelo omsebenzisi usebenzisa imiyalelo ethile.

Elinye lamanyathelo okuqala kukwenza umsebenzisi omtsha ngamalungelo afanelekileyo. Ukwenza oku, ungasebenzisa umyalelo DALA UMSEBENZISI. Umzekelo, ukuba ufuna ukwenza umsebenzisi ogama lingu "user1" ngegama lokugqitha "password1", ungaqhuba lo myalelo ulandelayo:
«`
YENZA UMSEBENZISI 'user1'@'localhost' UCHONGWE 'LIBHAYIBHILE1';
«`
Emva koko, kuya kufuneka unikeze amalungelo ayimfuneko kumsebenzisi omtsha owenziweyo. Ungayenza usebenzisa umyalelo ISIBONELELO. Umzekelo, ukuba ufuna ukunika u-"user1" onke amalungelo okufikelela kwisiseko sedatha ebizwa ngokuba yi "database1", ungasebenzisa lo myalelo ulandelayo:
«`
NIKEZA ONKE AMALUNGELO KWISIGQEBA 1.* 'Umsebenzisi1'@'localhost';
«`
Khumbula ukuba kufuneka uhlaziye amalungelo ukuze utshintsho lusebenze usebenzisa umyalelo FLUSH⁣⁣ AMALUNGELO. Ngale nto, uye waqwalasela ngempumelelo amalungelo omsebenzisi kwi-MariaDB yeWindows, eya kukuvumela ukuba ulawule kwaye ulawule ukufikelela kwisiseko sedatha. ngokukhuselekileyo.

8. Ukusombulula iingxaki eziqhelekileyo ngexesha lofakelo lwe-MariaDB kwiWindows

Nje ukuba ugqibe ukufaka i-MariaDB kwinkqubo yakho yokusebenza yeWindows, unokuhlangabezana neengxaki eziqhelekileyo ngexesha lofakelo Ngethamsanqa, uninzi lwezi ngxaki zinezisombululo ezilula nezikhawulezayo. Ngezantsi, siza kukubonelela ngezisombululo eziqhelekileyo zokukunceda usombulule eyona miqobo ixhaphakileyo.

1. Impazamo yokuxhomekeka: ⁤ Umyalezo wemposiso unokuvela ngexesha lofakelo olubonisa ukuba ezinye izinto ezixhomekeke kuwe azikho. Ukulungisa lo mbandela, qiniseka ukuba unesofthiwe efunekayo efakwe, njengePhakeji ye-Visual C ++ Redistributable Package kunye ne-.NET Framework. Ukuba ukuxhomekeka okuyimfuneko akufakiwe, khuphela kwaye uzifake ngaphambi kokuba uzame ukufaka i-MariaDB kwakhona.

2. Ingxaki yodonga lomlilo: Ukuba i-firewall yakho ivala ukufakwa kwe-MariaDB, kubalulekile ukuyicima okwethutyana ngexesha lofakelo. Unokwenza oku ngokuya kuseto lweWindows firewall kwaye ukhethe ukhetho lokuyikhubaza. Nje ukuba ufakelo lugqityiwe ngempumelelo, khumbula ukwenza i-firewall kwakhona ukugcina ukhuseleko lwenkqubo yakho.

9. Ukuhlaziya i-MariaDB kwi-Windows: IiNdlela eziPhambili zokuSebenza kunye neziQinisekiso zokuThatha

Enye yeenzuzo eziphambili zeMariaDB kukukwazi ukuhlaziya iinkqubo zokusebenza IiWindows ngokulula nangokukhuselekileyo. Nangona kunjalo, kubalulekile ukugcina engqondweni ezinye⁤ ezona zenzo zilungileyo kunye nezilumkiso eziphambili phambi kokwenza inkqubo yohlaziyo. La manyathelo aya kuqinisekisa ukuthembeka kwedatha kunye nokusebenza okuchanekileyo kweseva yedatha.

1. Yenza isipele igqityiwe: Ngaphambi kokuba uqhubeke nokuphuculwa kwe-MariaDB, kucetyiswa kakhulu ukuba uthathe i-backup epheleleyo yazo zonke iinkcukacha kunye neefayile ezinxulumene nazo. Oku kubalulekile ukukhusela ulwazi xa kukho into engahambi kakuhle ngexesha lenkqubo. Ungasebenzisa izixhobo zogcino ezifana⁣ mysqldump okanye izisombululo zokhuseleko lomntu wesithathu ukufezekisa umsebenzi. Qinisekisa ukuba i-backup igcinwe kwindawo ekhuselekileyo kwaye iyafikeleleka xa ufuna ukuyibuyisela.

2. Qinisekisa ezona mfuno ziphantsi zenkqubo: Ngaphambi kokuba uqalise uphuculo, qiniseka ukuba inkqubo yakho ihlangabezana neyona nto incinci yehardware kunye neemfuno zesoftware ukuxhasa uguqulelo lwamva nje lweMariaDB. Oku kunokubandakanya uguqulelo lwesixokelelwano sokusebenza, isixa⁤ se-RAM, indawo ekhoyo kwidisk, phakathi kwezinye. Bona uxwebhu olusemthethweni lwe-MariaDB ngeenkcukacha ezithe ngqo⁤ malunga neemfuno zenguqulelo oyiphuculayo.

3. Khubaza iinkonzo kwaye uvale iseva: Ngaphambi kokuqala ukuphuculwa, kufuneka ukhubaze zonke iinkonzo ezinxulumene ne-MariaDB kwaye uqinisekise ukuba umncedisi uvaliwe. Oku kuya kuthintela naziphi na iingxabano okanye ukuphazamiseka ngexesha lohlaziyo. Unokusebenzisa uMphathi weNkonzo yeWindows ukuvala iinkonzo ezihambelanayo. Kwakhona, qiniseka ukuba ukwazisa bonke abasebenzisi kunye nezicelo ezifikelela kwiseva ngenjongo yakho yokwenza uhlaziyo, ukuphepha nakuphi na ukuphazamiseka okanye ukulahlekelwa ngumsebenzi ngexesha lenkqubo.

10. Iingcebiso ezongezelelweyo zokusetyenziswa ngokufanelekileyo nangokukhuselekileyo kwe-MariaDB kwi-Windows

1. Ubumbeko lweWindows Firewall:

Kubalulekile qwalasela kakuhle iWindows Firewall ukuvumela ufikelelo kwi-MariaDB.⁣ Qinisekisa ukuvumela itrafikhi yenethiwekhi yezibuko u-MariaDB amamele kuyo, eqhele ukuba yi-port 3306. Ungaphinda ucinge ngokusebenzisa isisombululo seFirewall somntu wesithathu ukunika ukhuseleko olukhulu kwizoyikiso zangaphandle.

2. Uhlaziyo lwarhoqo lwe-MariaDB:

Ukugcina ufakelo lwakho lwe-MariaDB lukhuselekile kwaye lungenabo ubuthathaka obaziwayo, kunjalo uhlaziyo rhoqo kubalulekile. Jonga rhoqo iphepha lokukhuphela kwiwebhusayithi esemthethweni ye-MariaDB ukuze uqinisekise ukuba usebenzisa inguqulelo yamva nje ezinzileyo kwaye usebenzise naluphi na uhlaziyo oluyimfuneko.

3. Iikopi izinto eziqhelekileyo:

Ukuthintela ukulahleka kwedatha kwimeko yokungaphumeleli kwenkqubo okanye ukuhlaselwa kwe-cyber, kunjalo Kubalulekile ukwenza i-backups rhoqo kwidatabase yakho. Ungasebenzisa izixhobo zomntu wesithathu okanye izikripthi zesiko ukwenza ngokuzenzekelayo le nkqubo kwaye uqinisekise ukuba idatha yakho zikhuselekile.