How to install MyWebSQL on Ubuntu

How to install MyWebSQL on Ubuntu

MyWebSQL 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 procedure of MyWebSQL on Ubuntu.

Installation procedure

The MyWebSQL requires the LAMP environment so setup the LAMP server and follow the below instructions to install MyWebSQL. Now go to http://mywebsql.net/ to download the MyWebSQL package or else use the below command to download via command line.

root@linuxhelp:~# wget https://excellmedia.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
--2017-04-19 14:28:20--  https://excellmedia.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
Resolving excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)... 202.153.32.19
Connecting to excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)|202.153.32.19|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1683612 (1.6M) [application/octet-stream]
Saving to: ‘ mywebsql-3.7.zip’ 
mywebsql-3.7.zip                            100%[=========================================================================================> ]   1.61M   152KB/s    in 9.2s   
2017-04-19 14:28:30 (179 KB/s) - ‘ mywebsql-3.7.zip’  saved [1683612/1683612]

Once it is downloaded, extract the package into document root of apache web server by executing the following command.

root@linuxhelp:~# unzip mywebsql-3.7.zip -d /var/www/html/
Archive:  mywebsql-3.7.zip
   creating: /var/www/html/mywebsql/backups/
  inflating: /var/www/html/mywebsql/backups/.htaccess 
  inflating: /var/www/html/mywebsql/backups/readme.txt 
  inflating: /var/www/html/mywebsql/cache.php 
   creating: /var/www/html/mywebsql/config/
  inflating: /var/www/html/mywebsql/config/.htaccess 
  inflating: /var/www/html/mywebsql/config/auth.php  
  inflating: /var/www/html/mywebsql/config/backups.php 
  inflating: /var/www/html/mywebsql/config/blobs.php 
  inflating: /var/www/html/mywebsql/config/config.php 
  inflating: /var/www/html/mywebsql/config/constants.php
.
.
.
/var/www/html/mywebsql/themes/pinky/README.md 
  inflating: /var/www/html/mywebsql/themes/pinky/results.css 
  inflating: /var/www/html/mywebsql/themes/pinky/theme.css
  inflating: /var/www/html/mywebsql/themes/pinky/treeview.css 
   creating: /var/www/html/mywebsql/tmp/
  inflating: /var/www/html/mywebsql/tmp/.htaccess 
  inflating: /var/www/html/mywebsql/tmp/readme.txt

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

root@linuxhelp:~# chown -R www-data:www-data /var/www/html/mywebsql/
root@linuxhelp:~# chmod -R 775 /var/www/html/mywebsql/

Next install the following php extensions by running the following command and press y to continue with the installation.

root@linuxhelp:~# apt-get install php-pgsql -y
Reading package lists... Done
Building dependency tree     
Reading state information... Done
The following additional packages will be installed:
  libpq5 php7.0-pgsql
The following NEW packages will be installed:
  libpq5 php-pgsql php7.0-pgsq
0 upgraded, 3 newly installed, 0 to remove and 476 not upgraded.
Need to get 136 kB of archives.
After this operation, 494 kB of additional disk space will be used.
Get:1 http://in.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libpq5 amd64 9.5.6-0ubuntu0.16.04 [78.2 kB]
Get:2 http://in.archive.ubuntu.com/ubuntu xenial-updates/main amd64 php7.0-pgsql amd64 7.0.15-0ubuntu0.16.04.4 [56.3 kB]
.
.
.
Creating config file /etc/php/7.0/mods-available/pgsql.ini with new version
Creating config file /etc/php/7.0/mods-available/pdo_pgsql.ini with new version
Setting up php-pgsql (1:7.0+35ubuntu6) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Processing triggers for libapache2-mod-php7.0 (7.0.15-0ubuntu0.16.04.4) ...

Restart the apache web server using the systemctl command and run it.

root@linuxhelp:~# systemctl restart apache2

Open the browser and navigate to following URL http://192.168.7.234/mywebsql. The MyWebSQL login page appears. Enter the required credentials and hit login.

The MyWebSQL is running successfully. Now the user can manage the database, tables and schemas.

Wasn' t it an easy installtion procedure? The MyWebSQL is based on the WYSIWYG MySQL client written in PHP.