Ukufaka i-phpmyadmin e-Ubuntu

Cishe wonke umthuthukisi weWeb ngohlelo lwe-Ubuntu lokusabalalisa lusebenzisana nethuluzi le-phpMyAdmin ukusebenzisa imininingwane ye-MySQL Servers ngokusebenzisa isikhombimsebenzisi sewebhu. Ngokwengeziwe, le ngxenye iyingxenye yesibani, ekufakweni esivele sikhulume kwiwebhusayithi yethu ngaphakathi kohlaka lwenye impahla. Isihloko sanamuhla sizohlonzwa kubasebenzisi abangenalwazi abaqala ukujwayelana kwabo nentuthuko yeWebhu futhi bafuna ukufaka i-phpmyadmin kwikhompyutha yabo. Okulandelayo, sizokwethula imiyalo yesinyathelo ngesinyathelo esizokwenza sikwazi ukubhekana nazo zonke izici zokugcwaliseka komsebenzi.

Faka i-phpmyadmin e Ubuntu

Masikuxwayise ngokushesha ukuthi zonke izenzo ezilandelayo zizokwenziwa nge- "terminal", ngakho-ke zilungiselele iqiniso lokuthi kuzodingeka ukuthi ufake amaqembu amaningi ahlukahlukene. Siphinde sikhombise ukuthi ukucushwa kwe-phpMyAdmin kwenziwa kanjani lapho kuqedwa ukufakwa. Thatha njengesibonelo, iseva ye-Apache Web ethandwa kakhulu ye-Apache kanye ne-MySQL DBMS. Uma manje udinga ngayinye yalezi zinto, kungcono ukusebenzisa isixhumanisi esingezansi, lapho kuchazwa khona isibani sesibani, futhi sihamba ngqo ekuxhumaneni nengxenye oyidingayo namuhla.

Cishe ngaso sonke isikhathi ukufakwa okulula kudlula ngaphandle kwezinkinga. Kodwa-ke, uma unezinkinga zohlelo ezihambisana nomphathi wephakheji, imininingwane ivela esikrinini sokufakwa kwehlulekile. Lesi simo kufanele sixazululwe ngokushesha ngokusebenzisa ukusesha kokulungiswa kwenkinga ethile ngokusebenzisa imibhalo esemthethweni yobuntu noma izinkundla zomsebenzisi.

Isinyathelo 2: Faka i-phpMyadmin

Lesi sigaba siyisisekelo esikhulu kunazo zonke, kusukela manje sizothuthukisa ukufakwa okuqondile kwengxenye ye-phpMyAdmin. Kunezindlela ezahlukahlukene ezikuvumela lokhu ukwenza lokhu, futhi indlela elula izosetshenziswa yindawo esemthethweni esinikela ngayo ukuze sisebenzise imiyalo elandelayo.

1. Ukufaka, uzodinga ukufaka i-Sudo Apt Faka umyalo we-phpmyadmin bese uyisebenze.



2. Kuzokwaziswa ngesidingo sokulanda izingobo zomlando. Emlayezweni "Ufuna ukuqhubeka?" Khetha u-D. Ongakukhetha



3. Lindela iwindi lekhonsoli "ukusetha iphakheji". Lapha, okokuqala, iseva yeWebhu icacisiwe ukucushwa okuzenzakalelayo. Khetha eyakho, bese uqhafaza ku-Tab ukuhambisa ngokushesha kwinkinobho ye- "OK".



4. Linda imizuzu embalwa ukuze amaphakheji aphucwe ngokuphelele. Ngalesi sikhathi sokusebenza, ungavali ikhonsoli futhi ungalandeli ezinye izinto kwi-PC.



5. I- "Pack Setup" iyavela futhi. Manje database kuhlelwa lapha. Bheka imininingwane eyethulwe efasiteleni bese ukhetha okukhethwa kukho.



6. Dala iphasiwedi entsha ye-database.



7. Qinisekisa, ungeniswe kabusha kwifomu elivelayo.



8. Cacisa indlela elula yokuxhuma database.



9. Inombolo yePort yesevisi izosethwa ngokuzenzakalelayo. Uma unesidingo sokuyishintsha, vele usule izinombolo bese ucacisa itheku elidingekayo.



10. Setha igama ledatha ejwayelekile.



11. Bheka imininingwane ekwakhiweni kwegama lomsebenzisi.



12. Manje kufanele uzibuze ngokwakho, uphume emiyalweni efundwayo nezidingo zakho.



13. Faka enye iphasiwedi ezosebenza ukufinyelela i-MySQL ku-phpmyadmin.

Ngemuva kwesikrini sibonisa imininingwane mayelana nokufakwa ngempumelelo kwe-phpmyadmin ohlelweni. Uma kwenzeka noma yiziphi izinkinga ngesikhathi sokucushwa noma ukudedelwa, uzokwaziswa nakubo. Izinketho zizokwengeza ngokunikela ngezinketho zombili zesenzo, ngokwesibonelo, zinganaki inkinga, zizame kabusha ukuzixazulula noma zeqa.

