Yadda ake shigar da Stack LAMP tare da PhpMyAdmin a cikin Ubuntu 18.04


Tarin LAMP yana kunshe da fakiti kamar Apache, MySQL/MariaDB da PHP da aka shigar akan tsarin Linux don ɗaukar gidajen yanar gizo da ƙa'idodi.

PhpMyAdmin kyauta ne, buɗaɗɗen tushe, sanannen, cikakken fasali, da ilhama na tushen yanar gizo don gudanar da MySQL da bayanan MariaDB. Yana goyan bayan ayyukan bayanai daban-daban, kuma yana da fasali da yawa waɗanda ke ba ku damar sarrafa bayananku cikin sauƙi daga mahaɗar yanar gizo; kamar shigo da fitar da bayanai ta nau'i-nau'i daban-daban, samar da hadaddun tambayoyi masu amfani ta amfani da Query-by-misali (QBE), sarrafa sabar da yawa, da ƙari mai yawa.

  1. Ƙarancin Shigar uwar garken Ubuntu 18.04.
  2. Shigar da sabar ta hanyar SSH (idan ba ku da damar kai tsaye).
  3. Tushen gata mai amfani ko amfani da umarnin sudo don gudanar da duk umarni.

A cikin wannan labarin, zamuyi bayanin yadda ake shigar da tarin LAMP tare da PhpMyAdmin a cikin Ubuntu 18.04.

Mataki 1: Sanya Apache Web Server akan Ubuntu 18.04

1. Da farko ka fara da sabunta fakitin software ɗinka sannan ka shigar da sabar yanar gizo ta Apache ta amfani da bin umarni.

$ sudo apt update
$ sudo apt install apache2

2. Bayan aikin shigarwa ya cika, sabis na apache ya kamata ya fara ta atomatik kuma za a kunna shi don farawa a lokacin taya na tsarin, za ka iya duba idan ya tashi kuma yana aiki ta amfani da umarni masu zuwa.

$ sudo systemctl status apache2

3. Idan kana da tsarin wutan wuta yana kunna kuma yana gudana, kana buƙatar buɗe tashoshin jiragen ruwa 80 da 443 don ba da izinin buƙatun haɗin abokin ciniki zuwa sabar yanar gizo ta Apache ta HTTP da HTTPS bi da bi, sannan sake loda saitunan Tacewar zaɓi kamar yadda aka nuna.

$ sudo ufw allow 80/tcp
$ sudo ufw allow 443/tcp
$ sudo ufw reload

4. Yanzu tabbatar da shigarwar Apache ɗinku ta hanyar gwada shafin gwaji na asali a URL na ƙasa daga mai binciken gidan yanar gizo.

http://domain_name/
OR
http://SERVER_IP/

Idan kun ga tsohuwar shafin yanar gizon apache, yana nufin shigarwar ku yana aiki lafiya.

Mataki 2: Sanya MariaDB akan Ubuntu 18.04

5. Yanzu shigar da MariaDB, kyauta ce, tsarin gudanar da bayanan tushen tushen tushe wanda aka soke daga MySQL kuma aikin ne na al'umma wanda asalin masu haɓaka MySQL ke jagoranta.

$ sudo apt install mariadb-server mariadb-client

6. Ayyukan MariaDB ya kamata su fara ta atomatik bayan shigarwa, duba matsayinsa don tabbatar da cewa yana aiki da aiki.

$ sudo systemctl status mysql

7. Shigarwa na MariaDB ba shi da tsaro ta hanyar tsoho, kana buƙatar aiwatar da rubutun tsaro wanda ya zo tare da kunshin. Za a umarce ku don saita kalmar sirri don tabbatar da cewa babu wanda zai iya shiga cikin MariaDB.

$ sudo mysql_secure_installation

Da zarar kun aiwatar da rubutun, zai tambaye ku shigar da kalmar sirri ta yanzu don tushen (shigar da babu):

