Mai Gudanarwa - Babban Kayan Aikin Gudanarwar Bayanan Bayanai na Yanar Gizo don Linux


Kullum muna hulɗa tare da bayanan bayanai don yin ayyuka ta hanyoyi daban-daban. Za mu iya haɗa kai tsaye kuma mu aiwatar da ayyukan ta amfani da yanayin SQL CLI ko mai amfani da ba DBA ba ya fi son amfani da kayan aikin GUI da ake kira phpMyAdmin ko phpPgAdmin.

Yawancin mu suna sane da kayan aikin sarrafa bayanai na phpMyAdmin ko phpPgAdmin. Wannan sakon zai yi magana game da wani kayan aikin sarrafa bayanai da ake kira Adminer.

Menene Adminer

Adminer (Tsohon phpMinAdmin) cikakken kayan aikin sarrafa bayanai ne da aka rubuta cikin PHP. Adminer madadin phpMyAdmin ne inda za mu iya sarrafa abun ciki a cikin MySQL, SQLite, Oracle, PostgreSQL bayanai yadda ya kamata.

Akwai adadin kayan aikin sarrafa bayanai na tushen yanar gizo da ake samu. Mun sami Adminer yana da abokantaka sosai. Muna ɗauka cewa kun riga kun shigar Apache, PHP da kuma bayanan bayanan da kuka zaɓa.

Siffofin Gudanarwa

  1. Ayyukan asali: ƙara/cire/gyara bayanan bayanai/tables.
  2. gyara bayanan bayanai (ra'ayoyi, masu jawowa, matakai, izinin mai amfani, masu canji, matakai da sauransu)
  3. Ku aiwatar da umarnin SQL daga filin rubutu ko fayil.
  4. Shigo da fitarwa bayanan bayanai da teburi.
  5. Fitar da bayanai, bayanai, tsari, ra'ayoyi, abubuwan yau da kullun zuwa SQL ko CSV.
  6. Nuna matakai kuma kashe su.
  7. Nuna masu amfani da izini kuma canza su.
  8. Goyi bayan harsuna da yawa.

Abubuwan da ake bukata

  1. Sabar yanar gizo ta Apache
  2. Yana goyan bayan PHP 5 tare da kunna zaman
  3. Database (MySQL, PostgreSQL, SQLite, MongoDB, da sauransu)

Me yasa ake amfani da Adminer?

Babu shakka cewa phpMyAdmin yana ɗaya daga cikin shahararrun buɗaɗɗen kayan aikin sarrafa bayanai don sarrafa bayanan MySQL. Koyaya, saboda wasu dalilai ina tsammanin bai dace sosai ba wanda shine dalilin, Adminer ya shigo cikin hoto.

Yanzu, kuna tunanin dalilin da yasa Adminer shine mafi kyawun madadin phpMyadmin? A gaskiya, faɗin lissafin ya yi girma da yawa kuma wasu maki na iya zama marasa mahimmanci a gare ku. Mafi mahimmancin bambance-bambancen su ne:

  1. Tidier mai sauƙin amfani mai amfani
  2. Taimako na musamman don fasalulluka na MySQL
  3. Babban aiki
  4. Ƙarancin girma (366kB kawai)
  5. Akwai tsaro sosai

Don ƙarin sani game da cikakken fasali da kwatantawa tsakanin su, duba shafin kwatanta.

Shigar da Adminer a cikin Linux

Jeka gidan yanar gizon Adminer kuma zazzage sabbin fayilolin tushen (watau sigar 4.0.2) ta amfani da hanyar haɗin ƙasa.

  1. http://www.adminer.org/en/#download

A madadin, kuna iya ɗaukar sabon fakitin tushe ta amfani da umarnin wget mai zuwa.

 wget http://downloads.sourceforge.net/adminer/adminer-4.0.2.zip

Cire fayil ɗin zip ɗin mai gudanarwa, wanda zai ƙirƙiri adireshi mai gudanarwa tare da fayiloli.

 unzip adminer-4.0.2.zip

Kwafi 'adminer-4.0.2' directory cikin DocumentRoot na sabar gidan yanar gizon ku.

 cp -r adminer-4.0.2 /var/www/html/		[For RedHat based Systems]

 cp -r adminer-4.0.2 /var/www/			[For Debian based Systems]

A ƙarshe, buɗe kuma nuna maka burauzarka a 'adminer' directory.

http://localhost/adminer-4.02/adminer
OR
http://ip-address/adminer-4.02/adminer

Shigar da sunan mai amfani da kalmar sirri na bayananku don shiga cikin panel.

Rubutun Magana

Shafin Mai Gudanarwa

Kammalawa

Adminer kayan aiki ne mai ƙarfi na tushen bayanai na yanar gizo tare da fasalulluka masu yawa. Da fatan za a gwada shi kuma ku raba gwaninta tare da mu ta akwatin sharhi da ke ƙasa.