Ukufaka i-MySQL eCennto 7

Anonim

Ukufaka i-MySQL eCennto 7

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.

  1. 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.
  2. Inguqu kwi-terminal yezenzo zokulungiselela xa kufakwa i-mysql kwi-sentos 7

  3. Apha ngena umyalelo wegama lenginginya kwaye ucofe u-Enter.
  4. Ngenisa umyalelo wokuchaza igama lomamkeli kwi-mysql kwi-sentos 7

  5. 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.
  6. Umyalelo wokubonisa igama lomamkeli elifinyeziweyo le-MySQL kwi-Sentos 7

  7. Ngaphambi kokufaka nasiphi na isicelo, kuyacetyiswa ukukhangela ukufumaneka kohlaziyo ukuze zonke iinkqubo ezilandelayo ziya ngokuchanekileyo. Ukwenza oku, faka i-sudo yum kwaye ucofe ukungena.
  8. Umyalelo wokufumana uhlaziyo ngaphambi kokufaka i-MySQL kwi-Sentos 7

  9. Olu khetho lwenziwa egameni lolona gunya, okuthetha ukuba kufuneka ufake igama eligqithisiweyo ukuqinisekisa ukungqinisisa kweakhawunti. Cinga ukuba xa ubhala abalinganiswa, abayi kubonakala kwikhonkco.
  10. I-password Ukungena ukufumana uhlaziyo ngaphambi kokufaka i-MySQL kwi-Sentos 7

  11. Uya kwaziswa ngemfuneko yokufaka iiphakheji ezihlaziyiweyo, okanye isilumkiso sokuba uhlaziyo alufumaneki kwiscreen.
  12. Ukufumana uhlaziyo ngempumelelo ngaphambi kokufaka i-MySQL kwi-Sentos 7

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

  1. 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.
  2. Ukukhuphela iphakheji ye-RPM ekhethiweyo ye-RPM ngenguqulelo ye-MySQL kwi-Sentos 7

  3. Xa ufaka, uya kubona ukuba ikhonkco likhutshelwe ngokuchanekileyo, kwaye ukuba uya kwikhapheleko, uyakukhuphela iphakheji ye-RPM, kodwa ngoku ayimfuneko kuthi, ukuze sihambele kwi-console.
  4. Jonga ikhonkco elikhutshelweyo lokukhuphela iphakheji ye-MySQL kwi-Sentos 7

  5. Kanye kwisiphelo sendlela, faka i-WGET + ikhutshelwe ikhonkco elidlulileyo kwaye ucofe ku-Enter.
  6. Ukukhuphela iphakheji ye-MySQL kwi-Sentos 7 nge-terminal

  7. Emva koko, sebenzisa i-SUDO RPM-VIV MySQL57-I-EL7.RPM, i-ELSPM, ithathe indawo yokulinganisa kulo mgca kumanani akhoyo.
  8. Umyalelo owongezelelweyo wokukhuphela iphakheji yokufaka i-MySQL kwi-sentos 7

  9. Lo msebenzi ukwenziwa egameni le-Superuser, kwaye ke kufuneka ufake i-password.
  10. Ukuqinisekiswa kwephakeji yokukhuphela ye-MySQL kwi-Sentos 7

  11. Linda de uhlaziye u-Repository ugqityiwe kwaye ufake iphakheji.
  12. Ilinde ukugqitywa kwephakheji yokufaka i-MySQL kwi-Sentos 7

  13. Ngaphambi kokuqala kwenkqubo ephambili yokufaka, hlaziya uluhlu lokugcina izinto ngokuchaza uhlaziyo lweSudo yum.
  14. Umyalelo wohlaziyo lwakutshanje xa ufaka i-MySQL kwi-Sentos 7

  15. Qinisekisa isenzo esenziweyo ngokukhetha i-y.
  16. Isiqinisekiso sokuhlaziywa kweendawo zokugcina xa kufakwa i-mysql kwi-sentos 7

  17. Yenza kwakhona xa uphinda.
  18. Umyalelo wesibini wokuqinisekisa ukufakwa kohlaziyo xa kufakwa i-MySQL kwi-sentos 7

  19. Yinkqubo yokufaka inkqubo ngokwayo. Oku kwenziwa kusetyenziswa i-sudo yum ukufaka umyalelo weseva we-MySQL.
  20. Umyalelo wokufakela i-MySQL kwi-sentos 7 nge-terminal

  21. Qinisekisa ngokupheleleyo zonke izicelo zokufakelwa okanye ipakethi yokungasebenzi.
  22. Inkqubo yokukhuphela inokuthatha imizuzu embalwa, exhomekeke kwisantya se-Intanethi. Ngeli xesha, musa ukuvala iseshoni yesiphelo sendlela ukuze ungaseta kwakhona yonke useto.
  23. Ilinde ukufakwa kwe-MySQL DBMS kwi-Sentos 7 nge-terminal

  24. Emva kokufakelwa ngempumelelo, yenza i-server ngenkqubo ye-sudo qalisa i-mysqld.
  25. Inkonzo yokubaleka Ukulawula i-MySQL DBMS kwi-Sentos 7 nge-terminal

  26. Ukuba akukho zimpazamo ziguqukayo, ilayini entsha yegalelo ziya kuvela kwiscreen.
  27. Inkonzo yokuqalisa inkonzo ye-MySQL DBMS kwi-Sentos 7 nge-terminal

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:

  1. 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.
  2. Ukufaka umhleli wokubhaliweyo ukuze uhlele useto lwe-nsql kwi-sentos 7

  3. Ukuba into esebenzayo ayikasungulwa, kuya kufuneka uqinisekise ukongezwa koovimba abatsha. Ngaphandle koko, umtya onguwenze akukho nto "iya kuvela nje, ke, ungafikelela kwinqanaba elilandelayo.
  4. Ukufakelwa ngempumelelo komhleli wokuhlela ukuhlela useto lwe-MySQL kwi-Sentos 7

  5. Faka i-sudo nano /etc/my.cnf kwaye usebenze lo myalelo.
  6. Sebenzisa ifayile yoqwalaselo ukumisela i-MySQL kwi-sentos 7

  7. 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.
  8. Ifayile yoqwalaselo ehleliweyo xa usekwe i-MySQL kwi-Sentos 7

  9. Emva kotshintsho, ungakulibali ukubabhalisa phantsi ngokunqakraza kwi-CTRL + O, kwaye uphume eNano nge-e-Ctrl + X.
  10. Ukugcina utshintsho kumhleli wokubhaliweyo xa uqwalasela i-MySQL kwi-Sentos 7

  11. 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.
  12. Iqela lezokhuseleko le-MySQL kwi-Sentos 7

  13. 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:

  1. Vula "i-terminal" kwaye ufake i-sudo scroctl yeka i-mysqd apho ukumisa ukwenziwa kwenkonzo.
  2. Khubaza inkonzo ye-MySQL kwi-sentos 7 ukuseta iphasiwedi kwakhona

  3. Yiya kwimodi ekhuselekileyo yokusebenza ngokusingqongileyo sendawo yenkqubo ye-mysqld_opts = "-itapile-isuselwa-skipu."
  4. Run vusql kwi-sentos 7 kwimowudi ekhuselekileyo yokuseta kwakhona iphasiwedi

  5. Qhagamshela kwigama le-superuser ngokungena kwi-MySQL -U ingcambu. Iphasiwedi ayiyi kucelwa.
  6. Ukungena kwimiyalelo yokuseta iphasiwedi ye-MySQL kwi-Sentos 7 nge-terminal

  7. 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

Funda ngokugqithisileyo