Mai Gudanarwa – Cikakken Kayan Aikin Gudanar da Bayanan Bayanai na MySQL


Tsohon phpMyAdmin, Adminer kayan aikin sarrafa bayanai ne na gaba da aka rubuta a cikin PHP. Ba kamar phpMyAdmin ba, kawai ya ƙunshi fayil ɗin PHP guda ɗaya wanda za'a iya sauke shi akan sabar da aka yi niyya wanda za'a shigar da Adminer akansa.

Adminer yana ba da UI mai ɗorewa kuma mai sauƙi idan aka kwatanta da phpMyAdmin. Yana aiki tare da shahararrun tsarin sarrafa bayanai na SQL kamar MariaDB, PostgreSQL, MySQL, Oracle, SQLite, MS SQL da injin bincike na Elasticsearch.

A cikin wannan jagorar, za mu bi ku ta hanyar shigar da Adminer akan rabon tushen RHEL.

Mataki 1: Shigar da Stack LAMP a cikin RHEL

Tunda ana samun dama ga Adminer daga gaba-gaba da kuma sarrafa ta PHP, muna buƙatar shigar da tari na LAMP. Mun riga mun sami cikakken jagora kan yadda ake shigar da tarin LAMP akan Rarraba tushen RHEL.

Tare da tarin LAMP a wurin, ci gaba kuma shigar da ƙarin kari na PHP waɗanda ake buƙata don aiki tare da Adminer.

$ sudo dnf install php php-curl php-zip php-json php-mysqli php-gd 

Mataki 2: Ƙirƙiri Database don Adminer

Mataki na gaba shine ƙirƙirar bayanai don Adminer. Don haka, shiga cikin uwar garken bayanai.

$ sudo mysql -u root -p

Ƙirƙiri bayanan bayanai da mai amfani da bayanai.

CREATE DATABASE adminer_db;
CREATE USER 'adminer_user'@'localhost' IDENTIFIED BY '[email ';

Sa'an nan kuma ba da duk gata ga mai amfani da bayanan bayanai a kan Database Adminer.

GRANT ALL ON adminer_db.* TO 'adminer_user'@'localhost';

Aiwatar da canje-canje kuma fita uwar garken bayanai.

FLUSH PRIVILEGES;
EXIT;

Mataki 3: Zazzagewa kuma Sanya Adminer

Tare da bayanan Adminer a wurin, mataki na gaba shine zazzage fayil ɗin shigarwa na Adminer. Amma da farko, kuna buƙatar ƙirƙirar kundin adireshi don Adminer a Tushen Takardun kamar haka.

$ sudo mkdir -p /var/www/html/adminer

Na gaba, kewaya zuwa kundin adireshin Adminer.

$ cd /var/www/html/adminer 

Sannan zazzage sabuwar sigar umarnin wget kuma adana shi azaman index.php.

$ wget -O index.php https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php

Da zarar zazzagewar ta cika, saita ikon mallakar littafin da izini.

$ sudo chown -R apache:apache /var/www/html/adminer/
$ sudo chmod -R 775 /var/www/html/adminer/

Mataki 4: Sanya Apache don Adminer

Ci gaba, kuna buƙatar saita fayil ɗin runduna mai kama da Apache don Adminer. Don haka, ƙirƙiri babban fayil ɗin runduna a cikin /etc/httpd/conf.d/ directory.

$ sudo vim /etc/httpd/conf.d/adminer.conf

Manna waɗannan layukan cikin fayil ɗin don tabbatar da cewa kun maye gurbin ƙimar mydomain.com a cikin umarnin ServerName tare da yankin rajista na uwar garken ko IP na Jama'a.

<VirtualHost *:80>   
     ServerName mydomain.com
     DocumentRoot /var/www/html/adminer/
     ServerAdmin [email 
     DirectoryIndex index.php
     ErrorLog /var/log/httpd/adminer-error.log
     CustomLog /var/log/httpd/adminer-access.log combined
</VirtualHost>

Ajiye ku fita fayil ɗin sanyi.

Na gaba zata sake farawa Apache don amfani da canje-canjen da aka yi.

$ sudo systemctl restart httpd

Hakanan yana da hankali don tabbatar da cewa Apache yana gudana:

$ sudo systemctl status httpd

Bugu da kari, tabbatar da cewa tsarin ba shi da kowane kurakurai.

$ sudo apachectl configtest

Mataki 5: Shiga Adminer daga Web Browser

A ƙarshe, ƙaddamar da mai binciken gidan yanar gizon ku kuma bincika IP ɗin sabar ku ta amfani da URL mai zuwa.

http://server-ip or domain_name

Za ku sami shafin yanar gizon mai zuwa. Samar da bayanan bayanan MariaDB - mai amfani da MariaDB, kalmar sirri ga mai amfani, da sunan bayanan kuma danna 'Login'.

Da zarar an shiga, nuni na gaba zai shigo cikin gani. Daga nan, zaku iya aiwatar da ayyuka daban-daban na bayanai kamar ƙirƙirar bayanai, da teburi da aiwatar da tambayoyin SQL don ambaton kaɗan.

Wannan yana kusantar da wannan jagorar zuwa ƙarshe. Mun yi nasarar shigar da kuma daidaita Mai Gudanarwa akan rabon tushen RHEL.