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.
Comments ( 0 )
No comments available