Ufakelo PhpMyAdmin kwiinkqubo ezahlukeneyo yokusebenza

PhpMyAdmin - project ezamahala ngababhekisi web, eyenzelwe lula intsebenziswano kunye database I SQL. Esi sixhobo ibhalwe kwi PHP kwaye esebenza njengawuphi na umkhangeli zincwadi web. Kuba ukusebenza kakuhle kufuneka kwinkqubo web server ushicilelo, PHP kunye SQL. Kweli nqaku siza kuqwalasela ukufaka PhpMyAdmin kwiinkqubo yokusebenza ezahlukeneyo - Ubuntu, Centos ne Debian.

ufakelo PhpMyAdmin on Ubuntu

Phambi kokuba ufake i inkqubo kule nkqubo, kufuneka ukuba uwusondeza ligquba Lamp. Lekota yokuqala ka-basisishunqulelo ithetha inkqubo Linux usapho iza kusetyenziswa.

Apache - enye abancedisi web kakhulu ethandwa. I SQL yam - nelungu yokusebenza uvimba okanye iprojekthi site. Kaloku, PHP - ulwimi apho iinkonzo web ezibhaliweyo. Kule meko, oku kuthetha ukuba usebenzisa utolika kuzakuguqula PHP-ikhowudi kwi imiyalelo ecacileyo kwibrawuza. Zilandelayo inkcazo emfutshane yeseti lenkqubo yofako. Ngaphandle kwalo, musa ukuba usebenzise PhpMyAdmin.

Lamp ukufaka

Zonke ezi macandelo ingafakwa ngokwahlukileyo, kwaye lula ukubeka. Ukuze siqonde inkqubo uqwalaselo kungcono ukwenza yonke into ngesandla. Apache on Ubuntu ingafakwa imigca emibini:

• sudo apt-ukufumana uhlaziyo - le ntambo kuyimfuneko ukuhlaziya idata sele ifumaneka kwindlela yesicelo;
• sudo apt-ufumane ukufaka apache2 - ufakelo ngqo ngokwalo.

Ekubeni le miyalelo ukuba senziwe egameni ingcambu, wamise sudo phambi kwabo, kwaye iza kufuna igama eligqithisiweyo eliyingcambu. Le nkqubo iza Izakuvavanya isithuba kwaye ulwazi malunga nendlela abaninzi baya kuthabatha software entsha. Emva koko mchazele ukuba siyamkele ngokucinezela uY Ufakelo ngempumelelo umncedisi liyalihlola utshintsho kwi isikhangeli kwi lwenginginya yobulali. Isiphumo kufuneka zivezwe malunga kwiphepha njengoko kubonisiwe ngezantsi.

Iindleko Ezinye ukufaka uze ulungiselele I SQL. Ke ukuba umncedisi, sebenzisa i-terminal. It ngomshini: sudo amagorha-ukufumana ukufaka mysql-server. Kule nkqubo, inkqubo iza kukushukumisela ukuba ngenisa igama lokugqitha le akhawunti ingcambu. Kubalulekile ukuqaphela ukuba le nto ke ingcambu ka-Ubuntu, oko kukuthi, I SQL yam.

Inyathelo lokugqibela kukuba ukufaka Ubuntu PHP. Lo mnqongo kuya kufuneka kufakelwe ngokudibene eziliqela izilungiso yayo, ukuze ulungise futhi eliphezulu ukusebenza kunye ledatha kunye neseva. Kwenziwe iqela enjalo eliquka lwamagama ezininzi: sudo amagorha-ukufumana ukufaka libapache2-mod-PHP PHP PHP-mcrypt PHP-mysql. Emva kofakelo layo licandelo entry isibane abaya kuthathelwa ingqalelo zigqityiwe. Kuhleli ukuwuvala umyalelo umncedisi sudo systemctl ukuqalelisa apache2.

Ukuvavanya ukusebenza kwe-software package ufuna ukwenza ifayile yovavanyo kwi weefayili / var / www / html /. Kuyenzeka ukuba ubhale imigca embalwa PHP, nto leyo eya kuzisa ulwazi kwinkqubo, okanye impazamo xa ukungaphumeleli:

• phpinfo ()
• ?>

Ke kaloku, xa udibaniselana / imya_fayla.php kufuneka avele malunga kwiphepha, njengoko kubonisiwe kulo mzobo ngasentla.

PhpMyAdmin: ukuhamba

