/ Uyenza njani indawo yedatha kwi-MySQL inyathelo ngenyathelo?

Funda uku Uyenza njani isiseko sedatha kwi-MySQL , into esetyenziswa ngokubanzi ngoku ngamaphepha ewebhu ukugcina irekhodi lakho kunye nolwazi kwiseva yakho, funda ngako konke oku kweli nqaku ngolwazi oluyinyaniso nolulungileyo.

indlela yokwenza i-database-kwi-myqsl-2.

Uyenza njani inyathelo ledatha ngenyathelo

/ Uyenza njani isiseko sedatha kwi-MySQL?

Okwangoku, nabani na ofuna ukurekhoda umsebenzi wabo okanye idatha basebenzisa olu hlobo lweseva ukuba babe nesiseko sedatha esithembekileyo nesikhuselekileyo. Nangona kunjalo, ayinguye wonke umntu owaziyo ukuba angayenza njani kwaye bayathintelwa, ngakumbi ngesifundo sethu, uya kuyazi inyathelo ngenyathelo ukuba uyile njani indawo yedatha eneqonga elahlukileyo.

Uyenza njani isiseko sedatha usebenzisa iLinux?

  1. Ngezinye iindlela ukwenza isiseko sedatha, sebenzisa iLinux njengesixhobo esiphakathi yenye yezona zilula. Kuya kufuneka ufake i-MySQL kwaye usebenzise ikhonsoli.
  2. Kwikhonsoli, kufuneka singene njengengcambu, okt njengomlawuli. Ingcambu akufuneki ifane nomsebenzisi wedatha, kuba inokukhokelela kwiingxaki zokubhala.
  3. Kuqala beka "yenza i-database db_name". Eli iya kuba lelona gama kanye ledatha kwaye liya kunceda ukuyila.
  4. Umsebenzisi onxulumene nesiseko sedatha ubekwe: "yenza i-database db_name" * ukuya "kumsebenzisi" "@"
  5. Emva koko, kubekwe "i-localhost", oko kukuthi, indawo yangoku yeseva yakho okanye enye ip: "yenza indawo yedatha db_name" * ukuya "kumsebenzisi" "@" "localhost"
  6. Iphasiwedi yomsebenzisi wedatha ibekiwe, kuyacetyiswa ukuba kusetyenziswe iipaswedi ekunzima ukuziqhekeza, kuba idatha yakho yabucala iya kugcinwa apha: inombolo yokuvula ".

Uyenza njani isiseko sedatha usebenzisa iCanel?

I-CPanel sisixhobo sokulawula idatha yewebhu yokugcina iiseva, ukunika imvume kunye nokusebenzisa i-automation ukuthumela idatha okanye ukunika iimvume kwiziko ledatha. Sebenzisa isoftware ekuvumela ukuba ulawule ngokulula isiseko sedatha, ngaphandle kweengxaki ezininzi; I-MySQL yenye yeeseva ezisingathwa yiPanel, apha siza kukubonisa indlela yokwenza i-database ngeqonga, ngaphandle kokusebenzisa ipaneli yokulawula ye-MySQL:

  1. Kuqala kufuneka ungene kwiCanel kwaye ujonge imenyu yesixhobo.
  2. Kwimenyu, kufuneka kubekho ungeniso oluthi "Ugcino lwedatha". Xa kuvulwa, kufanele ukuba kubekho iinketho ezininzi zedatha, kuya kufuneka ujonge leyo ithi "Iinkcukacha zeMySQL".
  3. Ngoku, siya kuba kujongano oluya kusivumela ukuba sihlele, sicime okanye senze isiseko sedatha ngokuthanda.
  4. Cinezela olo khetho kwaye baya kufaka igama abalithandayo kakhulu okanye elinxulunyaniswa kakhulu kwiziko ledatha labo.
  5. Iwindow iya kuvela eya kuba negama elibekwe kwindawo yogcino lwedatha, eya kuthi icele umsebenzisi weCanel, ufake igama abalifunayo. Okokugqibela, jonga ukhetho "lokudala".
  6. Emva kokwenza isiseko sedatha, iya kucela igama lomsebenzisi le-MySQL, kuba baya kuqinisekisa ukuba sinento enxulumene neqonga. Ngenisa igama lomsebenzisi kunye ne-voila, uya kuba nedathabheyisi yakho eqhagamshelwe kwi-cPanel interface.

Ukuba awunaye umsebenzisi kwi-MySQL, ungothuki, siza kuchaza inyathelo ngenyathelo ukuba umenza njani umsebenzisi, ukuze ube nokufumana isiseko sedatha.

Uyenza njani isiseko sedatha kwi-MySql

I-interface yeCPanel yeqonga

