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.

Enter the login credentials of MariaDB and SQLBuddy gets connected with the MariaDB database successfully With this, the installation of SQLBUddy 1.33 on CentOS 7.6 comes to end.