Phantse yonke i-Web phuculo yenkqubo yokuhambisa ubuntu isebenzisana nesixhobo se-PHPMYMNRINS ukufezekisa i-METSQLS yedatha ye-MySQL ngewebhu. Ukongeza, eli candelo yinxalenye yesibane, kufakelo esisele silithethile kwiwebhusayithi yethu yenkqubo yenye into. Inqaku lanamhlanje liza kujoliswa ngabasebenzisi abangenamava abaqala ukuqhelana nabo ngophuhliso lwewebhu kwaye ufuna ukufaka i-phpmymin kwikhompyuter yabo. Okulandelayo, siza kuwunika umyalelo wenyathelo ngenyathelo oya kwenza ukuba ukwazi ukujongana nayo yonke imiba yenzaliseko yomsebenzi.
Faka i-phpmymin e-Ubuntu
Ngokukhawuleza walumkisa ukuba zonke iintshukumo ezilandelayo ziya kwenziwa nge "terminal", ke zilungiselele inyani yokuba kuya kufuneka ufake iqela leentlobo ezahlukeneyo. Sikwabonisa indlela oqwalaselwa ngayo i-PHPMYMMADMSINIPRING EMVA KOKUGQIBELA UKUZALWA. Thatha umzekelo, eyona ndawo ithandwayo yewebhu yewebhu kunye ne-mysql dbms. Ukuba ngoku ufuna ngalinye lala macandelo, kungcono ukusebenzisa ikhonkco elingezantsi, apho kusenziwa khona isibane, kwaye siya ngqo ekunxibelelaneni nelinye namhlanje.Phantse kuhlala kudlule ukufakelwa ngokulula ngaphandle kweengxaki. Nangona kunjalo, ukuba unazo naziphi na iingxaki zenkqubo ezinxulumene noMphathi wePakethi, ulwazi luvela kwiscreen sokuba ukufakelwa akuphumelelanga. Le meko kufuneka iconjululwe ngokukhawuleza ngokusebenzisa ukhangela izilungiso zengxaki ethile kumaxwebhu asemthethweni e-Ubuntu okanye kwiiforamu zabasebenzisi.
Inyathelo 2: Faka i-phpmymin
Eli nqanaba yeyona nto isisiseko, kuba ngoku siza kuphuhlisa ukufakelwa ngokuthe ngqo kwenxalenye ye-phpmymin. Kukho iindlela ezahlukeneyo ezivumela oku ukuba zenze le nto, kwaye eyona ndlela ilula iya kusetyenziswa yindawo esemthethweni yokugcina esinikezela ekuphumezeni kumyalelo olandelayo.
- Ukufaka, kuya kufuneka ufake i-sudo apt faka umthetho we-phpmymmin kwaye isebenze.
- Iya kwaziswa ngemfuneko yokukhuphela ogciniweyo. Ngomyalezo othi "Ufuna ukuqhubeka?" Khetha i-D. ukhetho
- Lindela iwindows console "ibeka iphakheji". Apha, okokuqala, iseva yeWebhu icacisiwe koqwalaselo ozenzekelayo. Khetha eyakho, emva koko nqakraza kwithebhu ukuze uhambe ngokukhawuleza kwiqhosha "Kulungile".
- Linda imizuzu embalwa ukuze iiphakeji azifakwa ngokupheleleyo. Ngeli xesha lokusebenza, musa ukuvala i-console kwaye ungalandeli ezinye iintshukumo kwiPC.
- I "PATEXP STUP" ivela kwakhona. Ngoku i-database ihlelwe apha. Jonga ulwazi oluboniswe efestileni kwaye ukhethe ukhetho olufanelekileyo.
- Yenza iphasiwedi entsha yedatha.
- Yiqinisekise, iphinde ingene kwifom evelayo.
- Chaza indlela elula yokunxibelelana kwi-database.
- Inombolo ye-Port yeNkonzo iza kuseta ngokuzenzekelayo. Ukuba unemfuneko yokutshintsha, cima nje amanani kwaye uchaze izibuko elifunekayo.
- Cwangcisa igama ledatha esemgangathweni.
- Jonga ulwazi malunga nokudalwa kwegama lomsebenzisi.
- Ngoku kufuneka uzibuze ngokwakho, tyhala kwimiyalelo yokufunda kunye neemfuno zakho.
- Ngenisa enye iphasiwedi ezokusebenza ukufikelela kwi-MySQL kwi-phpmmymin.
Emva kwesikrini esibonisa ulwazi malunga nokufakelwa ngempumelelo kwe-Phpymymin kwinkqubo. Ukuba kukho naziphi na kukho iingxaki ezivela ngexesha loqwalaselo okanye ukuvula, uya kwaziswa ngazo. Iinketho ziya kongeza zombini iinketho zesenzo, umzekelo, ukutyeshela ingxaki, ukuzama kwakhona ukusombulula okanye ukutsiba.
Inyathelo 3: Ukwenza umsebenzisi omtsha
Ngexesha elidlulileyo, isixhobo sokufaka esinokufakwa ukudala umsebenzisi omtsha we-phpmymin, kodwa abanye abasebenzisi baphoswa ngalo mzuzu okanye kufuneka bongeze iiakhawunti ezininzi. Masiqale icandelo lethu leseto esiyintloko kunye nemiyalelo yokwenza iprofayili.
- Vula iseshoni entsha kwisiphelo sendlela kunye nohlobo lwe-sudo vesql ukuqala i-database.
- Qiniseka ukuba ufake ipassword engaphezulu.
- Njengomyalelo wokuqala, faka i-Adminiss 'Admin' @ 'I-Ofisi yendawo' ichongwe yi 'password';, apho i-Administ 'iGama igama leakhawunti, kunye negama lokugqitha lifakwe kwi-akhawunti.
- Cwangcisa amalungelo asisiseko ngawawo amalungelo apheleleyo *. * Ukuya 'kwi' Admin '@' kwi-Ofisi ye-Ofisi yoKhetho;
- Umgca wokugqibela, faka kwaye usebenze amalungelo e-flush;.
- Uya kwaziswa malunga nokugqitywa kwempumelelo komsebenzi.
Phantse ngendlela efanayo, unokwenza inani elingenamkhawulo labasebenzisi abaya kuthi baqhagamshele kwi-phpmymin ngokufaka igama leakhawunti kunye negama lokugqitha kulo. Thatha ingqalelo kuphela ufakelo lwamalungelo kwiprofayili nganye. Ulwazi oluthe kratya lubhalwe kumaxwebhu asemthethweni.
Inyathelo 4: Ukhuseleko
Ukwenza imigaqo esisiseko ye-phpmymin ayisoloko ingumncedisi oyimfuneko, kodwa ukuba iseva inxulumene ngqo nenethiwekhi evulekileyo, kuya kufuneka ubuze ubuncinci imigaqo-nkqubo esisiseko eya kuthi incedise ekuhlaselweni komhlaba. Masiqonde ngokukhawuleza ukuba uqwalasele ukhuseleko lweseva.
- Zonke ezinye izinto ezenziwayo ziya kwenziwa ngokutshintsha iifayile zoqwalaselo. Ukwenza oku, kufuneka usebenzise umhleli wokubhaliweyo. Izisombululo ezisemgangathweni zinokungaqondakali kubasebenzisi be-novice, ke masiqale ngokongezwa kwesisombululo esilula ngakumbi. Chwetheza i-sudo apt faka i-nano kwaye ucofe ku-Enter.
- Emva kokufakelwa ngempumelelo, qala ifayile yokuqala yoqwalaselo nge-sudo nano /share/fucymydmin/.htacces.
- Apha kuwo nawuphi na umgca ongenanto faka le mithetho mine ilandelayo.
I-auttype asise.
I-AUCOZUme "Iifayile ezithintelweyo"
I-Authiserfile / njly / phpymymin / htpasswd.
Funa umsebenzisi osebenzayo
- Sebenzisa i-CTRL + o Ukudibanisa ukugcina useto.
- Xa ushukunyiswa, ungalitshintshi igama lento, kodwa nqakraza ngokungenayo.
- Xa zonke iisetingi zigcinwa, cofa i-Ctrl + x ukuvala ifayile yangoku.
- Okulandelayo, setha igama eligqithisiweyo leakhawunti ephambili, ukuba le nto le yenziwe ngaphambili. Yenza i-Sudo Hpasswd -c /etc/phpymyAdmin/.htpasdd yomsebenzisi.
- Kwilitye elivelileyo, faka iqhosha lokufikelela kwakholeka kuwe nasemva kokusebenza, phinda.
- Ihlala kuphela ukuqwalasela iseva yewebhu phantsi kwazo zonke iinguqu ezenziwe ngaphambili. Ukwenza oku, vula ifayile efanelekileyo nge-sudo nano /etc/apache/apache2.conf.
- Faka imigca engezantsi kwaye ugcine utshintsho.
A.Alocierride konke.
Funa bonke
Zonke ezinye iisetingi zokhuseleko zenziwa kwisiseko seemfuno zakho, ezithathela ingqalelo i-syntax kunye nemithetho ngokubanzi echazwe kwi-PHPMYMYINADMON.
Njengenxalenye yezinto zanamhlanje, asixelelanga kuphela malunga nomgaqo wofakelo lwe-phpmymin, kodwa malunga neepokotho zogcino oluphambili. Ngoku uyazi ukuba zeziphi izinto ezifanele zenziwe ukuze kuphumeze ngempumelelo isukelo.