How to Install MyWebSQL on a CentOS 7 VPS or Dedicated Server


Introduction

MyWebSQL is a MySQL management interface that runs on the web and written in PHP. It allows for a user to manage their databases on the web which is a good alternative to the desktop GUI version. Sometimes it comes as an advantage because using the command line, especially to the new users, may prove to be a cumbersome task.

Some advantages offered by MyWebSQL includes:

  • It is free and open source
  • It is fast and efficient
  • It is easy to install as it is also part of the AMPPS stack

Prerequisites

  • A VPS or Dedicated Serverwith a fresh installation of CentOS 7
  • A non-root user configured with sudo privileges

Steps

Update System Packages

$ sudo yum update -y && sudo yum upgrade -y

Install Dependencies

$ sudo yum install wget zip -y

Install LAMP stack

This is a web service stack composed of the three open source software components that run in a linux environment. They include:

  • Apache Server which is a HTTP server.
  • MySQL which is an open source database management system.
  • PHP programming language.

These three components work together to run both static and dynamic websites. You can learn How to Install LAMP stack on CentOS 7 if you haven’t set it up yet.

Start the LAMP Stack

$ sudo systemctl start httpd
$ sudo systemctl start mariadb

Install MyWebSQL

$ wget https://phoenixnap.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip

Extract the downloaded file and move it to your site directory

$ sudo unzip mywebsql-3.7.zip -d /var/www/

Change the mywebsql folder ownership from root user to apache user. To confirm the processes run by apache user, type in the following command.

$ sudo ps aux | egrep '(apache|httpd)'root      2031  0.0  0.4 224024  4996 ?        Ss   13:40   0:00 /usr/sbin/httpd -DFOREGROUND
apache    2032  0.0  0.2 224024  2956 ?        S    13:40   0:00 /usr/sbin/httpd -DFOREGROUND
apache    2033  0.0  0.2 224024  2956 ?        S    13:40   0:00 /usr/sbin/httpd -DFOREGROUND
apache    2034  0.0  0.2 224024  2956 ?        S    13:40   0:00 /usr/sbin/httpd -DFOREGROUND
apache    2035  0.0  0.2 224024  2956 ?        S    13:40   0:00 /usr/sbin/httpd -DFOREGROUND
apache    2036  0.0  0.2 224024  2956 ?        S    13:40   0:00 /usr/sbin/httpd -DFOREGROUND
linuxus+  5550  0.0  0.0 112704  992 pts/0    R+   14:16   0:00 grep -E --color=auto (apache|httpd)

Now change the ownership accordingly

$ sudo chown -R apache:apache /var/www/html/mywebsql
$ sudo chmod -R 755 /var/www/html/mywebsql/

Restart httpd service

$ sudo systemctl restart httpd

Go to http://YOUR_IP_ADDRESS/mywebsql while replacing YOUR_IP_ADDRESSwith your appropriate IP address. You should see a screen similar to the figure below.

To login, you should use your mariadb/mysql root account credentials which you can learn to set up in here.

How to Install MyWebSQL on CentOS 7

Conclusion

You can start exploring the various features offered by MyWebSQL; create a database, tables, edit, delete them etc. It is important to have a strong root password for security purposes. Alternatively, you may choose to install the software via Ampps.

Check out these top 3 Best web hosting services

You can learn How to install AMPPS on CentOS 7 here.

Was this article helpful?