Sikufundisa indlela yokufaka iMySQL kwiWindows

Abaphathi bedatabase zizixhobo ezibalulekileyo kuyo nayiphi na iprojekthi efuna ukuphatha imiqulu eyahlukeneyo yolwazi. Ngaloo ndlela, I-MySQL imele enye yezona ndlela zidumileyo kwiimarike ngenxa yezizathu ezahlukeneyo ezibandakanya, ngaphezu kwayo yonke into, into yokuba ikhululekile kwaye ivulekile.. Nangona kunjalo, ukufakela kwayo kubandakanya uthotho lwamanyathelo ahlala esoyika, ngakumbi abo baqala kweli hlabathi. Ngoko, Siza kukubonisa yonke into ofuna ukuyazi malunga nendlela yokufaka i-MySQL kwikhompyuter yakho yeWindows..

Ngale ndlela, kuya kukwanela ukuba ulandele imiyalelo ngelixa uqhuba inkqubo, ukubandakanya esi sixhobo sesiseko sedatha kwinkqubo yakho.

Yintoni i-MySQL?

Ngaphambi kokuba uqale ngenyathelo ngenyathelo ukufaka i-MySQL kwiWindows, kufanelekile ukwazi ukuba le software imalunga nantoni. I-MySQL yinkqubo ejoliswe kulawulo lweedatha zobudlelwane, njengoko i-Oracle enkulu, inelayisenisi ephindwe kabini, oko kukuthi, i-General Public yokusetyenziswa simahla kunye nolunye uRhwebo.. Ngale ndlela, uya kuba nakho ukufikelela kwizibonelelo zomphathi simahla, nangona inkampani inezinye iindlela eziphantsi kwentlawulo.

Nangona kunjalo, sithetha ngenkqubo yesiseko sedatha ethandwa kakhulu kwihlabathi kwaye oko kungenxa yokuba sinokuthembela kwi-100% yamandla ayo asimahla kwaye ngokukhululekileyo. Kwakhona, sinesampulu yento esikwaziyo ukuyenza esi sixhobo, ekubeni sisetyenziswa zizigebenga ezifana noFacebook, Twitter okanye YouTube..

Amanyathelo okufaka iMySQL kwikhompyuter yakho yeWindows

Indlela yokufaka i-MySQL kwi-Windows ngumbuzo onokubonakala unzima ekusebenzeni ngenxa yenani lamanyathelo abandakanyekayo. Nangona kunjalo, apha sikubonisa ukuba ilula ngokwenene.

Kuthotywa umthwalo weMySQL

Okokuqala, siya kuqhubeka nokukhuphela inguqulo ye-GPL ye-MySQL eya kukuvumela ukuba usebenzise isofthiwe simahla kwaye ngokukhululekileyo.. Ukwenza oku, faka ifayile website esemthethweni kwaye uye kwicandelo «Iyakhuphela«, ibekwe phezulu kujongano.

Uya kwiphepha lokukhuphela, nangona kunjalo, ikhonkco elinomdla kuthi lisezantsi kwesikrini esichongwe njenge «Ukhuphelo lweMySQL Community (GPL).«.

Ngokukhawuleza, yiya kwicandelo le-MySQL Installer kwaye ukhethe inkqubo yokusebenza apho uya kuyifaka khona. Kwimeko yethu, yiWindows. Oku kuya kuvelisa iinketho ezimbalwa zokukhuphela ezinegama elifanayo, kodwa ubungakanani obahlukeneyo, enye 2.4MB kunye ne435.7MB enye.

Eyokuqala ayikho enye into ngaphandle kwe-installer ye-intanethi, ngoko ke ukuba unonxibelelwano oluhle lwe-intanethi, ungayisebenzisa. Ngokwenxalenye yayo, eyesibini inzima kuba lukhetho olungaxhunyiwe kwi-intanethi, oko kukuthi, isifakeli esinawo onke amacandelo.. Olu khetho luluncedo ukuba awunaso isantya sokhuphelo oluninzi kwaye ufuna ukuyifaka ngokukhawuleza.

Okulandelayo, indawo izakubonisa umyalezo wokuba wenze iakhawunti kwaye ungene, nangona kunjalo, ungayinqanda kukhetho olusezantsi «Hayi enkosi, vele uqale ukukhuphela kwam«.

Ukuhlohla i-MySQL

Nje ukuba ifayile yokumisela ikhutshelwe, yiqhube ngamalungelo omlawuli ukunqanda nayiphi na imiba yemvume. Ukwenza oku, kufuneka ucofe ekunene kwi-installer kwaye ukhethe "Baleka njengomlawuli".

Ngoko nangoko isikrini sokuqala senkqubo siya kuboniswa, apho Kufuneka samkele imigaqo kunye neemeko kwaye emva koko ucofe ku "Okulandelayo".

Okulandelayo, kufuneka sikhethe uhlobo lofakelo esifuna ukulwenza kwinkqubo yethu. I-MySQL ibonelela ngolu hlobo lulandelayo:

