Bii o ṣe le Fi Ipele LAMP sii pẹlu PhpMyAdmin ni Ubuntu 18.04

Akopọ LAMP kan ni awọn idii bii Apache, MySQL/MariaDB ati PHP ti a fi sii sori ayika eto Linux kan fun awọn oju opo wẹẹbu ati awọn ohun elo gbigbalejo.

PhpMyAdmin jẹ ọfẹ, orisun ṣiṣi, ti a mọ daradara, ti ẹya-ara ni kikun, ati oju-iwe ayelujara ti o ni ojulowo fun sisakoso MySQL ati ibi ipamọ data MariaDB. O ṣe atilẹyin ọpọlọpọ awọn iṣẹ ṣiṣe data, ati pe o ni ọpọlọpọ awọn ẹya ti o gba ọ laaye lati ṣakoso awọn iṣọrọ awọn apoti isura data rẹ ni irọrun lati oju-iwe wẹẹbu; gẹgẹbi gbigbe wọle ati gbigbeja data ni awọn ọna kika pupọ, ti o n ṣẹda eka ati awọn ibeere ti o wulo nipa lilo Ibeere-nipasẹ-apẹẹrẹ (QBE), ṣiṣakoso awọn olupin pupọ, ati pupọ diẹ sii.

  1. Pipin olupin Ubuntu 18.04 Pọọku.
  2. Wọle si olupin nipasẹ SSH (ti o ko ba ni iwọle taara).
  3. Gbongbo awọn anfani olumulo tabi lo pipaṣẹ sudo lati ṣiṣe gbogbo awọn ofin.

Ninu àpilẹkọ yii, a yoo ṣalaye bi a ṣe le fi akopọ LAMP sori ẹrọ pẹlu PhpMyAdmin ni Ubuntu 18.04.

Igbesẹ 1: Fi Server Server Web Apache sori Ubuntu 18.04

1. Akọkọ bẹrẹ nipa mimu awọn idii sọfitiwia rẹ ṣe ati lẹhinna fi sori ẹrọ olupin ayelujara Apache nipa lilo awọn ofin wọnyi.

$ sudo apt update
$ sudo apt install apache2

2. Lẹhin ti ilana fifi sori ẹrọ ti pari, iṣẹ afun yẹ ki o bẹrẹ laifọwọyi ati pe yoo muu ṣiṣẹ lati bẹrẹ ni akoko bata eto, o le ṣayẹwo ti o ba wa ni oke ati ṣiṣe ni lilo pipaṣẹ atẹle.

$ sudo systemctl status apache2

3. Ti o ba ni ogiriina eto ti o ṣiṣẹ ati ti n ṣiṣẹ, o nilo lati ṣii awọn ibudo 80 ati 443 lati gba awọn ibeere asopọ alabara laaye lati ṣapa olupin ayelujara nipasẹ HTTP ati HTTPS lẹsẹsẹ, lẹhinna tun gbe awọn eto ogiriina naa bi o ti han.

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

4. Bayi jẹrisi fifi sori Apache rẹ nipasẹ idanwo oju-iwe idanwo aiyipada ni URL isalẹ lati aṣawakiri wẹẹbu kan.

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

Ti o ba wo oju-iwe wẹẹbu aiyipada apache, o tumọ si pe fifi sori rẹ n ṣiṣẹ daradara.

Igbesẹ 2: Fi MariaDB sori Ubuntu 18.04

5. Nisisiyi fi sori ẹrọ MariaDB, jẹ ọfẹ, eto iṣakoso ibi ipamọ orisun ṣiṣii ti forked lati MySQL ati pe o jẹ iṣẹ idagbasoke ti agbegbe ti o jẹ oludari nipasẹ awọn oludasile akọkọ ti MySQL.

$ sudo apt install mariadb-server mariadb-client

6. Awọn iṣẹ MariaDB yẹ ki o bẹrẹ laifọwọyi lẹhin fifi sori ẹrọ, ṣayẹwo ipo rẹ lati rii daju pe o ti n ṣiṣẹ ati ṣiṣe.

$ sudo systemctl status mysql

7. Fifi sori ẹrọ MariaDB ko ni aabo nipasẹ aiyipada, o nilo lati ṣe iwe afọwọkọ aabo kan ti o wa pẹlu package. A yoo beere lọwọ rẹ lati ṣeto ọrọ igbaniwọle root lati rii daju pe ko si ẹnikan ti o le wọle sinu MariaDB.

$ sudo mysql_secure_installation

Lọgan ti o ba ṣiṣẹ iwe afọwọkọ naa, yoo beere lọwọ rẹ lati tẹ ọrọ igbaniwọle lọwọlọwọ fun gbongbo (tẹ sii fun ko si):

