How to Install SQLBuddy 1.33v on CentOS 7.6
Installation Of SQLBudyy 1.33 on CentOS 7.6
SQL Buddy is an open-source web-based application written in PHP intended to handle the administration of MySQL and SQLite with the use of a Web browser. The project places an emphasis on ease of installation and a simple user interface. This article covers the method to install SQLBuddy on CentOS 7.6
Server requirements
PHP 4.3+
MySQL 4+
Download Link:
Click here, To downlad SQLBudyy 1.33
First, change the directory to Apache’s Document Root Directory.
[root@linuxhelp ~]# cd /var/www/html
Download SQLBUddy using the link given.
[root@linuxhelp html]# wget https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
--2019-05-13 16:27:11-- https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
Resolving github.com (github.com)... 192.30.253.112
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://raw.githubusercontent.com/calvinlough/sqlbuddy/gh-pages/sqlbuddy.zip [following]
--2019-05-13 16:27:13-- https://raw.githubusercontent.com/calvinlough/sqlbuddy/gh-pages/sqlbuddy.zip
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.0.133, 151.101.64.133, 151.101.128.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.0.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 385517 (376K) [application/zip]
Saving to: ‘sqlbuddy.zip’
100%[====================================================================================================>] 385,517 421KB/s in 0.9s
2019-05-13 16:27:15 (421 KB/s) - ‘sqlbuddy.zip’ saved [385517/385517]
List the contents to view the downloaded zip file of SQLBuddy.
[root@linuxhelp html]# ll
total 384
-rw-r--r-- 1 root root 385517 May 13 16:27 sqlbuddy.zip
-rw-r--r-- 1 root root 20 Apr 15 11:10 test.php
Extract the zip file of SQLBuddy using unzip.
[root@linuxhelp html]# unzip sqlbuddy.zip
Archive: sqlbuddy.zip
creating: sqlbuddy/
inflating: sqlbuddy/ajaxcreatetable.php
inflating: sqlbuddy/ajaxfulltext.php
inflating: sqlbuddy/ajaximportfile.php
inflating: sqlbuddy/ajaxquery.php
inflating: sqlbuddy/ajaxsavecolumnedit.php
inflating: sqlbuddy/css/print.css
inflating: sqlbuddy/dboverview.php
.
.
.
inflating: sqlbuddy/themes/classic/images/corner-bl.png
inflating: sqlbuddy/themes/classic/images/corner-br.png
inflating: sqlbuddy/themes/classic/images/corner-tl.png
inflating: sqlbuddy/themes/classic/images/corner-tr.png
inflating: sqlbuddy/themes/classic/images/header.png
inflating: sqlbuddy/themes/classic/images/shading.png
inflating: sqlbuddy/users.php
List the contents to view the extracted files from zip file of SQLBuddy.
[root@linuxhelp html]# ll
total 388
drwxr-xr-x 9 root root 4096 Jan 19 2011 sqlbuddy
-rw-r--r-- 1 root root 385517 May 13 16:27 sqlbuddy.zip
-rw-r--r-- 1 root root 20 Apr 15 11:10 test.php
Assign Ownership permissions to the SQLBuddy directory.
[root@linuxhelp html]# chown apache. Sqlbuddy
Create a customised Configuration file OF Apache for SQLbuddy.
[root@linuxhelp html]# vim /etc/httpd/conf.d/sqlbuddy.conf
<virtualhost *:80>
Servername 192.168.7.229
Documentroot /var/www/html/sqlbuddy/
<directory /var/www/html/sqlbuddy/>
Allowoverride all
Require granted all
</directory>
</virtualhost>
Restart the service of Apache.
[root@linuxhelp html]# systemctl restart httpd
Open the browser and enter the IP address that you have set in the configuration file.