Onye nchịkwa – Ngwá ọrụ njikwa nchekwa data MySQL egosipụtara zuru oke

Onye bụbu phpMyAdmin, Adminer bụ ngwa njikwa nchekwa data dị n'ihu nke edere na PHP. N'adịghị ka phpMyAdmin, ọ na-agụnye naanị otu faịlụ PHP nke enwere ike ibudata na ihe nkesa nke a ga-etinye Adminer na ya.

Onye nchịkwa na-enye UI gbadara agbadata na leaner ma e jiri ya tụnyere phpMyAdmin. Ọ na-arụ ọrụ na sistemụ njikwa nchekwa data SQL ama ama dị ka MariaDB, PostgreSQL, MySQL, Oracle, SQLite, MS SQL yana igwe nchọta Elasticsearch.

N'ime ntuziaka a, anyị ga-ejegharị gị site na ntinye nke Adminer na nkesa dabere na RHEL.

Kwụpụ 1: Wụnye LAMP Stack na RHEL

Ebe ọ bụ na a na-enweta Adminer site na njedebe ihu na PHP kwadoro ya, anyị kwesịrị ịwụnye nchịkọta LAMP. Anyị enweelarị ntuziaka zuru oke maka otu esi etinye ngwugwu LAMP na Nkesa dabere na RHEL.

Site na ngwugwu LAMP dị, gaba na wụnye mgbakwunye PHP ndị ọzọ achọrọ ka ya na Adminer rụọ ọrụ.

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

Kwụpụ 2: Mepụta database maka onye nchịkwa

Nzọụkwụ ọzọ bụ ịmepụta nchekwa data maka Adminer. Yabụ, banye na sava nchekwa data.

$ sudo mysql -u root -p

Mepụta nchekwa data na onye ọrụ nchekwa data.

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

Mgbe ahụ nye onye ọrụ nchekwa data ohere niile na nchekwa data Adminer.

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

Tinye mgbanwe ndị ahụ wee pụọ na nkesa nchekwa data.

FLUSH PRIVILEGES;
EXIT;

Kwụpụ 3: Budata ma hazie Adminer

Site na ebe nchekwa data Adminer dị, nzọụkwụ ọzọ bụ ibudata faịlụ nwụnye Adminer. Mana nke mbụ, ịkwesịrị ịmepụta ndekọ maka Adminer na Document Root dị ka ndị a.

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

Ọzọ, gaa na ndekọ Adminer.

$ cd /var/www/html/adminer 

Wee budata ụdị iwu wget kachasị ọhụrụ wee chekwaa ya dị ka index.php.

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

Ozugbo nbudata nbudata ahụ, tọọ ikike na ikike ndekọ ndekọ ndị a.

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

Kwụpụ 4: Hazie Apache maka Adminer

N'ịga n'ihu, ịkwesịrị ịhazi faịlụ nnabata Apache mebere maka Adminer. Yabụ, mepụta faịlụ nnabata mebere na /etc/httpd/conf.d/ directory.

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

Tapawa ahịrị ndị a n'ime faịlụ ahụ iji hụ na ị dochie uru mydomain.com na ntuziaka ServerName na ngalaba aha nke sava gị ma ọ bụ IP ọha.

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

Chekwaa wee pụọ na faịlụ nhazi.

Malitegharịa ekwentị ọzọ Apache ka itinye mgbanwe ndị emere.

$ sudo systemctl restart httpd

Ọ dịkwa akọ ịhụ na Apache na-agba ọsọ:

$ sudo systemctl status httpd

Na mgbakwunye, hụ na nhazi ahụ enweghị njehie ọ bụla.

$ sudo apachectl configtest

Kwụpụ 5: Nweta Adminer site na ihe nchọgharị weebụ

N'ikpeazụ, malite ihe nchọgharị weebụ gị wee chọgharịa IP nke ihe nkesa gị site na iji URL na-esonụ.

http://server-ip or domain_name

Ị ga-enweta ibe weebụ na-esonụ. Nye nzere nchekwa data MariaDB - onye ọrụ MariaDB, paswọọdụ nye onye ọrụ, yana aha nchekwa data wee pịa 'Nbanye'.

Ozugbo ịbanye, ngosi na-esote ga-abata. Site na ebe a, ị nwere ike ịrụ ọrụ nchekwa data dị iche iche dị ka ịmepụta ọdụ data, na tebụl na imezu ajụjụ SQL iji kwuo ole na ole.

Nke a na-adọta ntuziaka a na njedebe. Anyị etinyela ma hazie Adminer na nkesa dabere na RHEL.