☰
✕
✕

How to install SQL Buddy on Ubuntu

How to install SQL Buddy on Ubuntu

SQL Buddy is free and open source MySQL Database Administration tool similar to PhpMyAdmin where the user can manage the MySQL database in a graphical way through web browser. This tutorial covers the installation process of SQL Buddy on Ubuntu.

Installation procedure

For the SQL Buddy to run on Ubuntu, it requires the LAMP environment to run so first install the LAMP server and follow the instructions to install SQL Buddy. To download the SQL Buddy, go to http://sqlbuddy.com/ to download the package or else use below command to download via command line. 

[root@linuxhelp ~]# wget https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
--2017-04-19 14:42:25--  https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
Resolving github.com (github.com)... 192.30.253.112, 192.30.253.113
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: 385517 (376K) [application/zip]
Saving to: ‘ sqlbuddy.zip' 
100%[===========================================================================================================================================> ] 385,517      260KB/s   in 1.4s  
2017-04-19 14:42:29 (260 KB/s) - ‘ sqlbuddy.zip’  saved [385517/385517]

Once it is downloaded extract the package into document root of apache web server by using the unzip command. 

[root@linuxhelp ~]# unzip sqlbuddy.zip -d /var/www/html/
Archive:  sqlbuddy.zip
   creating: /var/www/html/sqlbuddy/
  inflating: /var/www/html/sqlbuddy/ajaxcreatetable.php 
  inflating: /var/www/html/sqlbuddy/ajaxfulltext.php 
  inflating: /var/www/html/sqlbuddy/ajaximportfile.php 
  inflating: /var/www/html/sqlbuddy/ajaxquery.php 
  inflating: /var/www/html/sqlbuddy/ajaxsavecolumnedit.php 
  inflating: /var/www/html/sqlbuddy/ajaxsaveedit.php 
  inflating: /var/www/html/sqlbuddy/ajaxsaveuseredit.php 
  inflating: /var/www/html/sqlbuddy/browse.php 
  inflating: /var/www/html/sqlbuddy/config.php 
   creating: /var/www/html/sqlbuddy/css/
  inflating: /var/www/html/sqlbuddy/css/common.css 
  inflating: /var/www/html/sqlbuddy/css/navigation.css 
  inflating: /var/www/html/sqlbuddy/css/print.css
.
.
.
/var/www/html/sqlbuddy/themes/classic/images/corner-tl.png 
  inflating: /var/www/html/sqlbuddy/themes/classic/images/corner-tr.png 
  inflating: /var/www/html/sqlbuddy/themes/classic/images/header.png 
  inflating: /var/www/html/sqlbuddy/themes/classic/images/shading.png 
  inflating: /var/www/html/sqlbuddy/users.php

Now change the ownership and file permission for MyWebSQL directory inside the document root.

[root@linuxhelp ~]# chown -R apache:apache /var/www/html/sqlbuddy/
[root@linuxhelp ~]# chmod -R 775 /var/www/html/sqlbuddy/

Open the browser and navigate to following URL http://192.168.7.160/sqlbuddy and press enter. It will lead to the SQL Buddy login page. Enter the required credentials and login.

Now the user can administer the database, schemas and tables through SQL Buddy.

Wasn' t that an installation procedure? SQL Buddy places an emphasis on ease of installation and a simple user interface.

Tag : Ubuntu Database Administration
FAQ
Q
How to access SQL Buddy on Ubuntu from web?
A
You can access SQL Buddy on Ubuntu by accessing the local host.
Q
What is SQL Buddy on ubuntu?
A
SQL Buddy is free and open source MySQL Database Administration tool similar to PhpMyAdmin where the user can manage the MySQL database in a graphical way through web browser.
Q
is SQL Buddy on Ubuntu developed using PHP?
A
yes, SQL Buddy on Ubuntu is developed by PHP
Q
what are the minimum requirement of SQL Buddy on Ubuntu ?
A
the minimum requirement of SQL Buddy on Ubuntu were
PHP 4.3+
MySQL 4+
Q
what are the Supported browsers for SQL Buddy on Ubuntu ?
A
The Supported browsers for SQL Buddy on Ubuntu were
Chrome
Firefox
Safari
Opera
Internet Explorer 7+