I-MySQL ithathelwa ingqalelo enye yeenkqubo zolawulo lwedatha, ngenxa yoko isetyenziswa ngenkuthalo zombini iingcali kunye nabathandi ekusebenzeni neewebhusayithi kunye nezicelo ezahlukeneyo. Ukusebenza ngokuchanekileyo kwesi sixhobo, kuya kufuneka ukufakwe kwinkqubo yokusebenza kwaye kuseta ubumbeko oluchanekileyo, ukutyhala kumasela akhoyo kunye nezinto ezongezelelweyo. Namhlanje sifuna ukubonisa indlela eqhutywa ngayo le nkqubo kwiikhompyuter ezisebenzayo ze-CEGOS 7.
Faka i-MySQL eCenntos 7
Olu lwazi kwinqaku lethu langoku luzahlulahlulwahlulwahlulwahlulwa ukuba umsebenzisi ngamnye aqonde ngqo ukuba icandelo eliphantsi kongezwa kwi-Linux, kunye neeparamitha kufuneka zihlawulwe kuqala. Ngokukhawuleza cacisa ukuba ukufakelwa kunye nokunxibelelana ngakumbi nge-MySQL uya kufuna uqhagamshelo lwe-Intanethi olusebenzayo, kuba ogcino luya kufunyanwa kwi-Reportporithi yaseburhulumenteni.Inyathelo 1: Izenzo zangaphambili
Ewe kunjalo, unokuqhubeka ngokukhawuleza kwinyathelo elilandelayo kwaye wenze ufakelo, nangona kunjalo, kuya kuba yimfuneko ukumisela igama lomamkeli kwaye uqiniseke ukuba i-Centos ngoku inohlaziyo lwakutshanje. Lungisa le miyalelo ilandelayo ukulungiselela i-OS.
- Ezi kunye nazo zonke iintshukumo ezilandelayo ziya kwenziwa nge-terminal, ngokulandelelana, kuya kuba yimfuneko ukuba ubaleke kakuhle kuwe. Ungayenza le nto ngemenyu yesicelo okanye unciphise i-CTRL + Alt + T. indibaniselwano ephambili.
- Apha ngena umyalelo wegama lenginginya kwaye ucofe u-Enter.
- Ukongeza, chaza igama lenginginya -f kwaye uthelekise iziphumo ezibini. Eyokuqala igqityiwe, kwaye okwesibini - ifinyeziwe. Ukuba ikufanele, hamba ngakumbi. Ngaphandle koko, kuya kufuneka utshintshe igama lomamkeli ngokusebenzisa imiyalelo kumaxwebhu asemthethweni.
- Ngaphambi kokufaka nasiphi na isicelo, kuyacetyiswa ukukhangela ukufumaneka kohlaziyo ukuze zonke iinkqubo ezilandelayo ziya ngokuchanekileyo. Ukwenza oku, faka i-sudo yum kwaye ucofe ukungena.
- Olu khetho lwenziwa egameni lolona gunya, okuthetha ukuba kufuneka ufake igama eligqithisiweyo ukuqinisekisa ukungqinisisa kweakhawunti. Cinga ukuba xa ubhala abalinganiswa, abayi kubonakala kwikhonkco.
- Uya kwaziswa ngemfuneko yokufaka iiphakheji ezihlaziyiweyo, okanye isilumkiso sokuba uhlaziyo alufumaneki kwiscreen.
Emva kokufaka uhlaziyo, kuyacetyiswa ukuba uqalise kwakhona le nkqubo ukutshintsha utshintsho. Ukuba uhlaziyo alufunyanwanga, uye kwinqanaba elilandelayo.
Inyathelo 2: Ukukhuphela kunye nokufaka iiphakheji
Ngelishwa, awuyi kuba nakho ukukhuphela i-MySQL ukusuka kwindawo esemthethweni yokugcina izinto kwaye kwangaxeshanye kuyifake ngomyalelo omnye. Oku kungenxa yenani elikhulu leenguqulelo kunye nethumbu ezithile kunye nokongezwa koovimba, emva koko kuqala ukhetho lwephakheji efanelekileyo kufuneka kuqala.
Yiya kwi-orehous esemthethweni ye-mysql
- Yiya kule khonkco lingentla ukuze uziqhelanise nazo zonke iinguqulelo zolawulo lwedatha ekuqwalaselweyo. Khetha iphakheji yomdla kwifomathi ye-RPM kwaye ukhuphele ikhonkco kuyo ngokubiza imenyu yemeko ngokucinezela iqhosha leqhosha lasekunene.
- Xa ufaka, uya kubona ukuba ikhonkco likhutshelwe ngokuchanekileyo, kwaye ukuba uya kwikhapheleko, uyakukhuphela iphakheji ye-RPM, kodwa ngoku ayimfuneko kuthi, ukuze sihambele kwi-console.
- Kanye kwisiphelo sendlela, faka i-WGET + ikhutshelwe ikhonkco elidlulileyo kwaye ucofe ku-Enter.
- Emva koko, sebenzisa i-SUDO RPM-VIV MySQL57-I-EL7.RPM, i-ELSPM, ithathe indawo yokulinganisa kulo mgca kumanani akhoyo.
- Lo msebenzi ukwenziwa egameni le-Superuser, kwaye ke kufuneka ufake i-password.
- Linda de uhlaziye u-Repository ugqityiwe kwaye ufake iphakheji.
- Ngaphambi kokuqala kwenkqubo ephambili yokufaka, hlaziya uluhlu lokugcina izinto ngokuchaza uhlaziyo lweSudo yum.
- Qinisekisa isenzo esenziweyo ngokukhetha i-y.
- Yenza kwakhona xa uphinda.
- Yinkqubo yokufaka inkqubo ngokwayo. Oku kwenziwa kusetyenziswa i-sudo yum ukufaka umyalelo weseva we-MySQL.
- Qinisekisa ngokupheleleyo zonke izicelo zokufakelwa okanye ipakethi yokungasebenzi.
- Inkqubo yokukhuphela inokuthatha imizuzu embalwa, exhomekeke kwisantya se-Intanethi. Ngeli xesha, musa ukuvala iseshoni yesiphelo sendlela ukuze ungaseta kwakhona yonke useto.
- Emva kokufakelwa ngempumelelo, yenza i-server ngenkqubo ye-sudo qalisa i-mysqld.
- Ukuba akukho zimpazamo ziguqukayo, ilayini entsha yegalelo ziya kuvela kwiscreen.
Njengoko ubona, ukufaka i-MySQL e-Myntos 7 Kuthathe nje imizuzu embalwa, kwaye umsebenzisi akathathanga imiyalelo emininzi, uninzi lwayo lunokukhutshelwa kwaye lufakelwe kwiConsole. Nangona kunjalo, ukusebenzisana ngokuchanekileyo kunye nee-DBMs, kuya kuba yimfuneko ukuvelisa isimo sokuqala, esiya kuthi sixutyushwe ngezantsi.
Inyathelo 3: Ukuseta okokuqala
Ngoku asizukuchaphazela yonke imiba yokuseka inkqubo yolawulo lwedatha, kuba oku kungasebenzi kumxholo wenqaku. Sifuna nje ukuxela ngezenzo ezisisiseko ekufuneka zenziwe ukukhangela intsebenzo yentsebenzo kunye nokwabela imigaqo esemgangathweni yawo. Ukwenza oku, kuya kufuneka ulandele isikhokelo:
- Masiqale ngokufakwa komhleli ophethe ngesandla, kuba zonke iisetingi zitshintshwa kwifayile yoqwalaselo, evula isoftware enjalo. Kuyilungele ukusebenzisa i-nano, ke kwikhonkco, iSudo yum Faka i-nano.
- Ukuba into esebenzayo ayikasungulwa, kuya kufuneka uqinisekise ukongezwa koovimba abatsha. Ngaphandle koko, umtya onguwenze akukho nto "iya kuvela nje, ke, ungafikelela kwinqanaba elilandelayo.
- Faka i-sudo nano /etc/my.cnf kwaye usebenze lo myalelo.
- Yongeza i-Bind_adddress = umtya = kwaye uchaze idilesi ye-IP ofuna ukuyidibanisa kwaye uvule onke amazibuko. Unokwazisa ezinye iiparamitha ezibalulekileyo. Funda ngakumbi malunga nawo kumaxwebhu asemthethweni, ireferensi apho iboniswa ngezantsi.
- Emva kotshintsho, ungakulibali ukubabhalisa phantsi ngokunqakraza kwi-CTRL + O, kwaye uphume eNano nge-e-Ctrl + X.
- Ekuqaleni, ifayile yoqwalaselo ikwanayo iiparamitha ezichaphazela ukhuseleko lwenethiwekhi. Banokuba yindawo ebuthathaka ngexesha lokuqhekeka, ngenxa yoko kucetyiswa ukubashenxisa ngokwenza i-mysql_sure_sered_sered_sered_sured_sured_sured_sured_sered_sured_sured_sured_sered_sered_sered_sured_sere.
- Ukuqinisekisa lo msebenzi, faka iphasiwedi yomlawuli.
Njengoko bekutshiwo ngaphambili, sabonisa kuphela umgaqo osisiseko woqwalaselo. Okunye ezichazwe ngenkcukacha malunga noku kubhaliwe kumaxwebhu asemthethweni e-MySQL elandelayo.
Tsiba ekufundeni amaxwebhu e-MySQL kwiwebhusayithi esemthethweni
Inyathelo 4: Ingcambu yengcambu yokuseta kwakhona
Ngamanye amaxesha abasebenzisi xa kufakwa i-MySQL iseti yegama eligqithisiweyo le-Superuser, kwaye emva koko ulibale okanye ungazi ukuba yeyiphi na into ekhethwe ekuqaleni, ethathe isigqibo sokugqibela ngolu hlobo:
- Vula "i-terminal" kwaye ufake i-sudo scroctl yeka i-mysqd apho ukumisa ukwenziwa kwenkonzo.
- Yiya kwimodi ekhuselekileyo yokusebenza ngokusingqongileyo sendawo yenkqubo ye-mysqld_opts = "-itapile-isuselwa-skipu."
- Qhagamshela kwigama le-superuser ngokungena kwi-MySQL -U ingcambu. Iphasiwedi ayiyi kucelwa.
- Ihlala ikuphela kuphela ukwenza le miyalelo ilandelayo ukwenza isitshixo esitsha sokufikelela.
I-MySQL> Sebenzisa i-MySQL;
I-MySQL> Ukuhlaziywa komsebenzisi we-password (apho iphasiwedi sisitshixo sakho esitsha)
I-MySQL> Amalungelo eFlash;
I-Sudo Symplectuct-Sty0 ye-UNSET-I-MYSQDD_OPTS
I-Sudo Symplectl iqala i-mysqld
Emva koko, zama ukudibanisa kwiserver kwakhona usebenzisa iphasiwedi entsha. Ngeli xesha apho akufuneki bubunzima.
Usawuqhele ukuqhelana nencwadana yemibhalo-nye yokufakelwa kunye nokucwangciswa komphezulu we-MySQL eCennto 7. Njengoko ubona, akukho nto inzima koku, kodwa akufuneki ukuba ungaqwalaseli Ugcino lwedatha ukuze inxibelelane neseva yewebhu okanye isicelo. Konke oku kuya kufuneka kwenziwe ngesandla, ukutyhala kude kwi-SEETE, le nkqubo kunye nokufunda amaxwebhu asemthethweni onke asetyenzisiweyo.
Bona kwakho:
Ukufaka i-phpmymin e-gentos 7
Ufakelo lwe-PHP 7 eCenntos 7