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 &hellip &hellip &hellip 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 &hellip &hellip 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.
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
&hellip
&hellip
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.
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 &hellip -rw-r--r-- 1 root root 8479 Apr 22 2014 install.php &hellip 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 &hellip -rw-r--r-- 1 root root 8479 Apr 22 2014 install1.php &hellip 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.
Create a new database.
Then import the table data from an external file.
Click on Database Manager to manage databases.
SQL Editor
"SQLite Client library is not installed". What do I need to install on the server?