Bii o ṣe le Fi sori ẹrọ Titun PhpMyAdmin ni RHEL, CentOS & Fedora
Isakoso MySQL nipasẹ laini aṣẹ ni Linux jẹ iṣẹ ti o nira pupọ fun eyikeyi alakoso eto tuntun tabi olutọju ibi ipamọ data, nitori pe o ni ọpọlọpọ awọn ofin eyiti a ko le ranti ninu igbesi aye wa lojoojumọ.
Lati ṣe iṣakoso MySQL rọrun pupọ a n ṣe agbekalẹ irinṣẹ iṣakoso MySQL wẹẹbu kan ti a pe ni PhpMyAdmin, pẹlu iranlọwọ ti ọpa yii o le ṣakoso ati ṣakoso iṣakoso data data rẹ nipasẹ ẹrọ lilọ kiri lori ayelujara ni irọrun.
PhpMyAdmin jẹ wiwo oju-iwe wẹẹbu fun iṣakoso awọn apoti isura data MySQL/MariaDB ti a lo bi rirọpo fun awọn ohun elo laini aṣẹ.
O ti kọ ni ede PHP, nipasẹ ohun elo yii o le ṣe ọpọlọpọ awọn iṣẹ ṣiṣe iṣakoso MySQL bii ṣiṣẹda, ju silẹ, paarọ, paarẹ, gbe wọle, okeere, wiwa, ibeere, atunṣe, ṣatunṣe ati ṣiṣe aṣẹ iṣakoso data miiran nipasẹ ẹrọ lilọ kiri ayelujara.
Gẹgẹbi awọn atọkun oju-iwe wẹẹbu ti a mọ daradara fun iṣakoso awọn iṣẹ eto, awọn irinṣẹ ẹda bulọọgi, tabi awọn eto iṣakoso akoonu (CMSs), igbagbogbo ni a fojusi nipasẹ awọn olulu irira ti o wa lati lo nilokulo aini awọn igbese aabo.
Ninu àpilẹkọ yii a yoo fi ọ han bi o ṣe le fi sori ẹrọ ẹya iduroṣinṣin tuntun ti PhpMyAdmin fun Apache tabi Nginx lori awọn pinpin RHEL, CentOS ati Fedora.
Nibi a ti pese fifi sori ẹrọ ti PhpMyAdmin fun mejeeji Apache tabi Nginx olupin ayelujara naa. Nitorinaa, o wa si ọ iru olupin wẹẹbu lati yan fun fifi sori ẹrọ.
Ṣugbọn ma ranti pe, o gbọdọ ni LAMP ṣiṣẹ (Linux, Apache, PHP ati MySQL/MariaDB) tabi LEMP (Linux, Nginx, PHP ati MySQL/MariaDB) ti fi sori ẹrọ lori eto iṣẹ rẹ.
Ti o ko ba ni atupa ṣiṣẹ tabi LEMP, o le tẹle awọn nkan wa ni isalẹ si iṣeto.
- Fi atupa atupa sori RHEL/CentOS 7/6 & Fedora 28-24
- Fi sori ẹrọ LEMP Stack lori RHEL/CentOS 7/6 & Fedora 28-24
Igbesẹ 1: Fi EPEL ati Awọn ibi ipamọ Remi sii
1. Lati fi ẹya ti o ṣẹṣẹ julọ ti PhpMyAdmin (ie 4.8) sori ẹrọ, o nilo lati fi sori ẹrọ ati mu ṣiṣẹ awọn ibi ipamọ EPEL ati Remi lori awọn pinpin kaakiri Linux bi o ti han:
# yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
-------------- On RHEL/CentOS 6 - 32-bit -------------- # yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm -------------- On RHEL/CentOS 6 - 64-bit -------------- # yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-28.rpm [On Fedora 28] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-27.rpm [On Fedora 27] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-26.rpm [On Fedora 26] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-25.rpm [On Fedora 25] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-24.rpm [On Fedora 24]
2. Lọgan ti o ba ti fi sii awọn ibi ipamọ loke, bayi o jẹ ‘akoko rẹ lati fi PhpMyAdmin sori ẹrọ pẹlu iranlọwọ ti aṣẹ atẹle bi o ti han.
# yum --enablerepo=remi install phpmyadmin
Akiyesi: Ti tirẹ ba nlo PHP 5.4 lori awọn eto RHEL/CentOS/Fedora, lẹhinna o nilo lati ṣiṣe aṣẹ isalẹ lati fi sii.
# yum --enablerepo=remi,remi-test install phpmyadmin
Ninu Apache iwọ ko nilo lati tunto ohunkohun fun phpMyAdmin, nitori iwọ yoo gba phpMyAdmin ṣiṣẹ laifọwọyi ni adirẹsi http:// .
Faili iṣeto ni akọkọ wa labẹ /etc/httpd/conf.d/phpMyAdmin.conf, rii daju pe Beere gbogbo itọsọna ti a fun (Fun Apache 2.4) ati Gba laaye lati adiresi ip ti wa ni afikun inu Itọsọna /usr/share/phpmyadmin ohun amorindun.
Lakotan, tun bẹrẹ Apache lati lo awọn ayipada.
-------------- On RHEL/CentOS 7 and Fedora 28-24 -------------- # systemctl restart httpd -------------- On RHEL/CentOS 6 -------------- # service httpd restart
Lori Nginx olupin ayelujara, a yoo ṣẹda ọna asopọ aami si awọn faili fifi sori ẹrọ PhpMyAdmin si itọsọna root iwe Nginx wẹẹbu wa (ie/usr/share/nginx/html) nipa ṣiṣe pipaṣẹ wọnyi:
# ln -s /usr/share/phpMyAdmin /usr/share/nginx/html
Lakotan, tun bẹrẹ Nginx ati PHP-FPM lati lo awọn ayipada.
-------------- On RHEL/CentOS 7 and Fedora 28-24 -------------- # systemctl restart nginx # systemctl restart php-fpm -------------- On RHEL/CentOS 6 -------------- # service nginx restart # service php-fpm restart
Ṣii ẹrọ aṣawakiri rẹ ki o tọka aṣawakiri rẹ si http:// . O yẹ ki o ṣii wiwo phpmyadmin (bi o ṣe han ninu aworan ni isalẹ).
Ninu awọn nkan ti o nbọ, a yoo pin diẹ ninu awọn imọran lati ni aabo fifi sori phpmyadmin rẹ lori atupa kan tabi akopọ LEMP lodi si awọn ikọlu ti o wọpọ julọ ti awọn eniyan irira ṣe.