How to Install MyWebSQL in CentOS

To Install MyWebSQL in CentOS

MyWebSQL is an open source web-based client used for managing databases. It is designed with simple interface and supports all major web browsers like Chrome, Firefox, Opera and Safari. It allows the users to create and edit the table structure without writing queries. Installation of MyWebSQL in CentOS is explained in this article.

 

Installation of MyWebSQL

Before installing MyWebSQL, you need to install LAMP server with the following link.

https://www.linuxhelp.com/install-lamp-fedora-22/

 

Download the MyWebSQL installation package.

[root@linuxhelp Desktop]# wget http://downloads.sourceforge.net/project/mywebsql/stable/mywebsql-3.4.zip
--2016-11-21 18:18:44--  http://downloads.sourceforge.net/project/mywebsql/stable/mywebsql-3.4.zip
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://excellmedia.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.4.zip [following]
--2016-11-21 18:18:44--  http://excellmedia.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.4.zip
Resolving excellmedia.dl.sourceforge.net... 202.153.32.19
Connecting to excellmedia.dl.sourceforge.net|202.153.32.19|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1892999 (1.8M) [application/octet-stream]
Saving to: “mywebsql-3.4.zip”
100%[======================================================================================>] 1,892,999   59.7K/s   in 22s     
2016-11-21 18:19:12 (84.0 KB/s) - “mywebsql-3.4.zip” saved [1892999/1892999]


Extract the downloaded package with the following command.

[root@linuxhelp Desktop]# unzip mywebsql-3.4.zip -d /var/www/html/
Archive:  mywebsql-3.4.zip
  inflating: /var/www/html/mywebsql/.htaccess  
   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  
…
…
…
  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  
Then use the below command to install a PHP module.

[root@linuxhelp Desktop]# yum install php-pgsql
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.fibergrid.in
…
…
Installed:
  php-pgsql.x86_64 0:5.3.3-48.el6_8                                                                                             
Dependency Installed:
  postgresql-libs.x86_64 0:8.4.20-6.el6                                                                                         
Complete!

Restart the Apache web server to take effect.

[root@linuxhelp Desktop]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

Once the above process is completed, open the web browser with IP address to check the output.

1

You can see that math library is not available in the above snap. So install the respective library package.

[root@linuxhelp Desktop]# yum install php-bcmath
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.fibergrid.in
…
…
Running Transaction
  Installing : php-bcmath-5.3.3-48.el6_8.x86_64                                                                             1/1 
  Verifying  : php-bcmath-5.3.3-48.el6_8.x86_64                                                                             1/1 
Installed:
  php-bcmath.x86_64 0:5.3.3-48.el6_8                                                                                            
Complete!

Again restart the Apache web server to take effect.

[root@linuxhelp Desktop]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

Go back to the web browser and reload the page, now you can see the dependency problem gets solved.

2

 

Here you need to rename the install.php file with some other name.

[root@linuxhelp Desktop]# cd /var/www/html/mywebsql/
[root@linuxhelp mywebsql]# ls -l
total 88
drwxr-xr-x  2 root root  4096 Apr 23  2014 backups
-rw-r--r--  1 root root  2275 May 27  2013 cache.php
…
-rw-r--r--  1 root root  8479 Apr 22  2014 install.php
…
drwxr-xr-x 11 root root  4096 Apr 23  2014 themes
drwxr-xr-x  2 root root  4096 Apr 23  2014 tmp
[root@linuxhelp mywebsql]# mv install.php install1.php
[root@linuxhelp mywebsql]# ls -l
total 88
drwxr-xr-x  2 root root  4096 Apr 23  2014 backups
-rw-r--r--  1 root root  2275 May 27  2013 cache.php
…
-rw-r--r--  1 root root  8479 Apr 22  2014 install1.php
…
drwxr-xr-x 11 root root  4096 Apr 23  2014 themes
drwxr-xr-x  2 root root  4096 Apr 23  2014 tmp

Again restart the Apache web server to take effect.

[root@linuxhelp Desktop]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

Go back to the web browser and enter http://<IP_address>/mywebsql.  Login with the MySQL root user credentials.

3

 

Create a new database.

4

 

Then import the table data from an external file.

5

 

Click on Database Manager to manage databases.

6

SQL Editor

7


Thank you! for using Linux Help.

You find this tutorial helpful? Share with your friends to keep it alive.
For more help topics browse our website www.linuxhelp.com
Be the first to comment, we value your suggestions. For further queries please comment below.

Tags: MyWebSQL
user image Author :  Elijah