Hafi ya buri rubuga hamwe na sisitemu yo gukwirakwiza ubuntu hamwe nigikoresho cya Phpnyudmin kugirango ushyire mubikorwa seriveri ya MySQL Byongeye kandi, ibi bigize ni igice cyamatara, ku ishyirwaho tumaze kuvuga kurubuga rwacu murwego rwikindi kindi. Ingingo y'uyu munsi izagamenyeshwa abakoresha ubushobozi batangiye gusa kumenyana niterambere ryurubuga kandi ishaka gushiraho Phpmarimmin kuri mudasobwa yabo. Ibikurikira, tuzerekana intambwe yintambwe ya-intambwe izatuma bishoboka guhangana nibice byose byo gusohoza inshingano.
Shyiramo phpmyadmin muri ubuntu
Ako kanya urakuburira ko ibikorwa byose byakurikiyeho bizakorwa binyuze muri "terminal" yose, nimwitegure rero kuba ugomba kwinjira mu makipe atandukanye. Turerekana kandi uburyo imiterere yibanze ya Phpnyudmine ikorwa kurangiza kwishyiriraho. Fata nk'urugero, urubuga rwa Apache azwi cyane na seriveri ya MySQL. Niba ubu ukeneye buri kimwe muribi bigize, nibyiza gukoresha umurongo hepfo, aho igenamiterere ryamatara ryasobanuwe, kandi tujya muburyo bwo gukorana nibigize uyu munsi.Hafi igice kimwe cyo kwishyiriraho kurengana nta kibazo. Ariko, niba ufite ibibazo bya sisitemu bijyanye numuyobozi wa paki, amakuru agaragara kuri ecran kugirango kwishyiriraho byarananiranye. Ibi bintu bigomba gukemurwa byihuse ukoresheje gushakisha ikibazo cyihariye binyuze mubyangombwa byemewe byubuntu cyangwa Ihuriro ryumukoresha.
Intambwe ya 2: Shyira Phpmyadmin
Iki cyiciro nicyo cyibanze, kuva ubu tuzabateza imbere ibikorwa bya Phpmyadmin. Hariho uburyo butandukanye bwemerera ibi kubikora, kandi inzira yoroshye izakoreshwa nububiko bwemewe dutanga kugirango dushyire mubikorwa amabwiriza ataha.
- Kugirango ushyireho, uzakenera kwinjira muri Sudo apt shyiramo phpnyuadming on hanyuma ubikore.
- Hazabaho kubimenyeshwa gukenera gukuramo ububiko. Mu butumwa "dushaka gukomeza?" Hitamo D. Ihitamo
- Tegereza idirishya rya konsole "gushiraho paki". Hano, mbere ya byose, Urubuga rwa interineti rwasobanuwe kugirango iboneza ryikora. Hitamo ibyawe, hanyuma ukande kuri tab kugirango wimuke vuba kuri "OK".
- Tegereza iminota mike kugirango ibipaki bidapadiri. Muri iki gikorwa, ntukifuze umukororomo kandi ntugakurikire ibindi bikorwa kuri PC.
- "Gukora paki" byongeye kugaragara. Noneho ububiko bwahinduwe hano. Reba amakuru yatanzwe mu idirishya hanyuma uhitemo amahitamo akwiye.
- Kora ijambo ryibanga rishya kuri base base.
- Emeza, kongera kwinjira muburyo bugaragara.
- Kugaragaza uburyo bworoshye bwo guhuza base base.
- Umubare wa serivisi wa serivisi uzashyirwaho mu buryo bwikora. Niba ukeneye kuyihindura, gusiba imibare hanyuma ugaragaze ibyambu bisabwa.
- Shiraho izina rya base de basanzwe.
- Reba amakuru yerekeye kurema izina ryukoresha.
- Noneho ugomba kwibaza uti: "Gusunika mumabwiriza asoma hamwe nibyo ukeneye.
- Injira indi ijambo ryibanga rizakora kugirango ugere kuri MySQL kuri Phpmyadmin.
Nyuma ya ecran yerekana amakuru kubyerekeye kwishyiriraho neza Phpmyadmin muri sisitemu. Niba hari ikibazo cyavutse mugihe cyiboneza cyangwa gupakurura, nawe uzamenyeshwa nabo. Amahitamo azatanga ibicuruzwa byombi, kurugero, wirengagije ikibazo, ongera ugerageze kugikemura cyangwa gusimbuka.
Intambwe ya 3: Gushiraho umukoresha mushya
Mugihe cyagenwe, igikoresho cyo kwishyiriraho cyatanzwe kugirango ukore umukoresha mushya kuri Phpmyadmin, ariko abakoresha bamwe babuze uyu mwanya cyangwa bakeneye kongeramo izindi konti nyinshi. Reka dutangire igice cyacu cyimiterere nyamukuru hamwe namabwiriza yo gukora umwirondoro.
- Fungura isomo rishya muri terminal hanyuma wandike sudo mysql kugirango utangire base de base.
- Witondere kwinjiza ijambo ryibanga rya superUser.
- Nkigumategeko yambere, andika gukora umukoresha 'umuyobozi' @ 'localhost' yamenyekanye n 'ijambo ryibanga' ;, aho admin 'nizina rya konti, nijambo ryibanga ni ijambo ryibanga ryashizwemo.
- Shiraho uburenganzira bwibanze binyuze mu gutanga amahirwe yose kuri *. * Kuri 'Admin' @ 'Localhost' hamwe n'impano ;, menya neza guhindura izina ry'umukoresha kuri mbere.
- Umurongo wanyuma, andika kandi ukoreshe impeta ;.
- Uzamenyeshwa kurangiza neza ibikorwa.
Hafi kimwe, urashobora gukora umubare utagira imipaka wabakoresha uzahuza Phpmyadmin winjiza izina rya konte nijambobanga. Kuzirikana gusa kwishyiriraho amahirwe kuri buri mwirondoro. Andi makuru yanditse mu nyandiko zemewe.
Intambwe ya 4: Umutekano
Gukora amategeko yibanze ya Phpmyadmin ntabwo buri gihe ari ibikorwa bikenewe, ariko niba seriveri ifitanye isano na rezo ifunguye, ugomba kubaza byibuze politiki yibanze izafasha mubitero byibanze. Reka dusobanukirwe vuba uburyo bwo gushiraho seriveri kurinda seriveri.
- Ibindi bikorwa byose bizakorwa muguhindura iboneza. Kugirango ukore ibi, ugomba gukoresha umwanditsi wanditse. Ibisubizo bisanzwe birashobora kutumvikana kubakoresha Novice, reka rero dutangire hiyongereyeho igisubizo cyoroshye. Andika sudo apt shyira nano hanyuma ukande kuri enter.
- Nyuma iyinjizaporogaramu neza, gutangira mbere Iboneza Idosiye binyuze Ikwirakwiza Nano /usr/Share/PhpmyAdmin/.htaccess.
- Hano mumirongo iyo ari yo yose irimo shyiramo amategeko ane akurikira.
Authtype Shingiro.
Izina "Idosiye Yabujijwe"
Authsuserfile / Etc / Phpnyudmin / Htpasswd.
Saba ufite agaciro-umukoresha
- Koresha CTRL + o guhuza kugirango ubike igenamiterere.
- Iyo bisabwe, ntuhindure izina ryikintu, ariko ukande gusa kuri Enter.
- Iyo igenamiterere ryose ryabitswe, kanda Ctrl + x kugirango ufunge dosiye iriho.
- Ibikurikira, shiraho ijambo ryibanga rishya kuri konte nkuru, niba ibi bitarakozwe mbere. Kora sudo hpaswd -c /etc/phpmadmin/.htpassWD Umukoresha Amategeko.
- Mu bigaragara, andika urufunguzo rwo kwinjira rwemewe kuri wewe na nyuma yo gukora, subiramo.
- Biracyaza gusa kugena seriveri y'urubuga munsi yimpinduka zose zakozwe mbere. Kugirango ukore ibi, fungura dosiye ikwiye binyuze muri Sudo Nano /etc/Apache/Pache2.conf.
- Shyiramo imirongo hepfo hanyuma uzigame impinduka.
Emerera EregaOverride Byose.
Bisaba ibyatanzwe byose
Igenamiterere byose byumutekano bikorwa hashingiwe kubyo ukeneye, uzirikana syntax namategeko rusange asobanurwa mumateka ya Phpmyadmin.
Mu rwego rw'ibikoresho by'uyu munsi, ntabwo twabwiye ihame ryo kwishyiriraho Phpmyadmin, ariko kubyerekeye ingingo nyamukuru. Noneho uzi ibikorwa bigomba gukorwa kugirango ushyire mubikorwa intego.