Sannan shigar da yes/y zuwa tambayoyin tsaro masu zuwa:

  • Shin saitin kalmar sirri? [Y/n]: y
  • Cire masu amfani da ba a san su ba? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
  • A hana tushen shiga daga nesa? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
  • Cire bayanan gwaji da samun dama gare shi? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
  • Sake ɗorawa teburin gata yanzu? (Latsa y|Y don Ee, kowane maɓalli don A'a): y

Mataki 3: Sanya PHP akan Ubuntu 18.04

8. PHP yana ɗaya daga cikin yaren rubutun gefen uwar garken da aka fi amfani da shi don samar da abun ciki mai ƙarfi akan gidajen yanar gizo da apps. Kuna iya shigar da PHP (Sigar tsoho shine PHP 7.2) da sauran kayayyaki don tura gidan yanar gizo ta amfani da umarni masu zuwa.

$ sudo apt install php php-common php-mysql php-gd php-cli 

9. Da zarar an shigar da PHP, za ku iya gwada saitin PHP ɗinku ta hanyar ƙirƙirar shafin info.php mai sauƙi a cikin tushen takaddun sabar yanar gizonku, ta amfani da wannan umarni guda ɗaya.

 
$ echo "<?php phpinfo(); ?>" | sudo tee /var/www/html/info.php

10. Sa'an nan bude wani web browser, sa'an nan shigar da wannan URL don duba php information page.

http://domain_name/info.php
OR
http://SERVER_IP/info.php

Mataki 4: Sanya PhpMyAdmin akan Ubuntu 18.04

11. A ƙarshe, za ku iya shigar da phpMyAdmin don gudanar da bayanan MySQL/MariaDB daga jin daɗin mai binciken gidan yanar gizon, ta hanyar bin umarni.

$ sudo apt install phpmyadmin

Ta hanyar tsarin shigarwa na kunshin, za a umarce ku don zaɓar sabar gidan yanar gizon da ya kamata a saita ta atomatik don gudanar da phpMyAdmin, zaɓi apache ta danna mashigin sarari kuma danna Shigar.

12. Na gaba, shigar da kalmar sirri don mai amfani da MySQL/MariaDB don haka mai sakawa zai iya ƙirƙirar bayanai don phpmyadmin.

13. Da zarar an shigar da komai, yanzu zaku iya sake kunna sabis na apache2 don aiwatar da canje-canjen kwanan nan.

$ sudo systemctl restart apache2

Lura: Idan kunshin PhpMyAdmin bai ba da damar yin aiki tare da sabar yanar gizo ta Apache ta atomatik, gudanar da waɗannan umarni don kwafi fayil ɗin sanyi na phpmyadmin wanda ke ƙarƙashin /etc/phpmyadmin/ zuwa uwar garken yanar gizo na Apache akwai shugabanci na saitin /etc/apache2/conf-available/sannan kunna shi ta amfani da mai amfani a2enconf, kuma sake kunna sabis na apache sakamakon canje-canjen kwanan nan, kamar haka.

$ sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf 
$ sudo a2enconf phpmyadmin
$ sudo systemctl restart apache2

14. A ƙarshe, daga gidan yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizon yanar gizo, kuma rubuta URL mai zuwa don samun dama ga gaban yanar gizon phpMyAdmin.

http://domain_name/phpmyadmin
OR
http://SERVER_IP/phpmyadmin

Yi amfani da tushen takaddun shaida don tantancewa a cikin phpMyAdmin, kamar yadda aka nuna a cikin hoton allo mai zuwa.

Muhimmi: Fara daga MySQL 5.7, tushen shiga yana buƙatar umarnin sudo, saboda haka tushen shiga zai gaza ta hanyar phpmyadmin, kuna iya buƙatar ƙirƙirar wani asusun mai amfani na admin. Shiga harsashin mariadb ta amfani da tushen asusun daga tashar tashar, kuma gudanar da umarni masu zuwa don ƙirƙirar sabon mai amfani:

$ sudo mysql -u root -p
MariaDB [(none)]> CREATE USER 'admin'@'localhost' IDENTIFIED BY '[email !#254tecmint';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
MariaDB [(none)]> FLUSH PRIVILEGES;

Yanzu shiga cikin PhpMyAdmin ta amfani da sabbin takaddun shaidar gudanarwa don gudanar da bayanan ku.

Don tabbatar da mahaɗin yanar gizon ku na PhpMyAdmin, duba wannan labarin: Nasiha 4 masu fa'ida don Kiyaye Interface na yanar gizo na PhpMyAdmin.

Shi ke nan! A cikin wannan labarin, mun bayyana yadda ake saita tarin LAMP tare da sabon PhpMyAdmin a cikin Ubuntu 18.04. Yi amfani da fam ɗin sharhin da ke ƙasa don aiko mana da tambayoyinku, ko tunani game da wannan jagorar.