Kusan kowane mai haɓakawa na yanar gizo tare da tsarin rarraba UBUNtu yana hulɗa tare da kayan aikin phpMyAdmin don aiwatar da bayanan bayanan MySQL Servace ta hanyar yanar gizo. Bugu da ƙari, wannan ɓangaren ɓangare ne na fitila, a kan shigarwa wanda muka riga muka faɗi akan gidan yanar gizon mu a cikin tsarin wani abu. Za a yi wannan labarin yau a kan masu amfani da kwarewa waɗanda ke fara ganin sanannu tare da haɓaka yanar gizo kuma yana so ya sanya phpMyAdmin zuwa kwamfutarsu. Bayan haka, za mu gabatar da koyarwar mataki-mataki-mataki wanda zai sa ya yiwu a magance dukkan bangarorin cikar aikin.
Sanya phpMyAdmin a Ubuntu
Nan da nan ya gargaɗe ku cewa duk ayyukan da ke gaba za a yi ta hanyar "tashar", don haka kasance cikin shiri don gaskiyar cewa dole ne ku shiga yawancin ƙungiyoyi da yawa. Mun kuma nuna yadda aka tsara phpMyAdmin a kan kammala shigarwa. Auki kamar misali, mafi mashahuri Apache gidan yanar gizo da MySQL DBM. Idan yanzu kuna buƙatar kowane ɗayan waɗannan abubuwan haɗin, ya fi kyau amfani da mahaɗin da ke ƙasa, inda aka bayyana tsarin fitila, kuma muna zuwa kai tsaye zuwa yau.Kusan koyaushe irin wannan sauki ke wucewa ba tare da wata matsala ba. Koyaya, idan kuna da duk wani tsarin tsarin da ke da alaƙa da mai sarrafa kunshin, bayani yana bayyana akan allon cewa shigarwa ya kasa. Wannan halin ya kamata a warware hanzarin hanzari ta amfani da binciken takamaiman matsala ta hanyar bayanan hukuma na UBuntu ko kuma tattaunawar masu amfani.
Mataki na 2: Shigar da phpMyAdmin
Wannan matakin shine mafi yawan asali, tun yanzu zamu bunkasa shigarwar kai tsaye na ɓangaren phpMyAdmin. Akwai hanyoyi daban-daban waɗanda ke ba da damar yin wannan, kuma hanya mafi sauki za ta yi amfani da ita ta hukuma wacce muke bayar da aiwatarwa a cikin koyarwa ta gaba.
- Don kafawa, kuna buƙatar shigar da sudo apt shigar da PhpMyAdmin PhpMyAdmin kuma kunna shi.
- Za a sanar da bukatar saukar da kayan adana. A cikin sakon "so ka ci gaba?" Zabi D. Zabi
- Jira taga mai amfani da na'ura "saita kunshin". A nan, da farko, ana ƙayyade sabar yanar gizo don tsarin atomatik. Zaɓi naka, sannan danna shafin don motsawa da sauri zuwa maɓallin "Ok".
- Jira minutesan mintuna saboda an buɗe kunshin gaba ɗaya. A yayin wannan aikin, kar a rufe na'ura wasan bidiyo kuma kada ku bi wasu ayyuka a PC.
- "Shirya Saitin" ya sake bayyana. Yanzu an shirya bayanan bayanan a nan. Duba bayanan da aka gabatar a cikin taga kuma zaɓi zaɓi da ya dace.
- Airƙiri sabon kalmar sirri don bayanan.
- Tabbatar da shi, sake shiga cikin hanyar da ta bayyana.
- Saka hanya mai dacewa don haɗawa zuwa bayanan.
- Lambar tashar jiragen ruwa za a saita ta atomatik. Idan kuna da buƙatar canza shi, kawai goge lambobin kuma saka tashar jiragen ruwa da ake buƙata.
- Saita sunan daidaitaccen bayanan.
- Duba bayanin kan halittar sunan mai amfani.
- Yanzu dole ne ka tambaye shi da kanka, yana tura daga umarnin karanta da bukatunku.
- Shigar da wata kalmar sirri da za ta ba da damar samun damar zuwa MySQL zuwa phpMyAdmin.
Bayan allon yana nuna bayani game da nasarar shigar da nasara na phpMyAdmin a cikin tsarin. Idan duk wata matsala ta tashi yayin sanyi ko kuma a sanar da kai game da su. Zaɓuɓɓuka za su ƙara yin zaɓuɓɓukan aiwatar da ayyukan, alal misali, watsi da matsalar, sake ƙoƙarin warware shi ko tsallake.
Mataki na 3: Kirkirar sabon mai amfani
A lokacin mataki na baya, kayan aikin shigarwa don ƙirƙirar sabon mai amfani ga phpMyAdmin, amma wasu masu amfani sun rasa wannan lokacin ko buƙatar ƙara ƙarin asusun. Bari mu fara sashen mu na babban saitunan tare da umarni don ƙirƙirar bayanin martaba.
- Bude wani sabon taro a cikin tashar kuma buga sudo mysql don fara bayanan.
- Tabbatar shigar da kalmar sirri.
- A matsayin umarnin farko, shigar da mai amfani da mai amfani 'Admin' @ 'karkatar da kalmar sirri';, a ina ne sunan asusun, kuma kalmar sirri aka sanya.
- Saita gata na asali ta hanyar ba da gata duk gata a kan *.
- Sauran jeri, shigar kuma kunna flush gata ;.
- Za a sanar da kai daga nasarar aiwatar da aikin.
Kusan a wannan hanyar, zaku iya ƙirƙirar yawancin adadin masu amfani waɗanda ba wanda zai haɗa zuwa phpMyAdmin ta hanyar shigar da sunan asusun da kalmar sirri daga gare ta. La'akari da shi kawai shigarwa na gata ga kowane bayanin martaba. An rubuta ƙarin bayani a cikin takaddar hukuma.
Mataki na 4: Tsaro
Irƙirar ka'idodin tsaro na asali don phpMyAdmin ba koyaushe bane matsayin da ake buƙata kai tsaye, to idan uwar garken tana da alaƙa kai tsaye zuwa ga shirye-shiryen buɗe ido, to ya kamata ka nemi akalla kai hari. Bari da sauri ta fahimci da sauri yadda za a saita kariyar uwar garke.
- Duk sauran ayyukan za a yi ta canza fayilolin sanyi. Don yin wannan, kuna buƙatar amfani da editan rubutu. Abubuwan daidaitattun hanyoyin za su iya yin fahimta game da masu amfani da NOVice, don haka bari mu fara da ƙari na mafi kyawun bayani. Rubuta sudo APT shigar Nano Shigar da kuma danna Shigar.
- Bayan nasara da kafuwa, a fara da farko sanyi fayil ta hanyar Sudo Nano /usr/Share/PhpmyAdmin/.htaccess.
- Anan a cikin kowane yanki na wofi saka dokoki huɗu.
M.
Athnname "sun hana fayiloli"
Authuserrile / sauransu / phpMyAdmin / htattwdd.
Na bukatar inganci-mai amfani
- Yi amfani da Ctrl + O Haɗin ajiye saitunan.
- Lokacin da aka sa, kada ku canza sunan abu, amma kawai danna Shigar.
- Lokacin da duk saitunan aka ajiye, latsa Ctrl + X don rufe fayil na yanzu.
- Abu na gaba, saita sabuwar kalmar sirri don babban asusun, idan ba a yi wannan ba a baya. Kunna sudo hpashdd -c /etc/phpmyadmin/.htpasswed umarnin mai amfani.
- A cikin kirtani mai bayyana, shigar da maɓallin keɓewa a gare ku da kuma bayan kunnawa, maimaita shi.
- Ya rage kawai don saita uwar garken gidan yanar gizo a ƙarƙashin dukkanin canje-canje da aka yi a baya. Don yin wannan, buɗe fayil ɗin da ya dace ta hanyar Sudo Nano /etc/Apache/Pache2.conf.
- Saka layin da ke ƙasa yana adana canje-canje.
Ba da izini.
Ana buƙatar duka
Duk sauran saitunan tsaro ana yin su bisa ga bukatunku, la'akari da tsarin syntax da aka bayyana a cikin takardun phpMyadmin.
A matsayin wani ɓangare na kayan yau, ba mu faɗi kawai game da ƙa'idar shigarwa phpyadmin ba, amma game da babban abubuwan saiti. Yanzu kun san abin da ya kamata a yi aiki don samun nasarar aiwatar da maƙasudin.