SQL Buddy - Kayan aikin Gudanar da MySQL na Yanar Gizo

SQL Buddy kayan aiki ne na bude yanar gizo an rubuta su ne da yaren PHP wadanda suke nufin gudanar da SQLite da gudanar da MySQL ta hanyar masu binciken yanar gizo kamar Firefox, Chrome, Safari, Opera da IE + (Internet Explorer).

SQL Buddy aikace-aikace ne mai sauƙi, mara nauyi kuma mai saurin gaske wanda ke ba da ingantaccen tsari tare da cikakken fasalin da aka saita don masu gudanar da bayanai da masu shirye-shirye. Kayan aikin yana baka damar karawa, gyarawa, gyarawa da sauke bayanai da teburan, shigo da fitar da bayanai na zamani, fihirisa, alakar mahiman kasashen waje, gudanar da tambayoyin SQL da sauransu.

Kyakkyawan madadin ne zuwa ga phpMyAdmin tare da saurin yanar gizo mai saurin inganta Ajax tare da tallafi don harsuna daban daban 47 da jigogi. Idan aka kwatanta da phpMyAdmin, SQL Buddy yana da kusan dukkanin sifofin da aka saita na phpMyAdmin amma SQL Buddy yana da nauyi sosai a cikin girman 320kb (watau 1.1MB) bayan cirewa kuma yana da sauƙin saitawa babu shigarwa da ake buƙata, kawai buɗe fayilolin a ƙarƙashin tushen tushen sabar yanar gizo da shiga a tare da sunan mai amfani da kalmar wucewa na bayanan ku.

SQL Buddy kuma yana ba da wasu gajerun hanyoyin maɓallan keyboard masu amfani kamar ƙirƙira, gyara, sharewa, wartsakewa, zaɓi duka da tambaya, don haka zaku iya sarrafa kayan aikin ba tare da amfani da linzamin kwamfuta ba. Idan kayi ma'amala da adadi mai yawa na bayanan MySQL, to SQL Buddy shine zaɓin duk lokacinku.

Shigar da SQL Buddy a cikin Linux

Don amfani da SQL Buddy, da farko wget umarni da kuma cire fayilolin a cikin babban fayil sannan kuma loda babban fayil ɗin zuwa kundin tushen sabar yanar gizonku ta hanyar ftp. Misali, (/ var/www/html/sqlbuddy) a halin da nake ciki, amma bai kamata ba inda ka sanya su ko kuma menene sunan babban fayil ɗin.

# wget https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
# unzip sqlbuddy.zip
# mv sqlbuddy /var/www/html/

Na gaba, kewaya zuwa burauzar gidan yanar gizo ka rubuta umarni mai zuwa don ƙaddamar da SQL Buddy.

http://yourserver.com/sqlbuddy
OR
http://youripaddress/sqlbuddy

Zaɓi MySQL kuma shigar da sunan mai amfani da kalmar wucewa.

Allon maraba da SQL Buddy.

Waɗannan ga wasu gajerun hanyoyin mabuɗin maɓallin kebul na SQL mai amfani.

Idan kanaso ka siffanta kafarka, to akwai 'yan canjin masu amfani masu amfani a cikin config.php wadanda zaka iya sha'awa.

# vi /var/www/html/sqlbuddy/config.php

Idan kana son takaita SQL Buddy zuwa takamaiman adireshin IP, sannan ka buɗe fayil ɗin tare da editan VI.

# vi /etc/httpd/conf.d/sqlbuddy.conf

Theara waɗannan layukan masu zuwa zuwa fayil ɗin sqlbuddy.conf. Sauya adireshin-ip-ɗinka tare da sabarku.

Alias /cacti    /var/www/html/sqlbuddy

<Directory /var/www/html/sqlbuddy>
        <IfModule mod_authz_core.c>
                # httpd 2.4
                Require all granted
        </IfModule>
        <IfModule !mod_authz_core.c>
                # httpd 2.2
                Order deny,allow
                Deny from all
                Allow from your-ip-address
        </IfModule>
</Directory>

Sake kunna sabar yanar gizo.

# service httpd restart		
OR
# systemctl restart apache2	

Idan kuna buƙatar kowane taimako, da fatan za a ziyarci zauren da ake da shi a batutuwan sql-buddy ko amfani da sashin sharhinmu don kowace tambaya.