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.
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.
- Get answer to all of your queries about best VPS hosting by clicking here.
