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

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

Hostinger
$2.99 /mo
Starting price
Visit Hostinger
Rating based on expert review
  • User Friendly
    4.7
  • Support
    4.7
  • Features
    4.8
  • Reliability
    4.8
  • Pricing
    4.7
IONOS
$1.00 /mo
Starting price
Visit IONOS
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.0
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.3
Ultahost
$2.90 /mo
Starting price
Visit Ultahost
Rating based on expert review
  • User Friendly
    4.3
  • Support
    4.8
  • Features
    4.5
  • Reliability
    4.0
  • Pricing
    4.8

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

How to Install MYSQL 8.0 and Create a Database on a CentOS 7 Linux VPS or Dedicated Server

MySQL is one of the mostly utilized open source database platform globally. This
3 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert

How to Install the LEMP (Linux, Nginx, MySQL, PHP) Stack on CentOS 7 VPS or Dedicated Server

LEMP is an acronym for Linux, Nginx, MySQL and PHP. LEMP stack just like LAMP st
5 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to install Zabbix on CentOS 7

This tutorial will help you install Zabbix; a high-performance network monitorin
3 min read
David Malcom
David Malcom
Author

How to Run ProxySQL Against MySQL for Monitoring on CentOS 7

ProxySQL serves to monitor and filter; as a firewall all incoming requests from
3 min read
Kennedy Mbuvi
Kennedy Mbuvi
Author
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top