Faka i-LAMP-i-Apache, i-PHP, i-MariaDB kunye ne-PhpMyAdmin kwi-OpenSUSE
Isitaki seLAMP siquka inkqubo yokusebenza yeLinux, isoftware ye-Apache web server, inkqubo yolawulo lwesiseko sedatha yeMySQL kunye nolwimi lweprogram ye-PHP. I-LAMP yindibaniselwano yesoftware esetyenziselwa ukusebenzela usetyenziso lwewebhu lwe-PHP kunye neewebhusayithi. Qaphela ukuba i-P inokuphinda imele iPerl okanye iPython endaweni ye-PHP.
Kwi-LAMP stack, i-Linux sisiseko se-stack (igcina onke amanye amacandelo); I-Apache ihambisa umxholo wewebhu (njengamaphepha ewebhu, njl.njl.) kumsebenzisi wokugqibela kwi-intanethi ngesicelo ngokusebenzisa umkhangeli zincwadi wewebhu, i-PHP l
Funda ngokugqithisileyo →Faka i-LEMP-Nginx, PHP, MariaDB kunye ne-PhpMyAdmin kwi-OpenSUSE
I-LEMP okanye i-Linux, i-Engine-x, i-MySQL kunye ne-PHP stack yi-software bundle eyenziwe yi-software yomthombo ovulekileyo efakwe kwi-Linux yenkqubo yokusebenza ye-PHP esekelwe kwizicelo zewebhu ezinikwe amandla yi-server ye-Nginx HTTP kunye ne-MySQL/MariaDB inkqubo yolawulo lwedatha.
Esi sifundo siya kukukhokela malunga nendlela yokufaka isitaki se-LEMP nge-Nginx, i-MariaDB, i-PHP, i-PHP-FPM kunye ne-PhpMyAdmin kwi-OpenSuse iseva/i-desktop editions.
Ifakela i-Nginx HTTP Server
I-Nginx yi-HTTP ekhawulezayo nethembekileyo kunye neseva yommeleli enokusingatha umthwalo oph
Funda ngokugqithisileyo →Ungasifaka njani isitaki seLAMP ngePhpMyAdmin kwi-Ubuntu 18.04
I-LAMP stack yenziwe ngeepakethe ezifana ne-Apache, i-MySQL/i-MariaDB kunye ne-PHP efakwe kwindawo ye-Linux yokusingatha iiwebhusayithi kunye nee-apps.
I-PhpMyAdmin yindawo ekhululekileyo, evulekileyo, eyaziwayo, ebonakaliswe ngokupheleleyo, kunye ne-intuitive web-based frontend yokulawula i-MySQL kunye ne-MariaDB database. Ixhasa imisebenzi eyahlukeneyo yedatha, kwaye ineempawu ezininzi ezikuvumela ukuba ulawule ngokulula ugcino lwakho lwedatha ukusuka kujongano lwewebhu; ezifana nokungenisa kunye nokuthunyelwa kwedatha kwiifomathi ezahlukeneyo, ukuvelisa imibuzo enzima kunye nelunce
Funda ngokugqithisileyo →Iingcebiso ezi-4 eziluncedo zokuKhusela i-PhpMyAdmin yokuNgena kwi-interface
Ngokuqhelekileyo, abasebenzisi abaphambili bakhetha ukusebenzisa kunye nokulawula inkqubo yolawulo lwedatha ye-MySQL kwi-prompt yayo yomyalelo, kwelinye icala, le ndlela ibonakalise ukuba ngumngeni omkhulu kubasebenzisi abatsha be-Linux.
Ke ngoko, ukwenza izinto zibe lula kwabaqalayo, iPhpMyAdmin yenziwe.
I-PhpMyAdmin ngumthombo wasimahla kunye novulekileyo, isoftware esekwe kwiwebhu yeMySQL/MariaDB ebhalwe kwi-PHP. Inika abasebenzisi indlela elula yokusebenzisana ne-MySQL nge-browser yewebhu.
Kweli nqaku siza kwabelana ngeengcebiso zokukhusela ufakelo lwakho lwephpmyadmin
Funda ngokugqithisileyo →Uluvala njani uFikelelo lokuNgena kweengcambu kwi-PhpMyAdmin
Ukuba uceba ukusebenzisa i-phpmyadmin rhoqo ukulawula i-database yakho kwi-intanethi (okanye ngakumbi, kwi-Intanethi!), awufuni ukusebenzisa i-akhawunti yengcambu. Oku akusebenzi kwi-phpmyadmin kuphela kodwa nakulo naluphi na olunye ujongano olusekwe kwiwebhu.
Kwi /etc/phpmyadmin/config.inc.php, khangela umgca olandelayo kwaye uqinisekise
Ungongeza njani umaleko owongezelelweyo woKhuseleko kwi-PhpMyAdmin Login Interface
I-MySQL yeyona ndlela isetyenziswayo yehlabathi yolawulo lwesiseko sedatha evulekileyo kwi-ecosystem ye-Linux kwaye kwangaxeshanye abaqalayo be-Linux bakufumanisa kunzima ukulawula ukusuka kwi-MySQL prompt.
I-PhpMyAdmin yadalwa, yiwebhu esekwe kwi-MySQL yolawulo lwedatha yedatha yesicelo, ebonelela ngendlela elula ye-Linux abaqalayo ukusebenzisana ne-MySQL ngojongano lwewebhu. Kweli nqaku, siza kwabelana ngendlela yokukhusela ujongano lwephpMyAdmin kunye negama lokugqitha kwiinkqubo zeLinux.
Ngaphambi kokuba uqhubele phambili neli nqaku, sicinga ukuba ugqibile i-LAMP (Linux, Apa
Funda ngokugqithisileyo →Uyiseta njani i-HTTPS (iZatifikethi ze-SSL) ukuze ukhusele i-PhpMyAdmin Login
Ukwazisa le ngcebiso, makhe sinukise i-HTTP yetrafikhi phakathi komatshini womthengi kunye nomncedisi we-Debian 8 apho senze khona impazamo engenatyala yokungena sisebenzisa i-database yogcino lweenkcukacha zomsebenzisi kwinqaku lethu lokugqibela: Guqula kwaye ukhusele i-URL yokuNgena kwe-PhpMyAdmin.
Njengoko besitshilo kwingcebiso edlulileyo, ungazami ukwenza oku ukuba awufuni kubhengeza iziqinisekiso zakho. Ukuqala ukusezela itrafikhi, sichwetheze lo myalelo ulandelayo kwaye sicinezele u-Enter:
# tcpdump port http -l -A | egrep -i 'pass=|pwd=|log=|login=|user=|username=|pw=| Funda ngokugqithisileyo →Uyitshintsha njani kwaye ukhusele i-URL ye-PhpMyAdmin yokuNgena eMiselweyo
Ngokungagqibekanga, iphepha lokungena lephpmyadmin libekwe apha http://
Oku kwaziwa njengokhuseleko ngokufihlakala kwaye ngelixa abanye abantu bexoxa ukuba ayingomlinganiselo okhuselekileyo, iyaziwa kubo bobabini abahlaseli kunye nokuthintela ukuqhekeza.
Qaphela: Qinisekisa ukuba une-LAMP esebenzayo okanye i-LEMP yokusetha kunye ne-PhpMyAdmin efakwe kwisistim sakho, ukuba
Funda ngokugqithisileyo →Uyifaka njani iPhpMyAdmin yamva nje kwiRHEL, CentOS & Fedora
Ulawulo lwe-MySQL ngomgca womyalelo kwi-Linux ngumsebenzi onzima kakhulu kuye nawuphi na umlawuli we-newbie okanye umlawuli wedatha, kuba iqulethe imiyalelo emininzi esingenakuyikhumbula kubomi bethu bemihla ngemihla.
Ukwenza ulawulo lwe-MySQL lube lula kakhulu sazisa isixhobo solawulo se-MySQL esisekwe kwiwebhu esibizwa ngokuba yiPhpMyAdmin, ngoncedo lwesi sixhobo unokulawula nokulawula ulawulo lwedathabheyisi yakho ngokusebenzisa isikhangeli sewebhu ngokulula.
I-PhpMyAdmin lujongano olusekwe kwiwebhu ekulawuleni i-MySQL/MariaDB yogcino-lwazi olusetyenziswa njengendawo yoncedo
Funda ngokugqithisileyo →Ukuseta i-LEMP Linux, i-Nginx, i-MySQL/MariaDB, i-PHP) kunye ne-PhpMyAdmin kwi-Ubuntu 15.04 Server
Isitaki se-LEMP yindibaniselwano ye-Nginx, i-MySQL/MariaDB kunye ne-PHP efakwe kwindawo ye-Linux.
Isishunqulelo sivela koonobumba bokuqala benye: Linux, Nginx (ebizwa ngokuba yi-Engine x), i-MySQL/MariaDB kunye ne-PHP.
Eli nqaku liza kubandakanya imiyalelo yesinyathelo ngesinyathelo indlela yokufaka isofthiwe nganye kwiqela kwi-Ubuntu 15.04 iseva esekelwe kunye nesixhobo se-PhpMyAdmin sokulawula i-database kwi-browser yewebhu.
Ngaphambi kokuseta i-LEMP, kukho iimfuno ezimbalwa ekufuneka zifezekiswe:
- Ufakelo oluncinci lwe-Ubuntu 15.04.
- Ukufikelela kw Funda ngokugqithisileyo →