uMphuhlisi oMiselweyo: Inawo onke amacandelo ayimfuneko kwimo engqongileyo yophuhliso. Olu khetho lulolona lucetyiswayo kuye wonke umntu, kuba lubandakanya oko kufunwa ngokungagqibekanga kulawulo nokudalwa kogcino-lwazi.
iseva-kuphela: Olu khetho luza kufaka kuphela amacandelo e-MySQL Server, oko kukuthi, yintoni efunekayo ukugcina ugcino lweenkcukacha kwaye ufumane imidibaniso.
Umxhasi kuphela: Ngale ndlela uya kufumana kuphela umxhasi weMySQL. Iluncedo kwabo bafuna kuphela ukudibanisa kumncedisi kwikhompyuter yabo.
Pheleleyo: lufakelo olupheleleyo lwe-MySQL Server. Nangona ithatha indawo enkulu yokugcina, yenye yeendlela ezicetyiswayo kwabo bangafuniyo ukuntsonkotha kakhulu.
isiko: Olu lufakelo lwesiko, apho ungakhetha khona amacandelo ofuna ukuwabandakanya. Kucetyiswa kubasebenzisi abaphambili.

Kwinyathelo elilandelayo, umfaki uya kubonisa uluhlu lwe MySQL software ukuba yongezwe kunye nokukwazi ukongeza iinketho ezintsha. Ukuba unazo naziphi na iimfuno ezongezelelweyo zokulawula idatabase yakho, ungazongeza apha.

Emva koko, Uya kuya kwiimfuno zenkqubo yokuqinisekisa isikrini apho isixhobo siya kuqinisekisa ukuba unayo yonke into oyifunayo ukuyiqhuba. Ngesiqhelo, le yindawo apho uqala khona ufakelo lweMicrosoft Visual C++ ukuba awunayo.

Inyathelo lokugqibela, phambi kokufaka, kukubona isishwankathelo senkqubo yonke kunye nezixhobo eziya kufakwa.. Ukuba yonke into ichanekile, cofa kwiqhosha elithi "Okulandelayo" ukuqalisa ukufakela.

Ukuqwalasela i-MySQL

Emva kokufakela, iwizadi iya kuhlala ivulekile kuba kufuneka siye kuqwalaselo lweMySQL. Eli nyathelo libalulekile ekusebenzeni kwalo okuchanekileyo kokubini kulawulo lwemithombo kunye nakunxibelelwano lwenethiwekhi.

Okokuqala kufuneka sikhethe ukuba umncedisi uya kusebenza njani phakathi kweenketho ezimbini ezinikezelwa yi-MySQL:

Iseva ye-MySQL ezimeleyo / i-Classic MySQL Replication
Ibhokisi yeSandbox InnoDB ukuSeta iQela.

Ukhetho lokuqala lolona lucetyiswayo, kuba luyakuvumela ukuba usebenze njengomncedisi omnye okanye wokuphindaphinda.. Kwinxalenye yayo, inketho yesibini ijolise kwezo zincedisi eziza kuba yinxalenye yeqela ledatha.

Kamva, kufuneka sichaze uhlobo lomncedisi we-MySQL esiwufunayo, oku kuyakuvumela isixhobo ukuba sithathe olona qwalaselo lufanelekileyo kusetyenziso ofuna ukusinika lona.. Ngaloo ndlela, cofa kwi "Udidi loLungiselelo" imenyu eyehlayo kwaye uya kubona iinketho ezikhoyo:

IKhompyutha yoPhuhliso: Olu lolona khetho lugqibeleleyo kwabo basebenza zombini iseva yeMySQL kunye nomxhasi wombuzo kwikhompyuter enye.
iserver-computer: ijoliswe kwiiseva apho ungadingi kuba nomxhasi osebenzayo.
Ikhompyuter ezinikeleyo: Le ndlela ingenye yeyabo matshini bazinikele ngokupheleleyo ekusebenziseni i-MySQL, ngoko ke izixhobo zabo ziya kuhlala ngokupheleleyo sisixhobo.

Kwiimeko eziqhelekileyo zoqwalaselo, sihlala sikhetha ukhetho lokuqala.

Emva koko, kwisikrini esifanayo siya kulungelelanisa oko kunxulumene noqhagamshelwano. Ngaloo ndlela, yenza i "TCP/IP" ibhokisi ngePort 3306 kwaye ukhumbule ukuyivula kumzila wakho ukuvumela uqhagamshelo olukude.. Sishiya intsalela njengoko injalo kwaye ucofe ku "Okulandelayo".

Apha siza kulungelelanisa oko kunxulumene nokufikelela kunye nokuqinisekiswa. Ngele ndlela, Kuya kufuneka unike umsebenzisi oyingcambu igama eligqithisiweyo kwaye unokongeza abasebenzisi abongezelelweyo.

Isinyathelo esilandelayo kukuqwalasela igama lenkonzo ye-MySQL kwiWindows kunye nendlela ofuna ngayo ukuba iqhube. Ke, uya kukwazi ukukhetha ukuba ufuna iqale ngeemvume zeakhawunti yendawo okanye nomsebenzisi owenzelwe isixhobo. Oku kuya kuxhomekeka ngokupheleleyo kwindlela olawula ngayo iiseva zakho.