Ukufakelwa PhpMyAdmin Ubuntu lwenziwa ngendlela efanayo njengoko zihamba ngako nezinye isicelo - ngokusebenzisa imigca eziliqela. Okokuqala, bhala umyalelo zilandelayo: sudo amagorha-ukufumana ukufaka phpmyadmin. Kule nkqubo umsebenzisi ziya kucelwa apho kumncedisi ukusebenza. Kulo mzekelo, kufuneka ukhethe Apache. Into elandelayo ke umbuzo ukuba usebenzise isixhobo uqwalaselo dbconfig-eqhelekileyo, oko ufanele uthi ewe. Kwaye okona kubalulekileyo - Uzakuthunyelwa ukuba eligqithisiweyo ledatha I SQL. Okulandelayo, ufuna ikhowudi eyimfihlo ye PhpMyAdmin. Kuhleli iqale kumncedisi web kwakhona: sudo systemctl ukuqalelisa apache2. Emva ngokunqakraza kwi idilesi lwenginginya yobulali / phpmyadmin kufuneka ukubonisa iphepha ukungena ngemvume wakho kunye negama lokugqitha: Emva kokungena, uyakwazi ngesandla ukulawula database usebenzisa umsebenzisi-friendly interface.

CentOS and PhpMyAdmin

Ukufakela PhpMyAdmin e CentOS kufuneka isethi Lamp. Inkqubo yonke ifana kakhulu naleyo echazwe for Ubuntu. Umahluko kuphela kukuba isebenza nge umphathi Restaurants kunye kancinci ezahlukileyo ukhangela igama lomncedisi: sudo yum ukufaka httpd.

Oku kuphehlelelwa kwenzeka ngolu hlobo lulandelayo:

• sudo systemctl uqale httpd
• sudo systemctl kwenza httpd

Ukuba yonke into ilungile, iphepha lovavanyo ziya kufumaneka kwi inginginya yobulali kwi browser.

Okulandelayo, kuya kufuneka i-SQL server. Ukuphunyezwa kwawo eyahlukileyo kancinane yezinikezelo ezahlukeneyo Linux, ezifana CentOS umiselwe ukutolikwa MariaDB: sudo yum ukufaka mariadb-server.

Running liyafana umncedisi we web:

• sudo systemctl uqale mariadb
• sudo systemctl kwenza mariadb

Kodwa ukusebenza kufuneka mhaka khankanya negama eligqithisiweyo ingcambu, ngoko sebenzisa umyalelo: mysql_secure_installation sudo. Ixela password entsha.

Ifakela PHP nayo iza iingcingo umnqongo: sudo le yum i ukufaka Filipi Filipi-ye emibhaka Filipi-gd Filipi-le mysql??.

Ukuze ube nokufaka isicelo zonke utshintsho eziveliswa kule nkqubo, aqhube kwakhona umncedisi we web: sudo systemctl ukuqalelisa httpd.

Ke kaloku kwafika ithuba kunye PhpMyAdmin. Ukuze wenze oku, sebenzisa umyalelo zilandelayo: sudo yum ukufaka phpmyadmin

Kanye Ubuntu, kuba emva kokuba uqale elilandelayo iphepha umncedisi we web kunye PhpMyAdmin ziya kuvulwa xa uchwetheza kwi bar idilesi iqela umkhangeli: udibaniselana / phpmyadmin. Ukususela ngalo mzuzu libe nokuthathelwa ingqalelo ekusekeni CentOS PhpMyAdmin zigqityiwe.

PhpMyAdmin ne Debian

Debian ne Ubuntu zifana kakhulu omnye komnye. Ayimangalisi into yokuba yonke le miyalelo xa ufaka PhpMyAdmin e Debian ukuba ukhutshelwe kwiqela Ubuntu wobambiswano. Umahluko kuphela inokuba ukuba umsebenzisi yangoku iingcambu, ngoko ke umyalelo sudo akuyomfuneko.

isiphelo

Eli nqaku ngokutsha imiyalelo olufutshane ukuze ufakelo okulula iphakheji software kunye isibane PhpMyAdmin kuye. Kakade ke, le nkqubo baye bangakwazi ukuya kakuhle, kwaye ziya kwenzeka iimpazamo. Kodwa phantse bonke kunye khowudi zabo, apho unako ukufumana ingcaciso kunye nesisombululo. Kodwa kwiimeko ezininzi, emisa PhpMyAdmin kufuneka kwenzeke ngaphandle imiqobo ebonakalayo.

Ngaphandle web yezinikezelo ezahlukeneyo yokuba neseti lula iseti isibane, leyo zibekwe kumgca omnye. Ngokuqhelekileyo, akukho awenzayo ibandla abenzi ezisemthethweni iimveliso, ngoko ngamanye amaxesha kwiinguqulelo zabo kancinane aphume umhla. Manual yoFakelo inika ithuba lokuba basebenzise oko uguqulelo oludlulileyo. Emveni kwazo zonke iinkqubo umnini uya kufumana icandelo lula nenze inzila ngenxa ekulawuleni zolwazi zabo.