Lẹhinna tẹ bẹẹni/y si awọn ibeere aabo wọnyi:

    Ṣeto ọrọ igbaniwọle root? [Y/n]: y
  • Mu awọn olumulo alailorukọ kuro? (Tẹ y | Y fun Bẹẹni, bọtini eyikeyi miiran fun Bẹẹkọ): y
  • Ṣe iwọle wiwọle lati gbongbo latọna jijin? (Tẹ y | Y fun Bẹẹni, bọtini eyikeyi miiran fun Bẹẹkọ): y
  • Mu ibi ipamọ data idanwo kuro ki o wọle si rẹ? (Tẹ y | Y fun Bẹẹni, bọtini eyikeyi miiran fun Bẹẹkọ): y
  • Tun gbee awọn tabili anfaani bayi? (Tẹ y | Y fun Bẹẹni, bọtini eyikeyi miiran fun Bẹẹkọ): y

Igbesẹ 3: Fi PHP sori Ubuntu 18.04

8. PHP jẹ ọkan ninu ede afọwọkọ ẹgbẹ olupin ti a lo ni ibigbogbo ti a lo lati ṣe ina akoonu agbara lori awọn oju opo wẹẹbu ati awọn lw. O le fi PHP sii (ẹya aiyipada ni PHP 7.2) ati awọn modulu miiran fun awọn imuṣiṣẹ wẹẹbu nipa lilo pipaṣẹ atẹle.

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

9. Lọgan ti a fi PHP sii, o le idanwo idanwo PHP rẹ nipa ṣiṣẹda oju-iwe info.php ti o rọrun ninu gbongbo iwe ipamọ olupin ayelujara rẹ, ni lilo aṣẹ kan ṣoṣo yii.

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

10. Lẹhinna ṣii ẹrọ lilọ kiri lori wẹẹbu kan, ki o tẹ URL yii sii lati wo oju-iwe alaye php.

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

Igbesẹ 4: Fi PhpMyAdmin sori Ubuntu 18.04

11. Lakotan, o le fi phpMyAdmin sori ẹrọ fun sisakoso awọn apoti isura data MySQL/MariaDB lati itunu aṣawakiri wẹẹbu kan, nipa ṣiṣe pipaṣẹ atẹle.

$ sudo apt install phpmyadmin

Nipasẹ ilana fifi sori ẹrọ package, ao beere lọwọ rẹ lati yan olupin ayelujara ti o yẹ ki o tunto ni adaṣe lati ṣiṣẹ phpMyAdmin, yan afun nipa titẹ bọtini aaye ki o tẹ Tẹ.

12. Nigbamii, tẹ ọrọ igbaniwọle sii fun olumulo iṣakoso MySQL/MariaDB ki oluṣeto le ṣẹda data fun phpmyadmin.

13. Lọgan ti ohun gbogbo ti fi sii, o le tun bẹrẹ iṣẹ apache2 lati ṣe awọn ayipada to ṣẹṣẹ.

$ sudo systemctl restart apache2

Akiyesi: Ti package PhpMyAdmin ko ba jẹ ki o ṣiṣẹ pẹlu olupin wẹẹbu afun laifọwọyi, ṣiṣe awọn ofin wọnyi lati daakọ faili iṣeto apache phpmyadmin ti o wa labẹ/ati be be/phpmyadmin/si apache webserver itọsọna awọn atunto to wa/ati be be lo/apache2/conf-available/ati lẹhinna muu ṣiṣẹ nipa lilo iwulo a2enconf, ati tun bẹrẹ iṣẹ iṣẹ afun ni awọn ayipada to ṣẹṣẹ ṣe, bi atẹle.

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

14. Ni ikẹhin, lati ẹrọ aṣawakiri wẹẹbu kan, ki o tẹ URL atẹle lati wọle si ọ iwaju iwaju phpMyAdmin ayelujara.

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

Lo awọn iwe eri root lati jẹrisi ninu phpMyAdmin, bi o ṣe han ninu shot iboju atẹle.

Pataki: Bibẹrẹ lati MySQL 5.7, iwọle root nilo aṣẹ sudo, nitorinaa ibuwolu wọle root yoo kuna nipasẹ phpmyadmin, o le nilo lati ṣẹda iroyin olumulo olumulo miiran. Wọle si ikarahun mariadb nipa lilo akọọlẹ gbongbo lati ebute kan, ati ṣiṣe awọn ofin wọnyi lati ṣẹda olumulo tuntun:

$ 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;

Bayi wọle sinu PhpMyAdmin nipa lilo awọn iwe eri abojuto tuntun lati ṣakoso awọn apoti isura data rẹ.

Lati ni aabo oju opo wẹẹbu PhpMyAdmin rẹ, ṣayẹwo nkan yii: 4 Awọn imọran Wulo lati Ni aabo Ọlọpọọmídíà PhpMyAdmin.

O n niyen! Ninu nkan yii, a ti ṣalaye bii o ṣe le ṣeto akopọ LAMP pẹlu PhpMyAdmin tuntun ni Ubuntu 18.04. Lo fọọmu asọye ni isalẹ lati firanṣẹ awọn ibeere rẹ, tabi awọn ero nipa itọsọna yii.