/ Uyenza njani umsebenzisi kwi-MySQL?

  1. Sifaka iCanel kwakhona kwaye sijonge kwimenyu yolu khetho "lweDatabase".
  2. Sele ngaphakathi kukhetho, siza kujonga phakathi kwezinye iindlela ezikhoyo ezinokuthi: «Abasebenzisi be-MySQL», siya kungena apho.
  3. Sele sele sikhethile, siya kusivumela ukuba senze umsebenzisi kwaye senze iphasiwedi. Kuyacetyiswa ukuba iphasiwedi ibe kwinqanaba eliphezulu, kuba umbono kukuyikhusela kulo naluphi na uhlobo lokoyikisa.
  4. Emva kokufaka igama lomsebenzisi kunye negama lokugqitha lokukhetha kwethu, siya kuphinda siqinisekise iphasiwedi kwaye nqakraza ku "yenza umsebenzisi".

Sele unalo igama lomsebenzisi ledatha yakho kunye nesitshixo sedatha yakho, ukuyila kwaye uyisebenzise ngendlela othanda ngayo. Nangona kunjalo, ayisiyiyo yonke into egqibeleleyo, ngoku kuya kufuneka unike amaxabiso ngendlela ekhethekileyo ukuze unxibelelwano lwabo kwiziko ledatha yeyona ndlela ikhululekileyo.

/ Ungawongeza njani amalungelo kumsebenzisi we-MySQL?
  1. Siya kwimenyu yeCanel kwaye sijonge kwakhona ukhetho "lweeDatha".
  2. Siza kujonga ukhetho oluthi «Yongeza umsebenzisi kwindawo yogcino lwedatha». Inketho isetyenziselwa ukunika amalungelo umsebenzisi xa ulawula isiseko sedatha.
  3. Singena umsebenzisi wethu owenziweyo, ongumlawuli wedatha, ukuze simnike ilungelo.
  4. Emva kokungena kumsebenzisi, igama ledatha lingenisiwe kwaye, ekugqibeleni, sidibanisa zombini.
  5. Nje ukuba inyathelo lokongeza ligqityiwe, kuya kuvela ukhetho oluya kusivumela ukuba silawule yonke into anokuyisebenzisa umsebenzisi kwiziko ledatha; "Lawula amalungelo omsebenzisi" lukhetho. Umsebenzisi kunye nesiseko sedatha sibonisiwe kwakhona.
  6. Izinketho okanye ulawulo lwamalungelo anokuba nalo umsebenzisi, sele luxhomekeke kuthi nakumsebenzi onawo kwiziko ledatha. Sincoma ukukhetha "onke amalungelo" ukhetho, ukuze ngale ndlela umsebenzisi akwazi ukulawula indawo yogcino lwedatha njengoko enqwenela okanye aphathe isiseko sedatha ngeyona ndlela ifanelekileyo.
  7. Ukugqibezela yonke into eyenziweyo, khetha ukhetho "Yenza utshintsho" kwaye yonke into iyakwenziwa, ungasebenza kwindawo yogcino lwedatha xa unako kwaye unqwenela njalo.
/ Ubabona njani ukuba ngabaphi abasebenzisi ababelwe kwiziko ledatha?

Unokuba nabantu abaliqela abasebenza kwiziko ledatha elinye kwaye ufuna ukwazi ukuba ngubani owenza into kwindawo yogcino lwedatha, siza kukucacisela ukuba masenze ntoni ukuze sazi. Into yokuqala kukuya kwimenyu yeqonga kwaye ujonge ukhetho "Oovimba beenkcukacha zangoku".

Ugcino lwedatha lwangoku luya kukuvumela ukuba ubone ukuba ngubani okwindawo yedatha, ungayihlela okanye uyicime ukuba uyafuna, nantoni na ocinga ukuba iyimfuneko.

Uyenza njani i-DB ngeendlela ze phpMyadmin?

I-PhpMyadmin, lukhetho olufanelekileyo lokulawula i-MySQL, ukuze ulawule isiseko sedatha ngokuchanekileyo. Isebenzisa ulwimi lwe-PHP, ukuze ibe nokuphatha okumnandi ngakumbi kwiziko ledatha, konke ngendlela ebonakalayo kunye nenjongo yokuphatha i-MySQL kuphela.