Isinyathelo 3: Ukwakha umsebenzisi omusha

Ngesikhathi esiteji esedlule, ithuluzi lokufaka elinikelwe ukudala umsebenzisi omusha we-phpmyadmin, kepha abanye abasebenzisi baphuthelwe kulo mzuzu noma badinga ukwengeza amanye ama-akhawunti amaningi. Ake siqale isigaba sethu sezilungiselelo eziphambili ngemiyalo yokwakha iphrofayli.

1. Vula iseshini entsha ku-terminal bese uthayipha i-sudo mySQL ukuqala i-database.



2. Qiniseka ukuthi ufaka iphasiwedi ye-superuser.



3. Njengomyalo wokuqala, faka umlawuli we-Dream Whiser 'Offered' @ 'Localhost' ekhonjwe yi-'Phation 'ye-Admin';



4. Setha amalungelo ayisisekelo ngokusebenzisa isibonelelo wonke amalungelo ku- *.



5. Umugqa wokugcina, faka futhi usebenzise amalungelo axakayo;.



6. Uzokwaziswa ngokuphothula ngempumelelo ukusebenza.

Cishe ngendlela efanayo, ungakha inani elingenamkhawulo labasebenzisi abazoxhuma ku-phpmyadmin ngokufaka igama le-akhawunti nephasiwedi kusuka kulo. Naka kuphela ukufakwa kwamalungelo wephrofayili ngayinye. Imininingwane engaphezulu ibhaliwe emibhalweni esemthethweni.

Isinyathelo 4: Security

Ukwakha imithetho yokuphepha eyisisekelo ye-phpMyAdmin akuyona isenzo sonke esidingekayo, kepha uma iseva ihlobene ngqo nenethiwekhi evulekile, kufanele ubuze okungenani izinqubomgomo eziyisisekelo ezizosiza ekuhlaselweni komhlaba. Masiqonde ngokushesha ukuthi kanjani ukulungiselela ukuvikelwa kweseva.

1. Zonke ezinye izenzo zizokwenziwa ngokushintsha amafayela wokucushwa. Ukuze wenze lokhu, udinga ukusebenzisa umhleli wombhalo. Izisombululo ezijwayelekile zingaqondakali kubasebenzisi be-novice, ngakho-ke ake siqale ngokungezwa kwesisombululo esikahle. Thayipha i-sudo apt ukufaka i-nano bese uqhafaza ku-Enter.



2. Ngemuva kokufakwa ngempumelelo, qala ifayela lokuqala lokucushwa nge-sudo nano /usr/share/phpmyadmin/chtaccess.



3. Lapha kunoma iyiphi umugqa ongenalutho ufaka imithetho emine elandelayo.

   I-Authortype ayisisekelo.

   Igama elithi "Amafayela Avinjelwe"

   I-AuthoruuserFile / Etc / phpmyadmin / htpasswd.

   Dinga umsebenzisi ovumelekile



4. Sebenzisa inhlanganisela ye-CTRL + O ukuze ugcine izilungiselelo.



5. Lapho utshelwa, ungaliguquli igama lento, kepha umane uchofoze ku-Enter.



6. Lapho zonke izilungiselelo zigcinwa, cindezela u-CTRL + X ukuvala ifayela lamanje.



7. Okulandelayo, setha iphasiwedi entsha ye-akhawunti eyinhloko, uma lokhu kungeke kwenziwa ngaphambili. Yenza kusebenze i-Sudo HPPassWD -C /TC/phpmMyMin/.hTpasswd Umsebenzisi Womsebenzisi.



8. Engxenyeni ebonakalayo, faka ukhiye wokufinyelela owemukeleka kuwe nangemva kokwenza kusebenze, uyiphindaphinde.



9. Ihlala ilungiselela kuphela iseva yewebhu ngaphansi kwazo zonke izinguquko ezenziwe ngaphambili. Ukuze wenze lokhu, vula ifayela elifanele nge-sudo nano /etc/apache/apoche2.conf.



10. Faka imigqa engezansi bese ugcine izinguquko.

    I-Stovide konke.

    Dinga konke okunikezwe

Zonke ezinye izilungiselelo zezokuphepha zenziwa ngesisekelo sezidingo zakho, kucatshangelwa i-syntax nemithetho ejwayelekile echazwe emibhalweni ye-phpMyAdmin.

Njengengxenye yezinto ezibonakalayo zanamuhla, sasingasho nje kuphela ngomgomo wokufaka i-phpmyadmin, kepha mayelana namaphoyinti wokucushwa main. Manje uyazi ukuthi yiziphi izenzo okufanele zenziwe ukuze zisebenzise ngempumelelo umgomo.