Siza kuchaza inyathelo ngenyathelo ukuba uyenza njani indawo yakho kwi-MySQL, ngokukhawuleza nangokulula, kwiqonga le-phpMyadmin:

  1. Ngena iqonga le-phpMyadmin kwaye ujonge ukhetho kwimenyu. Iya kujonga ukhetho "lweeDatha" kwindawo yokusebenza.
  2. Emva kokucinezela ukhetho lwedatha, iya kujonga ukhetho "Yenza iidathabheyisi", eziya kubonisa iindawo ezingenanto zokugcwalisa idatha. Idatha eyifunayo ligama esifuna ukulibeka kwindawo yogcino lwedatha.
  3. Emva koku siza kunika inketho "yokuHlanganisa", eqinisekisa indawo okanye iphepha ledatha. Siphela ngokuyinika «Yenza» ukuqinisekisa yonke into.
  4. Emva kokwenza isiseko sedatha kufuneka songeze umsebenzisi oza kulawula isiseko sedatha, ngenxa yoku, singena kwindawo yolwazi kwaye siya kujonga ukhetho "lomsebenzisi". Kukhetho lomsebenzisi, siya kongeza umsebenzisi kwaye iindawo ezininzi ezingenanto kuya kufuneka ziphendulwe.
  5. Siza kubhala igama lomsebenzisi, eliya kuba lelona lilawulwa yiseva yethu yokugcina idatha, ukongeza, siya kwabela amalungelo umsebenzisi afuna ukuwagcina kwindawo yogcino lwedatha. Iya kwamkelwa ngokubetha u "Faka isicelo", eya kuthi yenziwe ngumsebenzisi kwaye iya kubambelela kwisiseko.
  6. Ngoku, siya kuhlelela amalungelo esifuna ukuba umsebenzisi abe nawo. Umsebenzisi uya kukhangelwa kwaye ukhetho «Hlela amalungelo» uya kucinezelwa ukubonisa amalungelo.
  7. Emva kokucinezela olu khetho, kuya kuvela enye indlela eza kuthi "Amalungelo athile kwiziko ledatha", apho siya kuthi sijoyine yonke into enxulumene nesiseko sedatha nomsebenzisi. Sigqibezela yonke inkqubo sisebenzisa ukhetho "Faka isicelo".

Uyenza njani i-MySQL DB kwiWindows?

IWindows yenye yezona nkqubo zinkulu zokusebenza ehlabathini, ezisetyenziswa ziinkampani nabasebenzisi. Siza kukufundisa indlela yokwenza i-MySQL database kwiWindows.

  1. Ngenisa iphepha leWindows kwaye ujonge ukhetho lweWindows yeWindows. Izakujonga ukhetho oluthi "Isiseko sedatha ye-MySQL" kwaye ucofe.
  2. Inika ithuba lokukhetha "Yenza isiseko sedatha" kwaye ubhale igama ledatha, ukongeza, iya kugcwalisa imihlaba eceliweyo. Xa yonke into igqityiwe, cofa Kulungile ukwenza isiseko sedatha.
  3. Ukhetho lokwenza umsebenzisi luya kuvela, ucofe kwaye ufake igama olithandayo kwi-password yakho, igama eliyimfihlo kufuneka libe kwinqanaba eliphezulu ukukhusela iserver kunye nolwazi. Inika iimvume ezibona ziyimfuneko ukulawula isiseko sedatha.
  4. Emva kokuqinisekisa isiseko sedatha kunye nomsebenzisi, uya kulwamkela kwaye ulugcine utshintsho. Uya kuba nesiseko sedatha yakho kwaye unokufaka yonke into oyifunayo kwinkqubo oyithandayo.

Yintoni i-MySQL?

Sele sichazile ukuba ungasenza njani isiseko sedatha kule venkile yolwazi, nangona kunjalo, usenokungazi ukuba yintoni i-MySQL okanye yeyantoni. I-MySQL liqonga lokugcina ulwazi ngamanani amakhulu kwi-Intanethi, zonke zenziwe kwindawo yogcino lwedatha.

I-MySQL lelinye lamaqonga asetyenziswa kakhulu kwihlabathi ukugcina idatha, ke ngoko, yayithengiwe kwaye isetyenziswa yiOracle, iqonga lokugcina idatha efini, ngale ndlela ibonelela ngeendlela ezihlawulelwayo nezasimahla kuluntu, ukuze uneseva yedatha eqhagamshelwe kwilifu lakho.

Ugcino lwedatha ye-MySQL iyahambelana namaqonga awahlukeneyo kunye neewebhusayithi, ezinokunxibelelana nazo kwaye zigcine lonke ulwazi onokulufumana kwidatha okanye kwiifayile ezenziwe kwezi zicelo. Iiplatifomu ezinqamlezileyo kunye neelwimi ezinje nge-PHP okanye i-PHP-FPM zinokusetyenziswa.

Yinkqubo ekhuselekileyo, ngaphandle kweziphene kwaye isetyenziswa ziinkampani ezinkulu, kuba zifuna ukugcina idatha kunye nolwazi lwabo kubantu besithathu, ukongeza ekubakhuseleni kuhlaselo lwe-cyber olunokwenzeka.

Ukuba ulithandile inqaku, ndiyakumema ukuba ufunde malunga: » Izakhiwo ezilandelelanayo Ziyintoni kwaye ziyintoni? » , inqaku elichaza imiyalelo elandelwe ngokulandelelana kunye nobudlelwane bayo nehlabathi leenkqubo. Ndiyazi ukuba uza kuyonwabela.


Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: Okwenziweyo Ibhlog
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.